topic Re: Avoiding Nested Loops ? in Application Development and Automation Discussions

Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:17:38 GMT

Hi,

Pls suggest a way to avoid the nested loops of this kind.

itab1 and itab2 are internal tables with header line.


 loop at itab1.
  loop at itab2 where fld1 = itab1-fld1.
<a few statements here>
  endloop.
 endloop.

Useful help would be rewarded.

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:21:08 GMT

hi,

you can replace with the read statement, provided you need only one matching record from the internal table.

loop at itab1.

read table itab2 with key fld1 = itab1-fld1.

endloop.

if you have more than one matchin record, then use parallel cursor method. see the sample code [here|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/abap%2bcode%2bfor%2bparallel%2bcursor%2b-%2bloop%2bprocessing]

regards,

madhumitha

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:21:53 GMT

Hi,

If it is a one - one relation with itab1 then use Read statement and do your logic

If its like item header relation

loop item table and read header table.

Regards,

Siva chalasani.

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:23:26 GMT

Try using a single LOOP, with a READ TABLE inside!

Like this:



LOOP AT itab1.

READ TABLE itab2 WITH KEY fld1 = itab-fld1
BINARY SEARCH.

<statements>

ENDLOOP.

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:23:33 GMT

Hi Siva and Madhumita,

Thanks a lot for your input, but its not a one-one relationship, so i cant use a READ statement.

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:24:43 GMT

Hi,

loop at itab1.

loop at itab2 where fld1 = itab1-fld1.

endloop.

Instead of above code try with this code.

read table itab2 .

if itab-fld1 = itab2-fld1.

Endif.

Endloop.

Reward if useful.

Regards,

Narasimha

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:25:19 GMT

then use parallel cursor method:(sample code in the below link)

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/abap%2bcode%2bfor%2bparallel%2bcursor%2b-%2bloop%2bprocessing

regards,

madhu

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 12:26:32 GMT

Hi,

loop at itab1.

loop at itab2 where fld1 = itab1-fld1.

endloop.

Instead of above code try with this code.

loop at itab1.

read table itab2 .

if itab-fld1 = itab2-fld1.

Endif.

Endloop.

Reward if useful.

Regards,

Narasimha

Re: Avoiding Nested Loops ?

Former Member — Thu, 15 May 2008 13:04:02 GMT

Hi Madhu...

Thanks a lot for your help.