topic Re: Select Options?? in Application Development and Automation Discussions

Select Options??

Former Member — Mon, 27 Mar 2006 14:47:35 GMT

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,

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:52:49 GMT

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

Max

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:53:06 GMT

Hello,

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

Regards,

anand Mandalika.

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:53:11 GMT

Hi,

Your select

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

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:53:33 GMT

hi,

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

select <> from table where bukrs IN s_bukrs.

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:54:01 GMT

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

S_BUKRS is the select-options screen field.

Re: Select Options??

Former Member — Mon, 27 Mar 2006 14:54:24 GMT

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

Re: Select Options??

Former Member — Mon, 27 Mar 2006 15:09:20 GMT

Thanks All...!!

Re: Select Options??

Former Member — Mon, 27 Mar 2006 15:28:47 GMT

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.