topic Re: loop at is giving problem in Application Development and Automation Discussions

loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:12:29 GMT

Hello experts.

my statement is like this.

sort itab_final by matnr.

sort it_out by matnr.

loop at itab_final.

loop at it_out where matnr = itab-final-matnr.

if sy-subrc eq 0.

endif.

endloop.

clear it_out.

endloop.

In it_out i am having 2 records ie 2 materials 110 and 120. in the first loop execution 110 is matnr. it is there in both the itab_final and it_out.

After executing this statement ,

loop at it_out where matnr = itab-final-matnr.

i am getting the record into the header for material 110. but the sy-subrc is showing value 4. in the next loop for material 120 , the sy-subrc is equal to zero. so please tell me why it so happening like this. How to correct this.

Thanks for all the replies.

Re: loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:15:39 GMT

What is the need of checking the sy-subrc inside the loop.

anyhow the control get inside the loop only if the record is present.

Re: loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:17:46 GMT

C loop inside inside a loop is a big NO

Better try doin dis...

sort itab_final by matnr.

sort it_out by matnr.

loop at itab_final.

<b>read table it_out with key matnr = itab-final-matnr.</b>if sy-subrc eq 0.

endif.

endloop.

clear it_out.

endloop.

This will solve ur query..

Reward points if it does

Regards

Re: loop at is giving problem

former_member404244 — Thu, 18 Oct 2007 07:19:03 GMT

Hi,

Instead of going for nested loop why don't u use read statement.

loop at itab_final.

Read table it_out with key matnr = itab-final-matnr.

if sy-subrc eq 0.

endif.

clear : it_out,

itab_final.

endloop.

Reward if helpful.

Regards,

Nagaraj

Re: loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:19:52 GMT

hi,

put like this..

loop at it_out

loop at it_final where matnr = it_out-matnr.

if sy-subrc eq 0.

.....

....

clear it_final.

endloop

clear it_out.

Endloop.

Re: loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:20:33 GMT

Hi,

I too faced similar problem.Remove the statement:

if sy-subrc eq 0.

endif.

It will work.

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: loop at is giving problem

Former Member — Thu, 18 Oct 2007 07:20:35 GMT

Hi,

Use read statement

sort itab_final by matnr.

sort it_out by matnr.

loop at itab_final.

read table it_out with key matnr = itab-final-matnr.

if sy-subrc eq 0.

endif.

clear it_out.

endloop.

Thanks!

Brunda

'Reward if useful'.