topic Re: loop thru select options in Application Development and Automation Discussions

loop thru select options

Karan_Chopra_ — Wed, 20 Jun 2007 05:42:25 GMT

i have to loop thru select option and assign all the values to a variable.

plz help me out

Re: loop thru select options

Karan_Chopra_ — Wed, 20 Jun 2007 05:44:58 GMT

plz help

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 05:45:01 GMT

hi,

try this,

SELECT-OPTIONS s_plant FOR marc-werks .

INITIALIZATION.

s_plant-low = '1000'.

s_plant-high = '2000'.

s_plant-sign = 'I'.

s_plant-option = 'BT'.

APPEND s_plant.

reward points if helpful,

seshu.

Re: loop thru select options

Karan_Chopra_ — Wed, 20 Jun 2007 05:46:34 GMT

i hav to suplpy all these values to a variable in a function module thru export

Message was edited by:

Karan Chopra

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 05:47:39 GMT

First get all the records from database table for select option into a table and then loop through that internal table and assign to the variable you want..

or you can do like this..

LOOP AT so_keyfu.

ls_iobj-iobjnm = so_keyfu-low.

APPEND ls_iobj TO lt_iobj.

ENDLOOP.

Re: loop thru select options

Sandeep_Panghal — Wed, 20 Jun 2007 05:47:59 GMT

Hi Karan,

Do you need to loop at select option and capture these values in any variable.

dat a: l_var type select option filed.

if not s_input[] is initial.

Loop at s_input .

l_var = s_input-low.

endloop.

endif.

reward if helps.

Re: loop thru select options

Karan_Chopra_ — Wed, 20 Jun 2007 05:49:27 GMT

i am still not gettin guys ....sry

i am able to loop only once even if i enter 20 values e.g

1 to 20

Message was edited by:

Karan Chopra

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 05:51:30 GMT

karan,

DATA : v_temp like marc-werks.

SELECT-OPTIONS s_plant FOR marc-werks .

LOOP At s_plant.

move s_plant-low to v_temp .

ENDLOOP.

Don't forget to reward if useful...

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 05:55:35 GMT

karan,

DATA : c like marc-werks.

SELECT-OPTIONS s_plant FOR marc-werks .

LOOP At s_plant.

move s_plant-low to v_temp .

call Function 'Name'

export

xcxcx = v_temp.

ENDLOOP.

Note : xcxcx and v_temp should have same data type.

Don't forget to reward if useful...

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 05:57:22 GMT

Hi Karan,

You can loop at select options and simultaneously move the values to variables

if it is of the type "I" "EQ". i.e. in the form of a range.

This you can do as follows:

report.

tables vbak.

data: begin of t_vbeln occurs 0,

vbeln type vbak-vbeln,

end of t_vbeln.

select-options : s_vbeln for vbak-vbeln.

loop at s_vbeln.

t_vbeln-vbeln = s_vbeln-low.

append t_vbeln.

endloop.

here s_vbeln-low can also be assigned to a variable.

As far as I think, if however, the select options, is of the type I BT ie a value range like 100 to 200, then you have to code a logic with a counter.

Regs,

Sameer

Re: loop thru select options

Karan_Chopra_ — Wed, 20 Jun 2007 06:15:31 GMT

no it is not looping thru select option

the loop occurs only once even if i enter it for 20 values

Re: loop thru select options

S0025444845 — Wed, 20 Jun 2007 06:31:56 GMT

hi,

try with this code.

just copy paste n run.

tables: vbrk.

select-options: s_plant for vbrk-bukrs.

types: begin of ty_plant,

bukrs type vbrk-bukrs,

end of ty_plant.

data: it_plant type standard table of ty_plant,

wa_plant type ty_plant.

at selection-screen.

loop at s_plant.

move s_plant-low to wa_plant.

append wa_plant to it_plant.

clear wa_plant.

move s_plant-high to wa_plant.

append wa_plant to it_plant.

clear wa_plant.

endloop.

regards,

