topic Using COLLECT statement except for the specific column in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/using-collect-statement-except-for-the-specific-column/m-p/11866645#M1959453 <HTML><HEAD></HEAD><BODY><P>Can I use the COLLECT statement except for the specific column as below?</P><P></P><P></P><P></P><P>Example)</P><P></P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; BR40&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; BR41&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp; CR&nbsp;&nbsp; BR40&nbsp;&nbsp; 300</P><P></P><P></P><P>Result)</P><P></P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; Total&nbsp;&nbsp; 300<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BR40&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BR41&nbsp;&nbsp; 200</P><P></P><P>A&nbsp;&nbsp; CR&nbsp;&nbsp; BR40&nbsp; 300</P><P></P><P></P><P>I want to make it by using COLLECT statment or others.</P><P>Please help me.</P></BODY></HTML> Wed, 31 Aug 2016 02:34:08 GMT Former Member 2016-08-31T02:34:08Z Using COLLECT statement except for the specific column https://community.sap.com/t5/application-development-and-automation-discussions/using-collect-statement-except-for-the-specific-column/m-p/11866645#M1959453 <HTML><HEAD></HEAD><BODY><P>Can I use the COLLECT statement except for the specific column as below?</P><P></P><P></P><P></P><P>Example)</P><P></P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; BR40&nbsp;&nbsp; 100</P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; BR41&nbsp;&nbsp; 200</P><P>A&nbsp;&nbsp; CR&nbsp;&nbsp; BR40&nbsp;&nbsp; 300</P><P></P><P></P><P>Result)</P><P></P><P>A&nbsp;&nbsp; BR&nbsp;&nbsp; Total&nbsp;&nbsp; 300<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BR40&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BR41&nbsp;&nbsp; 200</P><P></P><P>A&nbsp;&nbsp; CR&nbsp;&nbsp; BR40&nbsp; 300</P><P></P><P></P><P>I want to make it by using COLLECT statment or others.</P><P>Please help me.</P></BODY></HTML> Wed, 31 Aug 2016 02:34:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-collect-statement-except-for-the-specific-column/m-p/11866645#M1959453 Former Member 2016-08-31T02:34:08Z Re: Using COLLECT statement except for the specific column https://community.sap.com/t5/application-development-and-automation-discussions/using-collect-statement-except-for-the-specific-column/m-p/11866646#M1959454 <HTML><HEAD></HEAD><BODY><P>Hi Minsuk,</P><P></P><P>Define source_itab, result_itab, final_itab with same structure. </P><P></P><P>LOOP source_itab INTO source_wa.</P><P>&nbsp;&nbsp; source_wa-field3 = ''.</P><P>&nbsp;&nbsp; COLLECT source_wa TO result_itab.</P><P>ENDLOOP.</P><P></P><P>LOOP result_itab INTO result_wa.</P><P>&nbsp;&nbsp; APPEND result_wa TO final_itab.</P><P>&nbsp;&nbsp; LOOP source_itab INTO source_wa WHERE field1 = result_wa-field1.AND field2 = ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; APPEND source_wa INTO final_itab.</P><P>&nbsp;&nbsp; ENDLOOP.</P><P>ENDLOOP.</P><P></P><P>BRs,</P><P>Archer</P></BODY></HTML> Wed, 31 Aug 2016 03:08:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/using-collect-statement-except-for-the-specific-column/m-p/11866646#M1959454 ArcherZhang 2016-08-31T03:08:48Z