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 for Me (Login required).

Search for additional results

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