topic Re: Avoiding select from a deep structure in a loop in Application Development and Automation Discussions

Avoiding select from a deep structure in a loop

Former Member — Tue, 01 Jul 2014 04:49:15 GMT

Hi All,

I have a 3 level deep structure from which I have to select data. I need to use select statement outside the loop, but not able do that. i'm able to do select within the loop (using field-symbols) only.

please help me in this regard.

Regards,

SriLalitha.

Re: Avoiding select from a deep structure in a loop

Former Member — Tue, 01 Jul 2014 05:05:47 GMT

Hi Sri Lalitha,

Please try like below code.

select <fields>

--------

from <tbname>

into <mainstructure>-<subsrtucture>

where <condition>.

Regards,

Venkat.

Re: Avoiding select from a deep structure in a loop

Former Member — Tue, 01 Jul 2014 05:09:03 GMT

Hi,

I want to select from a deep structure to avoid its usage in a loop.

Thanks & Regards,

SriLalitha

Re: Avoiding select from a deep structure in a loop

Former Member — Tue, 01 Jul 2014 05:42:02 GMT

Create separate internal table like internal structure, and then select the data.

data newtable like table of struture2

newtable = stucture1-structure2.

read newtable into workarea with key <condition>.

Re: Avoiding select from a deep structure in a loop

former_member730258 — Tue, 01 Jul 2014 06:20:54 GMT

Use SELECT outside the loop using FOR ALL ENTRIES, then use READ TABLE within the loop.

Example:

SELECT * FROM table1

INTO result_tab

FOR ALL ENTRIES IN ref_tab

WHERE column1 = ref_tab-col1.

LOOP AT ref_tab ASSIGNING <fs>.

READ TABLE result_tab WITH KEY column1 = <fs>-col1.

ENDLOOP.