Solution : https://service.sap.com/sap/support/notes/902675 (SAP Service marketplace login required)
Summary :
SAP Note addresses the issue of high runtime in transaction MB51 or report RM07DOCS, often leading to a TIME_OUT error due to inefficient database access when processing large volumes of MM documents. The solution involves implementing corrections from SAP Note 918991, which adds database-specific hints to optimize the SELECT command queries involving MKPF and MSEG tables. This includes options for better database access based on material number and posting date, with explicit solutions for DB2, DB6, Informix, MaxDB, and ORACLE. Additional corrections involve source code adjustments, new text symbols for selection screens, and archiving recommendations to manage old MM documents effectively.
Key words :
runtime 092 database determines optimum access 093 access, component mm-im-gf-perf, system issues warning message m7 895, match selections source code correctionscorrect, system issues message db 634, symbol text 091 determine database access, database determines optimum access, time_out runtime error occurs, archivingif runtime problems occur, taking special database systems
Related Notes :
| 921164 | MB51: Improving the runtime using database hints |
| 918991 | MB51: Improvements/additions Note 902675/4.70 |
| 902157 | MB5B: Improving the runtime using database hints/4.70 |
| 902042 | DBSL: Hint and profile parameter for "substitute literals" |
| 855943 | ORA-01756: "quoted string not properly terminated" |
| 772497 | FAQ: Oracle Hints |
| 215435 | MB51: Procedure for regeneration |
| 106047 | DB21: Customizing the DBSTATC |