SAP ABAP Message Class /LIME/CORE Message Number 625 (Length exceeded (&1) in selection with value range table)
Hierarchy
SAP_AP (Software Component) SAP Application Platform
   AP-LIM (Application Component) AP-LIM Logistics Inventory Management Engine
     /LIME/PLT_CORE (Package) Platform - Core
Attribute
Message class /LIME/CORE  
Short Description LIME - Messages from Function Group /LIME/CORE    
Message Number 625  
Documentation status       Space: object requires documentation
Authorization check Error Message      
Changed On 20050409   
Message Text
Length exceeded (&1) in selection with value range table
Help Document

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

History
Last changed on/by 20130528  SAP 
SAP Release Created in