topic Re: Calculation on Internal Table in Application Development and Automation Discussions

topic Re: Calculation on Internal Table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071725#M429165 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>Use <b>COLLECT itab</b> to meet your requirement.</P><P></P><P>(or) Code as follows</P><P></P><P>DATA:</P><P>V_AMT1 TYPE I,</P><P>V_AMT2 TYPE I.</P><P></P><P>SORT ITAB BY CUSTOMER.</P><P></P><P>LOOP AT ITAB.</P><P>AT NEW CUSTOMER.</P><P>V_CUSTOMER = ITAB-CUSTOMER.</P><P>ENDAT.</P><P>V_AMT1 = V_AMT1 + ITAB-AMOUNT1.</P><P>V_AMT2 = V_AMT2 + ITAB-AMOUNT2.</P><P>AT END OF CUSTOMER.</P><P>ITAB_SUM-CUSTOMER = V_CUSTOMER.</P><P>ITAB_SUM-AMOUNT1 = V_AMT1.</P><P>ITAB_SUM-AMOUNT2 = V_AMT2.</P><P>APPEND ITAB_SUM.</P><P>CLEAR V_AMT1.</P><P>CLEAR V_AMT2.</P><P>ENDAT.</P><P>ENDLOOP.</P><P></P><P>Thanks,</P><P>Vinay</P><P></P><P>Thanks,</P><P>Vinay</P></BODY></HTML> Thu, 08 Mar 2007 17:45:23 GMT Former Member 2007-03-08T17:45:23Z Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071722#M429162 <HTML><HEAD></HEAD><BODY><P>I have one Internal Table.</P><P></P><P>Customer Amount1 Ammount2</P><P>333 470.4 2352</P><P>333 2822.4 0</P><P>953 4166.67 20833.33</P><P>953 20833.33 0</P><P>953 25000 0</P><P>953 19230.77 480769.23</P><P>953 336134.45 0</P><P>953 63865.55 336134.45</P><P></P><P>I want to single for each customer with Amount1 and Amount 2 sumup.</P><P></P><P>Could any body help me.</P></BODY></HTML> Thu, 08 Mar 2007 17:27:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071722#M429162 former_member303185 2007-03-08T17:27:52Z Re: Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071723#M429163 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>When u are append ing the itab use <b>COLLECT ITAB</b></P><P></P><P>Vasanth</P></BODY></HTML> Thu, 08 Mar 2007 17:30:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071723#M429163 Former Member 2007-03-08T17:30:41Z Re: Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071724#M429164 <HTML><HEAD></HEAD><BODY><P>hi vijaya</P><P> this is the sample code ,pls do modification as per ur requirements</P><P></P><P>REPORT zcollect.</P><P></P><P>TYPES:BEGIN OF t_mytype,</P><P>key_c(10) TYPE c,</P><P>key_n(10) TYPE n,</P><P>key_i TYPE i,</P><P>number TYPE i,</P><P>END OF t_mytype.</P><P></P><P>DATA:gi_mytable TYPE SORTED TABLE OF t_mytype</P><P>WITH NON-UNIQUE KEY key_c key_n key_i,</P><P>wa_mytable TYPE t_mytype.</P><P></P><P>START-OF-SELECTION.</P><P></P><P>CLEAR wa_mytable.</P><P>wa_mytable-key_c = '10'.</P><P>wa_mytable-key_n = '25'.</P><P>wa_mytable-key_i = 5.</P><P>wa_mytable-number = 400.</P><P>COLLECT wa_mytable INTO gi_mytable.</P><P></P><P>CLEAR wa_mytable.</P><P>wa_mytable-key_c = '10'.</P><P>wa_mytable-key_n = '25'.</P><P>wa_mytable-key_i = 5.</P><P>wa_mytable-number = 500.</P><P>COLLECT wa_mytable INTO gi_mytable.</P><P></P><P>CLEAR wa_mytable.</P><P>wa_mytable-key_c = '11'.</P><P>wa_mytable-key_n = '30'.</P><P>wa_mytable-key_i = 6.</P><P>wa_mytable-number = 200.</P><P>COLLECT wa_mytable INTO gi_mytable.</P><P></P><P>CLEAR wa_mytable.</P><P>wa_mytable-key_c = '11'.</P><P>wa_mytable-key_n = '30'.</P><P>wa_mytable-key_i = 6.</P><P>wa_mytable-number = 900.</P><P>COLLECT wa_mytable INTO gi_mytable.</P><P></P><P>CLEAR wa_mytable.</P><P>wa_mytable-key_c = '11'.</P><P>wa_mytable-key_n = '30'.</P><P>wa_mytable-key_i = 7.</P><P>wa_mytable-number = 100.</P><P>COLLECT wa_mytable INTO gi_mytable.</P><P>END-OF-SELECTION.</P><P></P><P>LOOP AT gi_mytable INTO wa_mytable.</P><P>WRITE: / wa_mytable-key_c,</P><P>wa_mytable-key_n,</P><P>wa_mytable-key_i,</P><P>wa_mytable-number.</P><P>ENDLOOP.</P><P></P><P>thanks and regard</P><P>satya</P></BODY></HTML> Thu, 08 Mar 2007 17:43:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071724#M429164 Former Member 2007-03-08T17:43:30Z Re: Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071725#M429165 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>Use <b>COLLECT itab</b> to meet your requirement.</P><P></P><P>(or) Code as follows</P><P></P><P>DATA:</P><P>V_AMT1 TYPE I,</P><P>V_AMT2 TYPE I.</P><P></P><P>SORT ITAB BY CUSTOMER.</P><P></P><P>LOOP AT ITAB.</P><P>AT NEW CUSTOMER.</P><P>V_CUSTOMER = ITAB-CUSTOMER.</P><P>ENDAT.</P><P>V_AMT1 = V_AMT1 + ITAB-AMOUNT1.</P><P>V_AMT2 = V_AMT2 + ITAB-AMOUNT2.</P><P>AT END OF CUSTOMER.</P><P>ITAB_SUM-CUSTOMER = V_CUSTOMER.</P><P>ITAB_SUM-AMOUNT1 = V_AMT1.</P><P>ITAB_SUM-AMOUNT2 = V_AMT2.</P><P>APPEND ITAB_SUM.</P><P>CLEAR V_AMT1.</P><P>CLEAR V_AMT2.</P><P>ENDAT.</P><P>ENDLOOP.</P><P></P><P>Thanks,</P><P>Vinay</P><P></P><P>Thanks,</P><P>Vinay</P></BODY></HTML> Thu, 08 Mar 2007 17:45:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071725#M429165 Former Member 2007-03-08T17:45:23Z Re: Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071726#M429166 <HTML><HEAD></HEAD><BODY><P>HI Vijay,</P><P></P><P>Use COLLECT instead of append itab.</P><P></P><P>or if u get values from select statement then..</P><P></P><P>Loop at itab.</P><P>move-corresponding itab to btab.</P><P>collect btab.</P><P>endloop.</P><P></P><P>btab has records on customer basis.</P><P></P><P>Regards</P><P>SAB</P></BODY></HTML> Thu, 08 Mar 2007 18:46:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071726#M429166 Former Member 2007-03-08T18:46:35Z Re: Calculation on Internal Table https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071727#M429167 <HTML><HEAD></HEAD><BODY><P>Use <b>Collect</b> Statement</P></BODY></HTML> Thu, 08 Mar 2007 22:45:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/calculation-on-internal-table/m-p/2071727#M429167 Former Member 2007-03-08T22:45:56Z