Skip to Content
0
Former Member
Mar 10, 2010 at 07:31 PM

using FREE_SELECTIONS_RANGE_2_WHERE

1208 Views

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