Solution : https://service.sap.com/sap/support/notes/918992 (SAP Service marketplace login required)
Summary :
Users utilizing Transaction MB5B or RM07MLBD report on MSSQL face severe performance issues, primarily due to suboptimal database access plans and inefficient internal table operations. Specifically, the system struggles with extended runtimes or potential TIME_OUT errors when processing large volumes of MM documents due to unoptimized queries and merging of internal table entries. SAP Note 902157 must be implemented as a prerequisite, and improvements include optimized merging of internal tables and tailored database accesses for MSSQL, addressing issues like poor SQL execution plans. Corrections are delivered via Support Packages, with additional source code adjustments required for RM07MLBD and associated include reports.
Key words :
database system mssqltransaction mb5b, database system mssqlthere, database system mssqlfor, symptom runtime problemyou, material master records, time_out runtime error, sql trace shows, runtime problemthe merging, assigned support packages, special database systems
Related Notes :
| 944522 | MB5B: No minus signs in goods issues |
| 921165 | MB5B: Improving the runtime using database hints |
| 902157 | MB5B: Improving the runtime using database hints/4.70 |
| 855943 | ORA-01756: "quoted string not properly terminated" |