Facing problem in select statement dump DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_S

[Micro]

Hi Experts,

I am facing the problem in the select statement where it giving the short dump
DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_S.

I have searched many forms, but i found that the select option s_matnr have the limitaion 2000 entreis, but i am passing same s_matnr to other select statement with more than 2000 entries but it is not giving me any short dump.

But i am facing problem with only one select statement where if i pass select option s_matnr more than 1500 entris also giving short dump.

My select statement is:

SELECT * FROM bsim 
INTO CORRESPONDING FIELDS OF TABLE g_t_bsim_lean 
FOR ALL ENTRIES IN t_bwkey WHERE bwkey = t_bwkey-bwkey
AND matnr IN matnr
AND bwtar IN bwtar
AND budat >= datum-low.

in the internal table g_t_bsim_lean internal table contain all the fields of the table bsim with 2 fields from other table.

Please let me know whether i need to change the select statement or any other solution for this.

Thanks in advance,
Micro

[Portal]

Hi Micro,

Read the short dump and figure out what you've done wrong....maybe here?

AND budat >= datum-low.

datum-low is probably initial, since the data is in a table and not in the header of that table...this should be:

and budat in datum.

Regards,
Portal

[Golfi]

Hello Micro,

This is because in your case the WHERE clause is sent to DB with double number of where clauses, as you use also BWTAR field as second range in WHERE clause. So the DB is requested with following selects

...where ( matnr = mat1 AND bwtar = x1...) OR
         ( matnr = mat1 AND bwtar = x2...) OR
         ( matnr = mat1 AND bwtar = x3...) OR
         ( matnr = mat2 AND bwtar = x1...) OR...
 etc

Try selection on the matnr first and then limit the BWART in a loop at where.

Regards,
Golfi