sudha.

reward points if useful.

Re: loop thru select options

Former Member — Wed, 20 Jun 2007 06:59:02 GMT

Hi Karan,

Forward to my previous answer..

If you want to loop at a select option in which the values are like 1 to 200..

There is NO DIRECT WAY of doing it.

You will have to loop and select s_vbeln-low in a variable. (see my prev post)

then s_vbeln-high in another.

And then put a logic to increment the values in a DO-ENDDO loop.

say it s_vbeln is 10 to 20.

do 10 times low (10) plus 1 (the difference) and move it to variables.

Regs,

Sameer

Re: loop thru select options

Karan_Chopra_ — Thu, 21 Jun 2007 05:03:52 GMT

still confused plzzz help

Re: loop thru select options

S0025444845 — Thu, 21 Jun 2007 05:23:28 GMT

hi,

try with this code.

just copy paste n run.

tables: vbrk.

select-options: s_plant for vbrk-bukrs.

types: begin of ty_plant,

bukrs type vbrk-bukrs,

end of ty_plant.

data: it_plant type standard table of ty_plant,

wa_plant type ty_plant.

at selection-screen.

loop at s_plant.

move s_plant-low to wa_plant.

append wa_plant to it_plant.

clear wa_plant.

move s_plant-high to wa_plant.

append wa_plant to it_plant.

clear wa_plant.

endloop.

regards,

sudha.

Re: loop thru select options

Karan_Chopra_ — Thu, 21 Jun 2007 05:30:32 GMT

its moving only high and low value into It_plant tableNOT all the values selected between them and looping only once

Re: loop thru select options

Former Member — Thu, 21 Jun 2007 05:38:26 GMT

hi,

do like this,

at selection-screen.

select * from <dbtable> into table <itab> where keyfield in s_option.

loop at <itab> into <wa>.

move <wa> to <wa1>.

append <wa1> to <itab1>.

endloop.

here in <itab1> we can find avbl fields from 1 to 20.

reward points if useful,

regards,

seshu.

Re: loop thru select options

S0025444845 — Thu, 21 Jun 2007 05:44:13 GMT

Hi,

then take the select option without intervals and do.

copy paste n run.

SELECT-OPTIONS: s_plant FOR vbrk-bukrs no intervals.

TYPES: BEGIN OF ty_plant,

bukrs TYPE vbrk-bukrs,

END OF ty_plant.

DATA: it_plant TYPE STANDARD TABLE OF ty_plant,

wa_plant TYPE ty_plant.

AT SELECTION-SCREEN.

LOOP AT s_plant.

MOVE s_plant-low TO wa_plant.

APPEND wa_plant TO it_plant.

CLEAR wa_plant.

ENDLOOP.

regards,

sudha

Re: loop thru select options

Former Member — Thu, 21 Jun 2007 05:47:40 GMT

Hi Karan,

U r right .IT will loop only once if u loop at the select option.

What i guess u can do is select ur values not from the select option but from the table to which this select option corresponds.For ex.

###begin of code.

data:itab like mara occurs 0 with header line.

select-option:s_matnr for mara-matnr.

At selection screen.

select matnr

into corresponding fields of itab

from mara where matnr between s_matnr-low and S_matnr-high.

#end of code.

after this i guess u will get ur values in the matnr field of table itab-matnr.

Reward if useful.

Regards,

Abhi

Re: loop thru select options

Former Member — Thu, 21 Jun 2007 05:52:06 GMT

HI karan,

try like this.......

tables: vbrk.

select-options: s_plant for vbrk-bukrs.

types: begin of ty_plant,

bukrslow type vbrk-bukrs,

bukrshigh type vbrk-bukrs,

end of ty_plant.

data: it_plant type table of ty_plant,

wa_plant type ty_plant.

at selection-screen.

loop at s_plant.

move s_plant-low to wa_plant-bukrslow.

append wa_plant to it_plant.

clear wa_plant.

endloop.

regards,

Ruchika

reward if useful...............