topic Re: Subtotal in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133240#M744437 <HTML><HEAD></HEAD><BODY><P>Hi Tobias,</P><P></P><P>try replacing</P><P></P><PRE><CODE>wa_sort-fieldname = 'SALDO'.</CODE></PRE><P></P><P>with</P><P></P><PRE><CODE>wa_sort-fieldname = 'PARTNER'.</CODE></PRE><P></P><P>The totals on Verb, Ford and Saldo you activate by setting DO_SUM = 'X' for these fields in IT_FIELDCAT.</P></BODY></HTML> Wed, 12 Dec 2007 13:24:38 GMT ThomasZloch 2007-12-12T13:24:38Z Subtotal https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133239#M744436 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>i've got to make a report with subtotal for each partner.</P><P></P><P>my table looks like this</P><P></P><P>Partner | Vertrag | Verb | Ford | Saldo</P><P> A1 12345 -250 0 0</P><P> A1 23456 0 500 250</P><P> A2 46798 -125 0 0 </P><P> A2 45123 -75 0 0 </P><P> A2 45678 0 150 -50 </P><P></P><P>and so on.</P><P>so the subtotal shoul stand in the Saldo-field.</P><P></P><P>i tried it so</P><PRE><CODE>CLEAR wa_sort. wa_sort-fieldname = 'SALDO'. wa_sort-up = 'X'. wa_sort-subtot = 'X'. APPEND wa_sort TO itab_sort.</CODE></PRE><P></P><P>but i only get a subtotal for the field ford, but i need it for both fields, verb and ford and the result should stand in saldo.</P><P></P><P>hope someone has a good idea.</P><P></P><P>regards,</P><P>tobias</P></BODY></HTML> Wed, 12 Dec 2007 13:12:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133239#M744436 Former Member 2007-12-12T13:12:28Z Re: Subtotal https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133240#M744437 <HTML><HEAD></HEAD><BODY><P>Hi Tobias,</P><P></P><P>try replacing</P><P></P><PRE><CODE>wa_sort-fieldname = 'SALDO'.</CODE></PRE><P></P><P>with</P><P></P><PRE><CODE>wa_sort-fieldname = 'PARTNER'.</CODE></PRE><P></P><P>The totals on Verb, Ford and Saldo you activate by setting DO_SUM = 'X' for these fields in IT_FIELDCAT.</P></BODY></HTML> Wed, 12 Dec 2007 13:24:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133240#M744437 ThomasZloch 2007-12-12T13:24:38Z Re: Subtotal https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133241#M744438 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Chnage the code as below :</P><P></P><PRE><CODE> CLEAR wa_sort. wa_sort-fieldname = 'PARTNER'. "Change the code wa_sort-up = 'X'. wa_sort-subtot = 'X'. APPEND wa_sort TO itab_sort.</CODE></PRE><P></P><P>Thanks,</P><P>Sriram Ponna.</P></BODY></HTML> Wed, 12 Dec 2007 13:32:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133241#M744438 Former Member 2007-12-12T13:32:09Z Re: Subtotal https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133242#M744439 <HTML><HEAD></HEAD><BODY><P>so the report should look like this.</P><P></P><P>i only get the totalsum.</P><P></P><PRE><CODE>GS Name BuKr Ges Forderung Verbindlichkeit Saldo Agt. 001 Pfefferminzia 1010 MVG 3.000,00 1041 MSV -1.500,00 1.500,00 001 Musterimus 1010 MVG -1.000,00 1012 MKV -2.000,00 1030 VSC 500,00 -2.500,00 GS-Summe 3.500,00 -4.500,00 -1.000,00 002 Beispieleria 1010 MVG 10.000,00 10.000,00 GS-Summe 10.000,00 0,00 10.000,00 Gesamtsumme 13.500,00 -4.500,00 9.000,00 Summen je Gesellschaft MVG 13.000,00 -1.000,00 12.000,00 MSV 0,00 -1.500,00 -1.500,00 MKV 0,00 -2.000,00 -2.000,00 VCS 500,00 0,00 500,00 </CODE></PRE><P></P><P>i hope someone has a good idea.</P><P></P><P>regards, </P><P>tobias</P></BODY></HTML> Wed, 12 Dec 2007 14:26:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/subtotal/m-p/3133242#M744439 Former Member 2007-12-12T14:26:59Z