SAP Knowledge Base Article - Preview

2750901 - SAPSQL_STMNT_TOO_LARGE dump occurs while executing report RPTARQDBVIEW

Symptom

While executing the Program (report) 'RPTARQDBVIEW' the system dumps an error "SAPSQL_STMNT_TOO_LARGE" in the backend. This can also be checked via the Transaction Code ST22.

Header of the dump:

Category               ABAP Programming Error
Runtime Errors      SAPSQL_STMNT_TOO_LARGE
Except.                 CX_SY_OPEN_SQL_DB
ABAP Program       RPTARQDBVIEW

Source Code Extract from the dump:


|100|                  version_no EQ ( SELECT MAX( version_no )
|101|                                 FROM ptreq_header
|102|                                 WHERE request_id EQ h~request_id ).
|103| when cv_timestamp.
>>>>>               SELECT *
|105|                  FROM ptreq_header AS h
|106|                  INTO CORRESPONDING FIELDS OF TABLE new_tab
|107|                  WHERE
|108|                                 (lv_query) AND "N2624276
|109|**                                          h~request_id IN fguid AND "N2624276
|110|**                                          h~version_no IN fver_no AND "N2624276


Read more...

Environment

  • Human Capital Management (HCM)
  • SAP ERP Core Component
  • SAP ERP
  • SAP enhancement package for SAP ERP

Product

SAP enhancement package 1 for SAP ERP 6.0 ; SAP enhancement package 2 for SAP ERP 6.0 ; SAP enhancement package 3 for SAP ERP 6.0 ; SAP enhancement package 4 for SAP ERP 6.0 ; SAP enhancement package 5 for SAP ERP 6.0 ; SAP enhancement package 6 for SAP ERP 6.0 ; SAP enhancement package 7 for SAP ERP 6.0 ; SAP enhancement package 8 for SAP ERP 6.0

Keywords

RPTARQDBVIEW, SAPSQL_STMNT_TOO_LARGE,  CX_SY_OPEN_SQL_DB, RPTARQDBVIEW, ABAP Programming Error , KBA , PT-RC-UI-XS , Leave Self Services Web Dynpro , 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.