please help in this dump analysis, how to solve this
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.
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.
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.