Hi,
I am trying to use ranges in the where clause of my select statement.
The inputs I have is an internal table say t_selflds of type RSTI_T_PAR. So if I have 2 selection options filled with values such as
sopt1 = 10 or
sopt1 = 20
sopt2 is between 20 and 50
then the values in t_selflds will be like
selname kind sign option low high
sopt1 I EQ 10
sopt1 I EQ 20
sopt2 I BT 20 50
Now I want to form a dynamic where clause using these values such that my where clause shud be like 'sopt1 IN range1 and sopt2 IN range2'.
So range1 and range2 are to be formed dynamically.
I read that we can use FREE_SELECTIONS_RANGE_2_WHERE. not sure how to form the field_ranges for this FM.
Can anyone guide me how to move the values from my t_selflds to field_ranges ?
Or if there is any other simple way to form the dynamic where clause with ranges for multiple fields, pl share.
thks