topic Re: Logic for internal table in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396217#M1405545 <HTML><HEAD></HEAD><BODY><P>use format 092009 and collect</P></BODY></HTML> Wed, 18 Nov 2009 07:36:51 GMT kesavadas_thekkillath 2009-11-18T07:36:51Z Logic for internal table https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396214#M1405542 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an internal table with the following structure.</P><P></P><P>PO Number PO Line Number Quantity ETA</P><P>PO_1 001 10 10 Aug 2009</P><P>PO_1 002 12 11 Aug 2009</P><P>PO_2 001 5 10 Aug 2009</P><P>PO_1 001 13 10 Aug 2009</P><P>PO_1 001 7 11 Aug 2009</P><P></P><P>Now I want to sum up quantity based on ETA dates so that the structure will look like as below:</P><P></P><P>PO Number PO Line Number Quantity ETA</P><P>PO_1 001 23 10 Aug 2009</P><P>PO_1 001 7 11 Aug 2009</P><P>PO_1 002 12 11 Aug 2009</P><P>PO_2 001 5 10 Aug 2009</P><P></P><P>Collect statement will not work as the checking is on date but not on po no and line item.</P><P></P><P>Regards,</P><P>Abhi...</P></BODY></HTML> Wed, 18 Nov 2009 06:52:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396214#M1405542 Former Member 2009-11-18T06:52:05Z Re: Logic for internal table https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396215#M1405543 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If possible create a structure with ponumber poitem date quant and then move corresponding fields to another internal table and use collect</P></BODY></HTML> Wed, 18 Nov 2009 07:10:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396215#M1405543 Former Member 2009-11-18T07:10:57Z Re: Logic for internal table https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396216#M1405544 <HTML><HEAD></HEAD><BODY><P>Use SUM statement for adding the quantity fields.</P><P></P><P></P><P>Sample code :</P><P></P><P>LOOP AT T INTO WA_T. </P><P></P><P>WA_N = WA_T</P><P> SUM. </P><P></P><P>WA_N-QUANTITY = WA_T-QUANTITY.</P><P></P><P>APPEND WA_N TO ITAB_N.</P><P></P><P></P><P>ENDLOOP.</P></BODY></HTML> Wed, 18 Nov 2009 07:24:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396216#M1405544 Former Member 2009-11-18T07:24:17Z Re: Logic for internal table https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396217#M1405545 <HTML><HEAD></HEAD><BODY><P>use format 092009 and collect</P></BODY></HTML> Wed, 18 Nov 2009 07:36:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/logic-for-internal-table/m-p/6396217#M1405545 kesavadas_thekkillath 2009-11-18T07:36:51Z