topic Re: getting values from select option in Application Development and Automation Discussions

getting values from select option

Former Member — Thu, 07 Sep 2006 14:32:28 GMT

Hi,

I have a requirement where the user is going to pass values in select-option in low and high. lets say s_bwart(movement types).

now i have to fetch this bwart values into an internal table.

my internal table will be having only one field that is bwart. so how do i populate my internal table with those values. could any body help me in this.

Thanks in advance

neha

Re: getting values from select option

Former Member — Thu, 07 Sep 2006 14:34:06 GMT

move s_bwart-low to itab-bwart.

append itab.

move s_bwart-high to itab-bwart.

append itab.

But why move to new table?

Re: getting values from select option

Former Member — Thu, 07 Sep 2006 14:36:18 GMT

hi Neha,

do this way ..

at selection screen.
select bwart from <Table> into table itab where bwart in s_bwart.

this way it fetches all the bwart values within the range of s_bwart.

Regards,

Santosh

Re: getting values from select option

Former Member — Thu, 07 Sep 2006 14:37:54 GMT

Hi,

start-of selection.

if not b_bwart[] is initial.

loop at s_bwart.

if s_bwart-sign = 'BT'.

itab-bwart = s_bwart-low.

append itab.

itab-bwart = s_bwart-high.

append itab.

else.

itab-bwart = s_bwart-low.

append itab.

endif.

Regards

Amole

Re: getting values from select option

Former Member — Thu, 07 Sep 2006 14:38:34 GMT

I think I misunderstood the question. If the user is using your select option to provide a range and you need all values within that range, then use the solution provided by Santosh.

Re: getting values from select option

Former Member — Thu, 07 Sep 2006 14:38:54 GMT

hi Neha,

This can be achieved but why do you want to move all the values between s_bwart-low and high into an internal table. What is the exact requirement? Select-options allows you to choose the value as per your requirement.

Like...

- you can select between low and high.

- you can select two or more distinct values by selecting the arrow and filling the values in the table control. thus the selection only contains the values filled in there.

- you can choose excluing any value... and so on.

select bwart 
  from <table> 
  into table itab 
 where bwart in s_bwart.

Regards,

Richa

Re: getting values from select option

RichHeilman — Thu, 07 Sep 2006 14:39:59 GMT

Hi, when using SELECT-OPTIONS, use can pretty much do any kind of selection he wants, including ranges, and excluding values, so the best way to handle it is to select from the data base when the user executes the report. for example.

data: begin of ibwart occurs 0,
      bwart type mseg-bwart,
      end of ibwart.

select-options: s_Bwart for mseg-bwart.

start-of-selection.

select bwart into table ibwart 
           from <b>T156</b>
                 where bwart in s_bwart.

Regards,

Rich Heilman