i am using ranges as follows, but it is not giving me desired result, pls correct me if i am doing something wrong.
values are changed, i want to know is this right way to use ranges with select.
IF var1 NE 'y'.
r_risklevel-low = abc.
r_risklevel-sign = 'I'.
r_risklevel-option = 'EQ'.
APPEND r_risklevel.
ENDIF.
IF var2 NE 'y'.
r_status-low = xyz.
r_status-sign = 'I'.
r_status-option = 'EQ'.
APPEND r_status.
ENDIF.
SELECT * FROM dbtable
INTO TABLE itab
WHERE priority IN r_risklevel AND
status IN r_status.
regards.