topic Re: Read values from SELECT-OPTIONS in Application Development and Automation Discussions

Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:06:55 GMT

Please don't have a subject in ALL CAPITALS. I've changed it for you this time.

Hi,

I want to read values in a select-options one by one because I need to pass all the data between low and high.

Thanks a lot.

Sandra.

Edited by: Matt on Mar 17, 2009 11:10 AM

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:10:02 GMT

Select option is just like internal table. so as u read itab u can also read it

loop at select_option name.
read select option name index sy-tabix.
endloop.

Edited by: tahir naqqash on Mar 17, 2009 3:10 PM

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:11:36 GMT

If u want to use select statement with slect option specify the condition in where as IN s_option it will work for each value seperately,

If u want sinle values one by loop at it.

try like this.


data: wa like line of s_options.

loop at s_options into wa.

"use wa value here wa-low but this will only give values of multiple selection 
"to get values between low and high use *IN*
endloop.

кu03B1ятu03B9к

Edited by: kartik tarla on Mar 17, 2009 3:42 PM

Re: Read values from SELECT-OPTIONS

kesavadas_thekkillath — Tue, 17 Mar 2009 10:12:50 GMT

Ex:

Loop at so_date.

date1 = so_date-low.

endloop.

if u need the other interval. then so_date-high.

Re: Read values from SELECT-OPTIONS

matt — Tue, 17 Mar 2009 10:12:57 GMT

Select options don't contain the values one by one. So, you have to do a select from the appropriate table. So, if your select options is for MATNR, then you'd have to do

SELECT matnr FROM mara INTO TABLE lt_matnr WHERE matnr IN s_matnr.

matt

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:12:57 GMT

I know that, but in that internal table I only have low and high and I want to pass all values between them.

Thanks.

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:16:06 GMT

The select-options is for a date so I don't know which table I can use, but thank you all!

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:16:11 GMT

then use

select * from pa0001
where
 pernr in sel_option.
" When u use IN SEL_OPTION , it will consider all values in select option

Edited by: tahir naqqash on Mar 17, 2009 3:17 PM

Re: Read values from SELECT-OPTIONS

Former Member — Tue, 17 Mar 2009 10:16:22 GMT

i think u need to loop and check values between do endo.


v_var = s_option-low.
DO.

"use v_var.
"increment it.
if v_var > s_option-high.
exit.
else.
"use the value
endif.
enddo.

кu03B1ятu03B9к

Edited by: kartik tarla on Mar 17, 2009 3:46 PM

Re: Read values from SELECT-OPTIONS

sarbajitm — Tue, 17 Mar 2009 10:16:35 GMT

SELECT-OPTIONS system implicitly creates the select options internal table which contains the fields of SIGN,OPTION,LOW & HIGH.

Re: Read values from SELECT-OPTIONS

former_member203501 — Tue, 17 Mar 2009 10:20:49 GMT

hi look at this post ....here is your answer

i got it by searching in the forum.....please search before posting a question.

Re: Read values from SELECT-OPTIONS

I355602 — Tue, 17 Mar 2009 10:23:44 GMT

Hi,

When you use statement:


SELECT-OPTIONS : s_datum FOR sy-datum.

Then this creates an internal table s_datum with four fields sign, option, low, high.

So if you write

low value as:

sy-datum - 4

and high value as:

sy-datum

Then a single row is appended to s_datum as:

sign : I

option : BT

low value : sy-datum - 4

high value : sy-datum

So it will automatically take all values between the low and high values.

Hope this helps you.

Regards,

Tarun

Re: Read values from SELECT-OPTIONS

matt — Tue, 17 Mar 2009 10:24:16 GMT


> The select-options is for a date so I don't know which table I can use, but thank you all!

You can't use a table. Do it like this:

l_dat = s_dat-low.
WHILE l_dat LE s_dat-high.
  WRITE / l_dat.
  ADD 1 TO l_dat.
ENDWHILE

However, if the user decides to use a pattern, or exclusions, it can get problematic. Usually, therefore, for date selections, I use two parameters - one for the start date, one for the end, rather than select-options.

matt

Re: Read values from SELECT-OPTIONS

sarbajitm — Tue, 17 Mar 2009 10:26:44 GMT

Select-options: s_date for sy-datum.

data: cnt type i,

diff type i,

G_date type sy-datum.

diff = s_date-high - s_date-low

do diff times.

G_date = s_date-low + cnt.

write: / G_date.

cnt = cnt + 1.

endloop.

Re: Read values from SELECT-OPTIONS

RoySayak — Tue, 17 Mar 2009 10:28:57 GMT

Hi Sandra,

You can't use a table for date select-options.

Best Regards,

Sayak