‎2008 Aug 26 1:57 PM
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
‎2008 Aug 26 1:59 PM
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
‎2008 Aug 26 1:59 PM
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
‎2008 Aug 26 2:13 PM
Try this....
select f1,f2....from mara into I_TAB where matnr in material.
Regards,
Srinivas
‎2008 Aug 26 2:18 PM
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.
‎2008 Aug 26 2:18 PM
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.