selection-screen doubt

[Former Member]

Hi Gurus,

I am creating an selection-screen where i enter some value range now when i am using this in my select statement its not reading the lower and upper limit . if i initialize this value it will read only that (eg bt 10 - 100)

i want the user to enter it during runtime.

can anyone tell me how to code this..?

selection-screen begin of block B1.

select-options material for mara-matnr.

selection-screen end of block B1.

*INITIALIZATION.

material-low = 10

material-high = 100

material-option = 'BT'

material-sign = 'I'

append material.

select f1,f2....from mara into I_TAB where matnr between material-low and material-high.

Regards,

Ravi

[Former Member]

Hi Ravi,

As also told by others you have to use IN for select-options,

it will select the range from low to high.

select f1,f2....from mara into I_TAB 
where matnr in material.

With luck,

Pritam.

[JozsefSzikszai]

hi Ravi,

you have to code like:

SELECT ...
WHERE matnr IN material.

now it will pick up the values from the selection screen.

hope this helps

ec

[Former Member]

Try this....

select f1,f2....from mara into I_TAB where matnr in material.

Regards,

Srinivas

[Former Member]

Hi,

You have to use IN in the select statement.

select <field1> <field2> from <dbtable> into table itab where matnr in material.

Thanks,

Sriram Ponna.

[Former Member]

Hi Ravi,

As also told by others you have to use IN for select-options,

it will select the range from low to high.

select f1,f2....from mara into I_TAB 
where matnr in material.

With luck,

Pritam.