Select Options??

[Former Member]

Hi All,

I need to create select-options for bukrs on the selection screen.

The user may give a value on the screen and also can use the pushbutton(on rt side) to specify a range of values . In the select table created i can see the row for values on the screen in low high fields, row for range in low high fields.

I need to select the data from table based on all the values and ranges entered. Can anyone pls let me know how to write the query . For general select we write like: select <> from table where bukrs IN s_bukrs.

I want to know how to fetch the data on the range specified what are we supposed to write . Do we need to loop at the select table and write the select query inside it ?

Thanks much,

[Former Member]

Hi

excuse me, but i can't understand because the statament SELECT * FROM ... WHERE BUKRS IN SO_BUKRS is not good for you.

Max

[Former Member]

Hello,

The statement <b>select <> from table where bukrs IN s_bukrs.</b> will automatically consider the ranges as well.

Regards,

anand Mandalika.

[Former Member]

Hi,

Your select

<b>select <> from table where bukrs IN s_bukrs.</b>holds good.

[Former Member]

hi,

i think ur select statement will do that , no need to loop.

select <> from table where bukrs IN s_bukrs.

[Former Member]

select * from The_Table into table MY_TABLE where bukrs IN s_bukrs.

S_BUKRS is the select-options screen field.

[Former Member]

Hi,

no need to loop any thing.

just specify like this...

select * from mara
      into table it_mara 
    <b>where matnr in s_matnr.</b>

this will take care of every thing.

Regards

Vijay

[Former Member]

Thanks All...!!

[Former Member]

Hello,

It woukld be nice if you could close this thread. You can do that by awarding 10 points (Solved Problem) to the quickest answer that has given you the correct answer.

Regards,

Anand Mandalika.