topic Re: Alternative for nested loops in Application Development and Automation Discussions

Alternative for nested loops

Former Member — Fri, 19 Jun 2009 14:25:22 GMT

Hi Gurus,

I have the following problem :

There are 2 internal tables namely 1 &2.

Now there is a field in table 1 'AUGBL' which should be equal to field in Table2-BELNR.

Now if there is a match between TABLE1-AUGBL and TABLE2-BELNR,

so we move to table 2 to look for 'augbl' associated with 'belnr' in the same table.

Then I have to give the following logic -

If table2-belnr = table2-augbr,

Then do nothing.

Else.

Check, for the Augbl which will equal Belnr in a different position in table 2.

For ex:

Table1-AUGBL = 2.

So now we have to search a field when Table1-augbl = Table2-belnr = 2.

Now for this record in table2, there are 2 conditions:

When Table2-augbl = 2, (in which case we do nothing)

or,

Table2-augbl NE 2, or Table2-augbl = 3.

In the latter case, there will be another field in Table2-BELNR = 3. So we go to this record now and check for the associated AUGBL and do the same checks above.

We keep on continuing for this till the time we do not get the Table2-belnr = Table2-augbl in the end for the same record.

Now I want to achieve this without using nested loop.

Kindly help as I already have wated a lot of time.

Please let me know if there are any clarifications.

Re: Alternative for nested loops

Former Member — Fri, 19 Jun 2009 14:32:11 GMT

Try to use Join in select query with common fields..

or send the query you used so we wil try to optimize and send the better solution..

Re: Alternative for nested loops

Former Member — Fri, 19 Jun 2009 14:32:46 GMT

Please see [The Performance of Nested Loops|/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops]

Rob

Re: Alternative for nested loops

Former Member — Fri, 19 Jun 2009 14:41:34 GMT

Hey..

Before u get the data into two internal tables through SELECT stmts.

U can use JOIN instead of two SELECT stmts ..that wud fetch the data into single internal table..

and that may ease ur validations and further process..

try this out..

Thanks and Regards,

Re: Alternative for nested loops

Former Member — Fri, 19 Jun 2009 14:57:45 GMT

Hi,

Thanks for the reply but I do need both of the tables for some other reasons. I am not selecting data in them, but putting data in them based on certain restrictions.

Re: Alternative for nested loops

former_member156446 — Fri, 19 Jun 2009 16:41:02 GMT

This works

loop at itab into wa_itab1.

read table itab2 into wa_itab2 index sy-index / sy-tabix. " (optional: Binary search with sort )
if sy-subrc eq 0.

endif.

endloop.

Re: Alternative for nested loops

Former Member — Wed, 24 Jun 2009 09:17:49 GMT

Thanks.