topic report using internal table events in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/report-using-internal-table-events/m-p/1693156#M304250 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have an internal table with the fields 1. profitcenter 2. company code 3. gl account 4. amount</P><P></P><P>for each profit center i need to seggregate accounts based on company code.</P><P>the report should look like the one below.</P><P>please suggest some code using internal table events at new , at end etc. as im not using alv. your help will be rewarded</P><P></P><P>regards,</P><P>ravi.</P><P></P><P>-Profitcenter<DEL>-companycode</DEL><DEL>glaccount</DEL>-amount---</P><P>-</P><HR originaltext="----------------------------------------------------" /><P>-pfcenter1----</P><HR originaltext="--------------------------------------" /><P>-</P><HR originaltext="------------------------------" /><P>glaccount1<DEL>-1000</DEL>---</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount2<DEL>-2000</DEL>---</P><P>-</P><HR originaltext="---------------" /><P>4444-total--<DEL></DEL></P><HR originaltext="-------------" />3000---<P></P><P>********</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount1<DEL>-4000</DEL>---</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount2<DEL>-1000</DEL>---</P><P>-</P><HR originaltext="---------------" /><P>3333-total--<DEL></DEL></P><HR originaltext="-------------" />5000---<P></P><P><DEL>-profitcentre1*total</DEL><DEL></DEL></P><HR originaltext="-----------------" />8000---<P></P><P>******************************************************</P><P>profitcentre2.........</P></BODY></HTML> Tue, 24 Oct 2006 01:18:18 GMT Former Member 2006-10-24T01:18:18Z report using internal table events https://community.sap.com/t5/application-development-and-automation-discussions/report-using-internal-table-events/m-p/1693156#M304250 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have an internal table with the fields 1. profitcenter 2. company code 3. gl account 4. amount</P><P></P><P>for each profit center i need to seggregate accounts based on company code.</P><P>the report should look like the one below.</P><P>please suggest some code using internal table events at new , at end etc. as im not using alv. your help will be rewarded</P><P></P><P>regards,</P><P>ravi.</P><P></P><P>-Profitcenter<DEL>-companycode</DEL><DEL>glaccount</DEL>-amount---</P><P>-</P><HR originaltext="----------------------------------------------------" /><P>-pfcenter1----</P><HR originaltext="--------------------------------------" /><P>-</P><HR originaltext="------------------------------" /><P>glaccount1<DEL>-1000</DEL>---</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount2<DEL>-2000</DEL>---</P><P>-</P><HR originaltext="---------------" /><P>4444-total--<DEL></DEL></P><HR originaltext="-------------" />3000---<P></P><P>********</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount1<DEL>-4000</DEL>---</P><P>-</P><HR originaltext="------------------------------" /><P>glaccount2<DEL>-1000</DEL>---</P><P>-</P><HR originaltext="---------------" /><P>3333-total--<DEL></DEL></P><HR originaltext="-------------" />5000---<P></P><P><DEL>-profitcentre1*total</DEL><DEL></DEL></P><HR originaltext="-----------------" />8000---<P></P><P>******************************************************</P><P>profitcentre2.........</P></BODY></HTML> Tue, 24 Oct 2006 01:18:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/report-using-internal-table-events/m-p/1693156#M304250 Former Member 2006-10-24T01:18:18Z Re: report using internal table events https://community.sap.com/t5/application-development-and-automation-discussions/report-using-internal-table-events/m-p/1693157#M304251 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>TYPES: BEGIN OF G_I_DATA,</P><P> PROFIT(4) TYPE C,</P><P> COMPANY(4) TYPE C,</P><P> ACCOUNT(10) TYPE C,</P><P> AMOUNT TYPE P,</P><P> END OF G_I_DATA.</P><P></P><P>DATA: G_IT_DATA TYPE TABLE OF G_I_DATA,</P><P> G_WA_DATA TYPE G_I_DATA.</P><P>DATA: G_SUM_COMPANY TYPE P,</P><P> G_SUM_PROFIT TYPE P,</P><P> G_AMOUNT TYPE P.</P><P></P><P></P><P> G_WA_DATA-PROFIT = '0001'.</P><P> G_WA_DATA-COMPANY = '1111'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT1'.</P><P> G_WA_DATA-AMOUNT = 2000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0001'.</P><P> G_WA_DATA-COMPANY = '1111'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT2'.</P><P> G_WA_DATA-AMOUNT = 3000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0001'.</P><P> G_WA_DATA-COMPANY = '2222'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT1'.</P><P> G_WA_DATA-AMOUNT = 4000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0001'.</P><P> G_WA_DATA-COMPANY = '2222'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT2'.</P><P> G_WA_DATA-AMOUNT = 5000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0002'.</P><P> G_WA_DATA-COMPANY = '1111'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT1'.</P><P> G_WA_DATA-AMOUNT = 2000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0002'.</P><P> G_WA_DATA-COMPANY = '1111'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT2'.</P><P> G_WA_DATA-AMOUNT = 3000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0002'.</P><P> G_WA_DATA-COMPANY = '2222'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT1'.</P><P> G_WA_DATA-AMOUNT = 4000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> G_WA_DATA-PROFIT = '0002'.</P><P> G_WA_DATA-COMPANY = '2222'.</P><P> G_WA_DATA-ACCOUNT = 'ACCOUNT2'.</P><P> G_WA_DATA-AMOUNT = 5000.</P><P> APPEND G_WA_DATA TO G_IT_DATA.</P><P></P><P> SORT G_IT_DATA BY PROFIT COMPANY ACCOUNT.</P><P></P><P> WRITE: /6 'ProfitCenter', 20 'CompanyCode',</P><P> 34 'Glaccount', 48 'Amount'.</P><P> WRITE: /6 SY-ULINE(50).</P><P></P><P> LOOP AT G_IT_DATA INTO G_WA_DATA.</P><P> AT NEW PROFIT.</P><P> WRITE: /6 G_WA_DATA-PROFIT.</P><P> ENDAT.</P><P></P><P> G_AMOUNT = G_WA_DATA-AMOUNT.</P><P> AT NEW ACCOUNT.</P><P> WRITE: /34 G_WA_DATA-ACCOUNT,</P><P> 48 G_AMOUNT.</P><P> ENDAT.</P><P></P><P> G_SUM_PROFIT = G_SUM_PROFIT + G_WA_DATA-AMOUNT.</P><P> G_SUM_COMPANY = G_SUM_COMPANY + G_WA_DATA-AMOUNT.</P><P></P><P> AT END OF COMPANY.</P><P> WRITE: /20 G_WA_DATA-COMPANY,</P><P> 34 'Totle',</P><P> 48 G_SUM_COMPANY.</P><P> CLEAR G_SUM_COMPANY.</P><P> WRITE: /6 '*******'.</P><P> ENDAT.</P><P></P><P> AT END OF PROFIT.</P><P> WRITE: /6 G_WA_DATA-PROFIT,</P><P> 20 'Totle',</P><P> 48 G_SUM_PROFIT.</P><P> CLEAR G_SUM_PROFIT.</P><P> WRITE: /6 '*************************************'.</P><P> ENDAT.</P><P> ENDLOOP.</P></BODY></HTML> Tue, 24 Oct 2006 01:47:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/report-using-internal-table-events/m-p/1693157#M304251 Former Member 2006-10-24T01:47:35Z