Review and evaluate the use of alternate index tables before creating indexes on any existing SAP transaction tables. Matchcode tables for example M_VMVAB, M_VMVAC or matchcode views for example M_VMVAA, M_VMVAE also allow efficient data access.
Some examples of index tables: VAKGU Sales Index: Quotation Validity VAKPA Sales Index: Orders by Partner Function VAPMA Sales Index: Order Items by Material VBOX SD Document: Billing Document: Rebate Index VEPVG Delivery Due Index VETVG Delivery Due Index for Stock Transfer VKDFS SD Index: Billing Initiator VLKPA SD Index: Deliveries by Partner Functions VLPMA SD Index: Delivery Items by Material VRKPA Sales Index: Bills by Partner Functions VRPMA SD Index: Billing Items per Material VTRDI Shipment Planning Index EKKI Purchasing Condition Index EKUB Index for Stock Transport Orders for Material BSAD Accounting: Secondary Index for Customers (Cleared Items BSAK Accounting: Secondary Index for Vendors (Cleared Items) BSAS Accounting: Secondary Index for G/L Accounts (Cleared It BSIA Archive Index for FI Documents (Outdated! See ARCH_IDX) BSID Accounting: Secondary Index for Customers BSIK Accounting: Secondary Index for Vendors BSIM Secondary Index, Documents for Material BSIP Index for Vendor Validation of Double Documents BSIS Accounting: Secondary Index for G/L Accounts BSIW Index table for customer bills of exchange used BSIX Index table for customer bills of exchange used
Avoid using table VBFA (huge table). For preceding document linkages, use reference fields for e.g. tables LIPS/VBRK (fields VGBEL, VGPOS).
All product names are trademarks of their
respective companies. GenieHoldings.COM, Inc.
and it's websites are in no way affiliated with
SAP AG.
SAP,
SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps,
SAP NetWeaver, and and any other SAP trademarks
are registered trademarks of SAP AG in Germany
and in several other countries.
Every effort is made to ensure content
integrity. Use information on this site at your
own risk.
