Change Subtotals Positions in ALV Grid ?

[Former Member]

hi there,

I want to put my subtotals in my ALV repot at the top of sorting documents. Right now my report look like this,

KUNNR	NAME1	MATNR	MAKTX	MENGE	MEINS	NETWR	TOTAL
00000123	XXX	00101	XXX	3	PC	1000	3000
00000123	XXX	00102	YYY	2	PC	1000	2000
Subtotals							5000
00000124	CCC	00201	CCC	2	BOX	500	1000
00000124	CCC	00202	DDD	3	BOX	2000	6000
Subtotals							7000
Grand Total							12000

I need to looked like this, so our user can instantly know the subtotals if too many items in one customer.

KUNNR	NAME1	MATNR	MAKTX	MENGE	MEINS	NETWR	TOTAL
Subtotals							5000
00000123	XXX	00101	XXX	3	PC	1000	3000
00000123	XXX	00102	YYY	2	PC	1000	2000
Subtotals							7000
00000124	CCC	00201	CCC	2	BOX	500	1000
00000124	CCC	00202	DDD	3	BOX	2000	6000
Grand Total							12000

Is it possible, when I use reuse_alv_grid_display? or You have any other solution?

Thank you for your attention.

[Former Member]

Once you have your output in ALV, you can simply go to the Change Layout option and on the Display tab, select the flag for 'Display total lines above the entries':

[former_member156446]

in IS_LAYOUT of the function use this field totals_before_items

[Former Member]

Is it correct that the sub-totals must be at the top and the grand totals at the end?

Rob

[Former Member]

Well it's not a problem when the grand total at the top also. If even possible, I just want to view the subtotal only. Do you have any idea?