Ansicht
Dokumentation
/CWM/MM058 - Overruning lengths (&1) for selection with value range table - /CWM/MM 058
General Material Data CPI1466 during BackupThis documentation is copyright by SAP AG.
Diagnosis
The selection criteria for a value range table cause a length overrun.
You have entered selection criteria for locations or stock items with a value range table. To execute the LIME query, the values in the value range table are converted to a logical condition that is used to generate the SQL statement.
The total permitted length of an SQL statement - depending on the database system - is restricted. By expanding the value range table, the size restriction of the SQL statement was exceeded.
System Response
The system could not execute the LIME query.
Procedure
The length of the generated SQL statement generally depends on the number of entries in the value range table.
It is standard for 50 materials to be processed in a LIME query to optimize peformance (for example, for 120 selected materials, three LIME requests are executed).
To reduce the number of materials for each LIME query, the program switches the relevant selection field to "Changeable".
Enter a smaller value than the one displayed and execute the program again.
When you next call this program, the corresponding selection field will be hidden.
Procedure for System Administration
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 1366 Date: 20240423 Time: 150655 sap01-206 ( 23 ms )
