topic Re: Append statments for multiple loop in Application Development and Automation Discussions

Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:26:20 GMT

Hi all,

I have three loops under a main loop

Loop at maintable .

loop at table1.

endloop.

loop at table2.

endloop.

loop at table3.

endloop.

my question is that i have mutiple records in the table 1,2,3

i dont know where to use my append maintable as if i use in the main loop only one record of the table

is updated

anyone there to help me

please

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:30:54 GMT

Hi Sridhar,

Declare one work area for maintable and use it at the end of all three loops, as given below.


Loop at maintable .
loop at table1.
" WA_MAINTABLE-field
endloop.
loop at table2.
" WA_MAINTABLE-field
endloop.
loop at table3.
" WA_MAINTABLE-field
endloop.
" APPEND WA_MAINTABLE to MAINTABLE.
endloop.

Instead you can even use READ statement if possible, based on your requirement.

Best Regards,

Ram.

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:33:56 GMT

Hi,

Can you please explain your question more clearly?

Regards,

Aruna

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:34:32 GMT

i have used read table only but , it is getting only record , i have used workarea ,

and the table1,2,3 has muliple records , where is it is overwriten and the final value is updated to the fiinal tale

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:35:13 GMT

try to using read statement instead

READ TABLE <table> INTO <wa?WITH KEY <key>

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:35:47 GMT

Hi Loganadhan,

Please note if you are appending rows to an internal table which you are looping will result in ENDLESS LOOP.

First you collect the records from each internal table into a temporary itab then pass them to main loop.

loop each itab separately and append them to main table.

loop at itab1

append itab from itab1.

endloop

loop at itab2

append itab from itab2

endloop

loop at itab3

append itab from itab3

endloop

Regards

Ramchander Rao.K

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:39:19 GMT

Hi Sridhar,

1. Is it necessary for you to LOOP in table 1, 2 and 3, inside your MAINTABLE. Are you using any condition in your inner loops?

2. If yes, and if you want all those records to be updated then you need to use APPEND inside your inner loop.

KIndly let us know your requirement.

Best Regards,

Ram.

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:43:39 GMT

sorry ram chandran,

i am not clear with ur concept casue append itab from itab1 it is showing me syntax error

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:45:14 GMT

yes i need to use loop inside the maintable , and one more thing , can i use multiple append in my loops , casue i am afraid it might lead to duplicate records or some error

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:48:07 GMT

Hi,

May be their line types are incompatible( not equal).

check the components of your internal tables( are they having same names and types)

loop at itab1.

move-correspondign itab1 to itab.

append itab.

endloop.

loop at itab2.

move-corresponding itab2 to itab.

append itab.

endloop.

loop at itab3.

move-corresponding itab3 to itab.

append itab.

endloop.

Best Regards

Ramchander Rao.K

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 05:57:17 GMT

Hi Sridhar,

In case you are worrying about duplicate records, you can always use, Delete adjacent duplicates statement on your main table to remove it.

I think i am not very clear on what you are trying to acheive.

First, You want records from your MAINTABLE to be filled from itab1, itab2 and itab3. Hope this is correct.

To acheive this,

First


loop at itab1.
" Append entries to your maintable.
endloop.

Now, based on these entries, if you want to fill records from itab2 and itab3. If yes, then


loop at itab2.
" read maintable with key. If found, modify, else, append to maintable
endloop.
loop at itab3.
" read maintable with key. if found, modify, else append to maintable.
endloop.

Hope this is what you want. If otherwise, please let us know.

Best Regards,

Ram.

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 06:07:04 GMT

loop at itab1.

move-corresponding itab1 to maintable.

append maintable.

endloop.

loop at itab2.

move-corresponding itab2 to maintable.

append maintable.

endloop

loop at itab3.

move-corresponding itab3 to maintable.

append maintable.

endloop

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 06:18:32 GMT

Hi,

What's your requirement?

So many loops in a main loop will effect the performance.

Regards,

Chris Gu

Re: Append statments for multiple loop

Former Member — Fri, 12 Dec 2008 10:19:45 GMT

changed the loop with item level and read the header table using read statement and appended , the final table

i was not having any eror by doing this