topic how get quantity based Material wise ? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-get-quantity-based-material-wise/m-p/2573647#M587913 <HTML><HEAD></HEAD><BODY><P>My req is to get the data based on material ..in SAP QUERY</P><P></P><P>Suppose in table ZMATQ.</P><P></P><P> </P><P></P><P>Input:</P><P></P><P>Material. Quantity currency(price).</P><P></P><P>1001 10 20.00</P><P></P><P>1001 20 25.00</P><P></P><P>1001 25 30.00</P><P></P><P>2001 40 45.00</P><P></P><P>2001 45 28.99</P><P></P><P>2001 50 37.00</P><P></P><P> </P><P></P><P>In this they need drill down of quantity.</P><P></P><P>Like 1001 they need all quantity in drill down.</P><P></P><P> </P><P></P><P>N in list it sld display only one material no at time </P><P></P><P> </P><P></P><P>E.x</P><P> </P><P></P><P>Output: </P><P></P><P>Material quantity currency(price)</P><P></P><P>1001 drill down of all quantity Which come in 1001 material respective price </P><P></P><P>2001 drill down of all quantity Which come in 2001 material respective price.</P><P></P><P> </P><P></P><P>How to do this as I m taking from single table ..</P></BODY></HTML> Fri, 03 Aug 2007 08:54:44 GMT Former Member 2007-08-03T08:54:44Z how get quantity based Material wise ? https://community.sap.com/t5/application-development-and-automation-discussions/how-get-quantity-based-material-wise/m-p/2573647#M587913 <HTML><HEAD></HEAD><BODY><P>My req is to get the data based on material ..in SAP QUERY</P><P></P><P>Suppose in table ZMATQ.</P><P></P><P> </P><P></P><P>Input:</P><P></P><P>Material. Quantity currency(price).</P><P></P><P>1001 10 20.00</P><P></P><P>1001 20 25.00</P><P></P><P>1001 25 30.00</P><P></P><P>2001 40 45.00</P><P></P><P>2001 45 28.99</P><P></P><P>2001 50 37.00</P><P></P><P> </P><P></P><P>In this they need drill down of quantity.</P><P></P><P>Like 1001 they need all quantity in drill down.</P><P></P><P> </P><P></P><P>N in list it sld display only one material no at time </P><P></P><P> </P><P></P><P>E.x</P><P> </P><P></P><P>Output: </P><P></P><P>Material quantity currency(price)</P><P></P><P>1001 drill down of all quantity Which come in 1001 material respective price </P><P></P><P>2001 drill down of all quantity Which come in 2001 material respective price.</P><P></P><P> </P><P></P><P>How to do this as I m taking from single table ..</P></BODY></HTML> Fri, 03 Aug 2007 08:54:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-get-quantity-based-material-wise/m-p/2573647#M587913 Former Member 2007-08-03T08:54:44Z Re: how get quantity based Material wise ? https://community.sap.com/t5/application-development-and-automation-discussions/how-get-quantity-based-material-wise/m-p/2573648#M587914 <HTML><HEAD></HEAD><BODY><P>Thxs</P></BODY></HTML> Thu, 09 Aug 2007 02:18:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-get-quantity-based-material-wise/m-p/2573648#M587914 Former Member 2007-08-09T02:18:00Z