Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

please help in this dump analysis, how to solve this

Hello Experts....

Please analyse this dump and tell me what to do.

In selection screen

i inputted company code(bukrs),plant(werks), date for a period of one month ie 1-07-2006 to 30-07-2006.

after executing with this crietria a dump is comming with the following details.

Run-time error "DBIF_RSQL_INVALID_RSQL" occurred.

The reason for the exception is:

The SQL statement generated from the SAP Open SQL Statement violates a

restriction imposed by the database system used in R/3.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

o ...

THE CURSOR IS POINTING TO THIS select statement. so please tell me what to do and why it is comming like this.

Before this select statement i am population s_consig. and the number of entries in s_consig is 5942.

SELECT * FROM j_1iexchdr

INTO TABLE lt_j_1iexchdr

WHERE trntyp EQ 'DLFC'

AND bukrs EQ p_comp

AND werks EQ p_plant

AND kunwe IN s_consig

AND exdat IN s_date.

Not what you were looking for? View more on this topic or Ask a question