SAP® Documentation

Single view

/LIME/CORE625 - Length exceeded (&1) in selection with value range table - /LIME/CORE 625

PERFORM Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.
SAP E-Book

Diagnosis

The selection criteria of a value range table cause a length excess.

You have specified selection criteria for locations, HUs, stock items, or serial numbers with a value range table. For executing the LIME query the values of the value range table are converted to a logical condition that is used to generate the SQL statement.

The permitted total length of an SQL statement is restricted according to the database system. By exploding the value range table, the size restrictions of the SQL statement was exceeded.

System Response

The system could not execute the LIME query.

Procedure

The length of the generated SQL statement essentially depends on the number of entries in the value range table. Check whether you can reduce the number of entries in the value range table.

Locations, HUs, stock items or serial numbers can be selected in three types:

  • Value range tables
  • BIZ tables (list of the relevant business key values)
  • GUID table

Check whether you can execute the LIME query with BIZ or with GUID tables. There is no length restriction for BIZ and GUID tables.

Procedure for System Administration






PERFORM Short Reference   CPI1466 during Backup  
This documentation is copyright by SAP AG.

Length: 1397 Date: 20191017 Time: 145932     sap01-206 ( 8 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.