topic Re: loop at issues in Application Development and Automation Discussions

loop at issues

former_member545481 — Thu, 09 Apr 2009 08:18:06 GMT

Hi All:

In my internal table i am getting data like:

10 25 abc

10 5 abc

20 37 xyz

30 2 vbp

30 5 vbp

30 2 vbp

I want the data like below.

10 30 abc

20 37 xyz

30 9 vbp

Please help me with it.

Regards,

Shegar

Re: loop at issues

Former Member — Thu, 09 Apr 2009 08:19:17 GMT

use the COLLECT statement.

Re: loop at issues

awin_prabhu — Thu, 09 Apr 2009 08:21:25 GMT

Use COLLECT ITAB.

Re: loop at issues

Former Member — Thu, 09 Apr 2009 08:22:09 GMT

Data: begin of itab1 occurs 0,
         Field1,
         Filed2,
         Field3,
         End of itab1.

Data: begin of itab2 occurs 0,
         Field1,
         Filed2,
         Field3,
         End of itab2.

Loop at Itab1.
Collect itab1 into itab2.
Endloop.

Check these codes will work.

Collect will add all non numeric keys fields .

Or.

Use:

Sort itab1 by field3.
Loop at itab1.
sum itab1.
At End of field3.
append itab1to itab2.
Endat.
Endloop.

Regards,

Gurpreet

Re: loop at issues

Former Member — Thu, 09 Apr 2009 08:22:24 GMT

This should solve ur querry ..

LOOP AT IT_TABLE1 INTO IT_TABLE1.
COLLECT IT_TABLE1 INTO IT_TABLE2 .
ENDLOOP.