ABAP Coding Help for Subtotal type output - SAP Query

[benjamin_allsopp]

I've created a SAP Query to display a stock overview by storage type using the table LQUA.

The output that I get is:

Material	Description	Plant	WHN	SLOC	Storage Type	Batch	GR Date	Available stock
2057	STRAWBERRIES	BP01	100	0088	200	0001081766	17.06.2014	225
2057	STRAWBERRIES	BP01	100	0088	200	0001081766	17.06.2014	720
2061	VOSTIZZA CURRANTS	BP01	100	0088	200	0001081272	17.06.2014	1,000
2061	VOSTIZZA CURRANTS	BP01	100	0088	200	0001081272	17.06.2014	1,000
2061	VOSTIZZA CURRANTS	BP01	100	0088	200	0001081272	17.06.2014	1,000
2061	VOSTIZZA CURRANTS	BP01	100	0088	200	0001081272	17.06.2014	1,000

I can get a subtotal for each Material, batch and GR date combination by using the ALV grid functionality.

This method adds too much clutter to my query and can't be easily manipulated in Excel afterwards for what I want. I want to condense the results down and just keep a cumulated available stock, e.g:

Material	Description	Plant	WHN	SLOC	Storage Type	Batch	GR Date	Available stock
2057	STRAWBERRIES	BP01	100	0088	200	0001081766	17.06.2014	945
2061	VOSTIZZA CURRANTS	BP01	100	0088	200	0001081272	17.06.2014	4,000

How can this be done?

[Former Member]

Hi,

Please try to use STATISTICS in your SAP Query. you can sort and add your value based on condiiton then it will be show you collect value in SQ01.

Please see the below documents for STATISTICS

https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm

Regards,

Prasenjit Mishra