TYPES: BEGIN OF lty_bkpf,
xblnr LIKE bkpf-xblnr,
END OF lty_bkpf.
DATA: li_bkpf TYPE STANDARD TABLE OF lty_bkpf
WITH HEADER LINE.
RANGES: lr_xblnr FOR bkpf-xblnr,
lr_xblnr1 FOR bkpf-xblnr,
s_bukrs FOR bseg-bukrs.
IF NOT lr_xblnr1[] IS INITIAL.
SELECT xblnr
FROM bkpf
APPENDING CORRESPONDING FIELDS OF TABLE li_bkpf
WHERE bukrs IN s_bukrs
AND bstat = ''
AND xblnr IN lr_xblnr1
AND blart EQ 'SA'.
ENDIF.
s_bukrs has a single value .
lr_xblnr1 has 3000 entries and also with wild characters. ( I CP 4903813253* ) .
the SELECT statement is going into dump with the message : DBIF_RSQL_INVALID_RSQL
" Error in the module RSQL accessing the database interface."
please suggest me alternate code to encounter this issue .
thanks,
Raghu V
Add a comment