topic ABAP Report Problem in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273483#M1530447 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My report output is like this..</P><P></P><P><STRONG>Material Number......................Stock</STRONG></P><P>AAAA.....................................00.00</P><P>BBBB.....................................100.00</P><P>CCCC.......................................50.00</P><P>DDDD.....................................200.00</P><P><STRONG>..........................SUM.............350.00</STRONG></P><P></P><P>Please have a look that SUM is 350.00 for 4 Material's Stock.</P><P></P><P>Now i want the output like this..</P><P></P><P><STRONG>Material Number......................Stock</STRONG></P><P>AAAA....................................350.00</P><P>BBBB..................................... 350.00</P><P>CCCC......................................350.00</P><P>DDDD..................................... 350.00</P><P></P><P>Sum should be shown in all 4 material.</P><P></P><P>My code for above example is...</P><P>**********************************************************************</P><P>LOOP AT itab.</P><P> AT NEW matnr.</P><P> stock = 0.</P><P> SELECT SINGLE labst INTO stock FROM mard WHERE matnr = itab-matnr AND werks = itab-werks AND lgort IN ('FNGS','DLF1').</P><P> ENDAT.</P><P> IF stock GE itab-omeng.</P><P> itab-labst = itab-omeng.</P><P> stock = stock - itab-omeng.</P><P> ELSE.</P><P> itab-labst = stock.</P><P> stock = 0.</P><P> ENDIF.</P><P> MODIFY itab TRANSPORTING labst.</P><P>ENDLOOP.</P><P>**********************************************************************</P><P></P><P>In addition, what should be do for 350.00 in all materials.</P><P></P><P>Plz guide...</P></BODY></HTML> Sat, 02 Oct 2010 15:24:06 GMT Former Member 2010-10-02T15:24:06Z ABAP Report Problem https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273483#M1530447 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My report output is like this..</P><P></P><P><STRONG>Material Number......................Stock</STRONG></P><P>AAAA.....................................00.00</P><P>BBBB.....................................100.00</P><P>CCCC.......................................50.00</P><P>DDDD.....................................200.00</P><P><STRONG>..........................SUM.............350.00</STRONG></P><P></P><P>Please have a look that SUM is 350.00 for 4 Material's Stock.</P><P></P><P>Now i want the output like this..</P><P></P><P><STRONG>Material Number......................Stock</STRONG></P><P>AAAA....................................350.00</P><P>BBBB..................................... 350.00</P><P>CCCC......................................350.00</P><P>DDDD..................................... 350.00</P><P></P><P>Sum should be shown in all 4 material.</P><P></P><P>My code for above example is...</P><P>**********************************************************************</P><P>LOOP AT itab.</P><P> AT NEW matnr.</P><P> stock = 0.</P><P> SELECT SINGLE labst INTO stock FROM mard WHERE matnr = itab-matnr AND werks = itab-werks AND lgort IN ('FNGS','DLF1').</P><P> ENDAT.</P><P> IF stock GE itab-omeng.</P><P> itab-labst = itab-omeng.</P><P> stock = stock - itab-omeng.</P><P> ELSE.</P><P> itab-labst = stock.</P><P> stock = 0.</P><P> ENDIF.</P><P> MODIFY itab TRANSPORTING labst.</P><P>ENDLOOP.</P><P>**********************************************************************</P><P></P><P>In addition, what should be do for 350.00 in all materials.</P><P></P><P>Plz guide...</P></BODY></HTML> Sat, 02 Oct 2010 15:24:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273483#M1530447 Former Member 2010-10-02T15:24:06Z Re: ABAP Report Problem https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273484#M1530448 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>first of all avoid select into a loop</P><P></P><PRE><CODE>SELECT SUM(labst) as stock FOR ALL ENTRIES IN itab FROM mard WHERE matnr = mard-matnr AND werks = mard-werks AND mard-lgort IN ('FNGS','DLF1'). LOOP AT itab. *** Write Output ENDLOOP. </CODE></PRE><P></P><P>I have not tested the code but it is an idea.</P><P></P><P>Ivan</P></BODY></HTML> Sat, 02 Oct 2010 18:56:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273484#M1530448 _IvanFemia_ 2010-10-02T18:56:54Z Re: ABAP Report Problem https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273485#M1530449 <HTML><HEAD></HEAD><BODY><P>Classic or ALV report ??</P></BODY></HTML> Sun, 03 Oct 2010 17:41:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/abap-report-problem/m-p/7273485#M1530449 kesavadas_thekkillath 2010-10-03T17:41:55Z