Solution : https://service.sap.com/sap/support/notes/1516684 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues related to the processing of material documents, specifically long runtimes and termination errors ("TIME_OUT"). The inefficiency stems from executing SELECT statements across the MKPF and MSEG tables, due to their sizable data volume. To resolve this, the note proposes structural modifications and redundancies: crucial fields from MKPF are redundantly appended to MSEG, improving query performance. Detailed steps include the addition of fields to MSEG, creation of indices, and running a conversion report to update MSEG with MKPF data. Key precautions include never setting the INIT indicator during field addition and implementing conversions sequentially as prescribed.
Key words :
data field data type vgart_mkpf vgart budat_mkpf budat cpudt_mkpf cpudt cputm_mkpf cputm usnam_mkpf usnam xblnr_mkpf xblnr tcode2_mkpf tcodeimportant, field data elementmandt mandtaction char50status char1entry_date datumentry_time uzeitusername unamerepid repidsapint char1select mandt, field data elementmandt mandtaction char50status char1entry_date datumentry_time uzeitusername unamerepid repidsapint char13, data field data typevgart_mkpf vgartbudat_mkpf budatcpudt_mkpf cpudtcputm_mkpf cputmusnam_mkpf usnamxblnr_mkpf xblnrtcode2_mkpf tcodeimportant, delivery class sdisplay/maintenance alloweddata class appl0size category 0add, software component sap_appl sap application, processing]material documentyearplantmovement typeblock sizenumber, update mode]update msegif, data types, table changesuse transaction se11
Related Notes :
| 1756236 | MBGR: Redesign of selection for performance optimization |
| 1679885 | MB02: Changes in field XBLNR not updated in MSEG |
| 1638997 | Performance: CKMDUVMAT selection with new fields in MSEG |
| 1598760 | FAQ: MSEG extension and MB51/MB5B redesign |
| 1567602 | DB dependent steps to support the redesign of MB51 |
| 1558298 | MB5B: Redesign of selection for performance optimization |
| 1550000 | MB51: Redesign of selection for performance optimization |