topic Re: ABAP Coding Help for Subtotal type output - SAP Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/abap-coding-help-for-subtotal-type-output-sap-query/m-p/10400979#M1842593 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>Please see the below documents for STATISTICS</P><P><BR /><A href="https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm" title="https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm">https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm</A></P><P></P><P>Regards,</P><P>Prasenjit Mishra</P></BODY></HTML> Wed, 18 Jun 2014 12:43:09 GMT Former Member 2014-06-18T12:43:09Z ABAP Coding Help for Subtotal type output - SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/abap-coding-help-for-subtotal-type-output-sap-query/m-p/10400978#M1842592 <HTML><HEAD></HEAD><BODY><P>I've created a SAP Query to display a stock overview by storage type using the table LQUA.</P><P></P><P>The output that I get is:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE><TBODY><TR><TD colspan="1">Material</TD><TD colspan="1">Description</TD><TD colspan="1">Plant</TD><TD colspan="1">WHN</TD><TD colspan="1">SLOC</TD><TD colspan="1">Storage Type</TD><TD colspan="1">Batch</TD><TD colspan="1">GR Date</TD><TD colspan="1">Available stock</TD></TR><TR><TD>2057&nbsp; </TD><TD>STRAWBERRIES</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081766</TD><TD>17.06.2014</TD><TD>225</TD></TR><TR><TD>2057</TD><TD>STRAWBERRIES</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081766</TD><TD>17.06.2014</TD><TD>720</TD></TR><TR><TD>2061</TD><TD>VOSTIZZA CURRANTS</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081272</TD><TD>17.06.2014</TD><TD>1,000</TD></TR><TR><TD>2061</TD><TD>VOSTIZZA CURRANTS</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081272</TD><TD>17.06.2014</TD><TD>1,000</TD></TR><TR><TD>2061</TD><TD>VOSTIZZA CURRANTS</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081272</TD><TD>17.06.2014</TD><TD>1,000</TD></TR><TR><TD>2061</TD><TD>VOSTIZZA CURRANTS</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081272</TD><TD>17.06.2014</TD><TD>1,000</TD></TR></TBODY></TABLE><P></P><P>I can get a subtotal for each Material, batch and GR date combination by using the ALV grid functionality.</P><P></P><P>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:</P><P></P><TABLE jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}"><TBODY><TR><TD colspan="1">Material</TD><TD colspan="1">Description</TD><TD colspan="1">Plant</TD><TD colspan="1">WHN</TD><TD colspan="1">SLOC</TD><TD colspan="1">Storage Type</TD><TD colspan="1">Batch</TD><TD colspan="1">GR Date</TD><TD colspan="1">Available stock</TD></TR><TR><TD>2057&nbsp; </TD><TD>STRAWBERRIES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081766</TD><TD>17.06.2014</TD><TD>945</TD></TR><TR><TD>2061</TD><TD>VOSTIZZA CURRANTS</TD><TD>BP01</TD><TD>100</TD><TD>0088</TD><TD>200</TD><TD>0001081272</TD><TD>17.06.2014</TD><TD>4,000</TD></TR></TBODY></TABLE><P></P><P>How can this be done?</P></BODY></HTML> Wed, 18 Jun 2014 12:33:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-coding-help-for-subtotal-type-output-sap-query/m-p/10400978#M1842592 benjamin_allsopp 2014-06-18T12:33:54Z Re: ABAP Coding Help for Subtotal type output - SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/abap-coding-help-for-subtotal-type-output-sap-query/m-p/10400979#M1842593 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P>Please see the below documents for STATISTICS</P><P><BR /><A href="https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm" title="https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm">https://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb4263455611d189710000e8322d00/content.htm</A></P><P></P><P>Regards,</P><P>Prasenjit Mishra</P></BODY></HTML> Wed, 18 Jun 2014 12:43:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-coding-help-for-subtotal-type-output-sap-query/m-p/10400979#M1842593 Former Member 2014-06-18T12:43:09Z