Solution : https://service.sap.com/sap/support/notes/1567602 (SAP Service marketplace login required)
Summary :
This SAP Note details the database-specific adaptations required to support the updated MB51 application logic, referencing Notes 1516684 and 1550000. The adaptations include creating temporary and permanent indexes in the MSEG table to populate new columns and improve performance. Key changes involve the temporary MSEG~TMP index and additional indexes like MSEG~BUD, MSEG~M1, and MSEG~M2. Additionally, the note specifies conditions for extending the MSEG~M index. It also describes Oracle-specific instructions for index handling outside the SAP dictionary, employing features such as online creation and nologging for operational efficiency.
Key words :
terms mb51 mkpf mseg join performance reason, information solution db type independent part======================== 1, temporarily needed index mseg~tmp, db type specific section, high performance application logic, adapt customer indexes appropriately, db layer create index, db specific adaptions, sobkz mseg~m1, sobkz mseg~m2
Related Notes :
| 1638997 | Performance: CKMDUVMAT selection with new fields in MSEG |
| 1598760 | FAQ: MSEG extension and MB51/MB5B redesign |
| 1550000 | MB51: Redesign of selection for performance optimization |
| 1516684 | MKPF fields added to MSEG - Performance optimization |