Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

selection-screen doubt

Former Member
0 Likes
604

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

1 ACCEPTED SOLUTION
Read only

JozsefSzikszai
Active Contributor
0 Likes
584

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

4 REPLIES 4
Read only

JozsefSzikszai
Active Contributor
0 Likes
585

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

Read only

Former Member
0 Likes
584

Try this....

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

Regards,

Srinivas

Read only

Former Member
0 Likes
584

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.

Read only

Former Member
0 Likes
584

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.