topic loop through organization unit selected in select options in Application Development and Automation Discussions

loop through organization unit selected in select options

Former Member — Mon, 26 Mar 2007 13:53:29 GMT

Hi,

i need to get all organization units selected in select options(i have a table with sign, option, low, high fields). Is there any function module or should i use st like:

- with fm SELECT_OBJECTS_FOR_OTYPE get all org units and from this units take all units which corresponds selection criteria?

thanks

Re: loop through organization unit selected in select options

Former Member — Mon, 26 Mar 2007 14:17:30 GMT

Hi!

It's not recommendet to process a select option within a LOOP. There are many options, which makes it though to process.

Try always using the "IN" statement.

For example:

SELECT * FROM t001

INTO TABLE gt_t001

WHERE bukrs IN so_bukrs. "<<< IN

ANd after a select like this, you can use the internal table, with the FOR ALL ENTRIES, during other selects.

Regards

Tamá

Re: loop through organization unit selected in select options

Former Member — Mon, 26 Mar 2007 14:19:10 GMT

Do you want the Org. Units entered in the Select-options.

Then you can use the select-option itself for that naaa....

It is having the 4 fields you have soecified and you can use select-options as a normal internal table....

Re: loop through organization unit selected in select options

Former Member — Mon, 26 Mar 2007 14:58:08 GMT

But what to do when user selects some interval of ids?

Re: loop through organization unit selected in select options

Former Member — Mon, 26 Mar 2007 15:21:59 GMT

Hi,

You can use Between condition in Where class.

Ex.

select fields from table where field between select-option-low and select-option-high.

Regards,

Bhaskar