topic Re: Loop inside a Loop in Application Development and Automation Discussions

Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:12:35 GMT

Can I know that is there any other way, to avoid using Loop inside a Loop?

Thanks

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:14:55 GMT

u can use the read statement instead of multiple loops... thats the one good solution

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:19:12 GMT

The second table has more than one similar record so I cant use a READ inside the first Loop.

Any way I can avoid using Loop inside the Loop ?

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:21:54 GMT

Use the read statement and give the condition what differentiates one similar record from the other

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:32:28 GMT

ok,,let me explain a bit more..

Say my first internal table as coulmns as material number and plant

And my second internal table as materail numbers and it corresponding characteristics ie. one material number has more than one characteristics.

So I cant read on second internal table with key only as material number (which is known to me) ie, In this case I need to do a Loop inside a Loop to check for every characteristic for a material.

And I want to avoid doing that.

I hope I am clear to you.

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:34:15 GMT

I think there's no other option rather than using LOOP inside LOOP here.

To make it more effective you can use:

LOOP AT ITAB1.

LOOP AT ITAB2 WHERE MATNR = ITAB1-MATNR.

....

ENDLOOP.

Second option would be to join these 2 tables on Material Number and get data into single internal table:

SELECT * INTO ITAB

FROM TABLE1 INNER JOIN TABLE 2

ON TABLE1_{MATNR = TABLE2}MATNR.

Reward points if useful.

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:39:41 GMT

In that case u have to use the loop inside the loop two loops does not make that much difference in performance if u have more than two loops that makes the difference i guess....

Re: Loop inside a Loop

Former Member — Fri, 22 Jun 2007 22:44:24 GMT

What if there are more than 2 loops,,how can we handle it?

I think I need to do that also later in my program.

Thanks

Re: Loop inside a Loop

former_member194669 — Fri, 22 Jun 2007 22:56:50 GMT

Hi,

May be this way.


loop at i_mara.
  do.
    read table i_mara_characteristics wuth key matnr = i_mara-matnr.
    if sy-subrc eq 0.
       <<< whatever you want to do >>>
       delete i_mara_characteristics index sy-tabix.
    else.
       exit.
    endif.
  enddo.
endloop.

aRs

Re: Loop inside a Loop

Former Member — Fri, 31 Dec 2010 14:19:48 GMT

This message was moderated.