SAP Knowledge Base Article - Preview

2834143 - KBA: Runtime error DBSQL_FAE_STATEMENT_TO_BIG

Symptom

  • Following dump is raised in transaction /SAPSLL/CIBD_01 

      Runtime Errors DBSQL_ /SAPSLL/CIBD_01 FAE_STATEMENT_TO_BIG 
      Except. CX_SY_OPEN_SQL_DB
      ABAP Program /SAPSLL/SAPLCIBD_INTACT
      Application Component SLL-LEG
      The SQL command for a FOR ALL ENTRIES select is too large.

      The reason for the exception is Execution of a SELECT with addition FOR ALL ENTRIES had to be terminated, as the SELECT command sent to the database is too large. The most common cause for this is that the WHERE condition also has an IN ITAB condition that contains too many conditions.

      397 *------ selektion der referenzen zu den anlieferungen
       >>>>> SELECT * FROM /sapsll/legref
      399 INTO CORRESPONDING FIELDS OF TABLE ct_legref_wl
      400 FOR ALL ENTRIES IN ct_cuhd_wl
      401 WHERE mobjt = gc_mobjr-customs_document
      402 AND guid_mobj = ct_cuhd_wl-guid_cuhd
      403 AND qallrf IN is_cibd_crit_po-qallrf
      404 AND refno IN is_cibd_crit_po-refno.


Read more...

Environment

  • Global Trade Services (GTS)
  • Global Trade Services / Logistics Services (SLL)
  • SAP Global Trade Services
  • GTS Plug_in
  • SAP R/3
  • SAP R/3 Enterprise 4.7
  • SAP ERP Central Component
  • SAP ERP
  • SAP S4 HANA S4CORE

Product

SAP ERP all versions ; SAP Global Trade Services all versions

Keywords

PO, IBD, Inbound delivery, Purchase order, /SAPSLL/CIBD_CSD_FORMS, ls_cibd_crit-refno_po, /SAPSLL/CIBD_GET_DATA, ls_cibd_crit,  /sapsll/legref , KBA , SLL-LEG-CUS-FCR , Customs: Import Processing / Free Circulation , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.