topic selection-screen doubt in Application Development and Automation Discussions

selection-screen doubt

Former Member — Tue, 26 Aug 2008 12:57:03 GMT

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

Re: selection-screen doubt

JozsefSzikszai — Tue, 26 Aug 2008 12:59:04 GMT

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

Re: selection-screen doubt

Former Member — Tue, 26 Aug 2008 13:13:48 GMT

Try this....

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

Regards,

Srinivas

Re: selection-screen doubt

Former Member — Tue, 26 Aug 2008 13:18:14 GMT

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.

Re: selection-screen doubt

Former Member — Tue, 26 Aug 2008 13:18:49 GMT

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.