Solution : https://service.sap.com/sap/support/notes/191492 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues in customer-specific enhancements when accessing SAP MM/WM tables such as MSEG, LTAP, EBAN, and RSEG. It recommends optimizing SQL queries and improving database access by correctly forming joins and accessing views, such as utilizing selection views to merge table accesses. Detailed solutions include revised query statements for accessing transport requests, material documents, purchase requisitions, and incoming invoices. Proper verification of program functionality before production use is advised to avoid unintended consequences.
Key words :
symptom customer-specific programs, fields purchasing organization ekorg, sap mm/wm tables, purchasing document category bstyp, dynamic storage bin assignment, document flow table vbfa, purchasing group ekgrp, tanum = vbfa-vbeln, tapos = vbfa-posnn, storage unit numberincorrect
Related Notes :
819324 | FAQ: SAP MaxDB SQL optimization |
766349 | FAQ: Oracle SQL optimization |
187906 | Performance: Customer developments in PP and PM |
185530 | Performance: Customer developments in SD |