loop at issues

[former_member545481]

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

[Former Member]

use the COLLECT statement.

[Former Member]

This should solve ur querry ..

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

[awin_prabhu]

Use COLLECT ITAB.

[Former Member]

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