Consolidate rows in ALV

[Former Member]

hi,

how to consolidate rows in ALV grid display.

srno   item code         qty     price 
1           23             10          5
2           23             10        15 
3           23             10        20


so i want

srno   item code         qty     price 
1           23             30          40

pls help in this case.

abhi

[Former Member]

Use COLLECT keyword.

Check this Help Link [Appending Summarized Lines|http://help.sap.com/erp2005_ehp_04/helpdata/EN/fc/eb36e2358411d1829f0000e829fbfe/frameset.htm].

[Former Member]

hi

thnx but is any function there like

wa_fieldcat1-do_sum = 'x'.

for column sum like i want

abhi..

[former_member778253]

Hi

YES. There is a function called 'do_sum = 'X'.

You can use this without any concerns.

Hope it helps....

[Former Member]

hi,

how to consolidate rows in ALV grid display.

srno   item code         qty     price 
1           23             10          5
2           23             10        15 
3           23             10        20
 
 
so i want
 
srno   item code         qty     price 
1           23             30          40

pls help in this case.

abhi

[Former Member]

In field catalog definition set do_sum = 'X' for "quantity" and "price" columns. After you execute the report, Select "itemcode" column and click on "Subtotals" Button, then the report will be displayed as per your format. Now Click on "Save Layout" button

and create a new layout. Check "default setting" check box to set this layout as standard layout for your report.

Regards

Vinod