Solution : https://service.sap.com/sap/support/notes/185530 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues in customer-specific programs and enhancements when accessing key SD tables like VBAK, VBAP, and others. It outlines that the R/3 System lacks secondary indexes for these tables but provides proprietary index tables such VAKPA and VAPMA, which facilitate efficient access if used correctly. Solutions include adopting correct SQL queries utilizing these indexes for operations like searching sales orders by customer number and order items by material number. It emphasizes verifying functional accuracy and maintaining sales document indexes to avoid inconsistencies, referring to Notes 128947 and 178328 for further guidance.
Key words :
important sd transaction data tables, vbfa additional key words, symptom customer-specific programs, vbeln = i_lips-vbeln correct, vbelv = i_lips-vbeln select, deliveries offer matchcode tables, sap data model, sap sd tables, vbeln = vapma-vbeln, vbeln = vlkpa-vbeln
Related Notes :
| 841758 | Procedure when you experience performance problems |
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 766349 | FAQ: Oracle SQL optimization |
| 191492 | Performance: Customer developments in MM/WM |
| 187906 | Performance: Customer developments in PP and PM |