Solution : https://service.sap.com/sap/support/notes/1550000 (SAP Service marketplace login required)
Summary :
When running transaction MB51, extended duration or terminations due to "TIME_OUT" errors can occur, particularly if a substantial number of MM documents exist in the system. The query, involving a SELECT JOIN between header and item tables, demands high system resources due to the vast data volume. The solution includes implementing Note 1516684, converting the MSEG table, enhancing MB51's integration of MKPF fields into MSEG, and activating new logic via report ZMST_FILL_MSEG_FROM_MKPF. Additionally, refining field selection for MKPF in Customizing optimizes performance, and creating new indexes as described ensures efficient implementation of the corrected MB51 logic.
Key words :
physical inventory -> reporting -> define field selection, spro -> materials management -> inventory management, symptom transaction mb51 runs, standard fields mkpf budat, select join statement, attached correction instructions, action statusmseg_conversion_completed xif, include text symbol 005, generated include rm07docs_generated, database-specific notes
Related Notes :
| 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 |
| 1516684 | MKPF fields added to MSEG - Performance optimization |
| 555893 | MB51: Preventing runtime error DBIF_RSQL_INVALID_RSQL |