Solution : https://service.sap.com/sap/support/notes/187906 (SAP Service marketplace login required)
Summary :
Poor performance issues have been identified in custom programs and user exits accessing SAP logistic tables AFRU, AFKO, AUFK, CAUFV, and RESM. The root cause is due to the lack of secondary indexes in key PP/PM flow tables, requiring a solid understanding of the SAP data model. Correct query structures and the creation of selection views for optimizing data retrieval are discussed. Examples demonstrate improvements in querying strategies, such as adjusting access paths to streamline operations. Users are cautioned to validate functional correctness before implementing suggested alternatives.
Key words :
important pp / pm flow tables, aufnr = <afru-aufnr> select rueck, rueck = <afvc-rueck>caution, resb additional key words, rsnum = <plaf-rsnum>note, kdpos = <vbap-posnr>correct, aufnr = <resb-aufnr>note, plnum = <resb-plnum> select, rsnum = <afko-rsnum>note, kdpos = <vbap-posnr> select
Related Notes :
| 819324 | FAQ: SAP MaxDB SQL optimization |
| 766349 | FAQ: Oracle SQL optimization |
| 191492 | Performance: Customer developments in MM/WM |
| 185530 | Performance: Customer developments in SD |