SAP Note 191492 - Performance: Customer developments in MM/WM

Component : Backoffice Service Delivery -

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 :

819324FAQ: SAP MaxDB SQL optimization
766349FAQ: Oracle SQL optimization
187906Performance: Customer developments in PP and PM
185530Performance: Customer developments in SD