topic SimulateAllocation/ Discrepency Report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/simulateallocation-discrepency-report/m-p/2384782#M529851 <HTML><HEAD></HEAD><BODY><P>Hi experts </P><P></P><P>I have a tech. spec with me and I have to complete a report, can you help me out to write code for this.</P><P></P><P>Based on the entries on the screen , populate the item details in the screen into an internal table itab_item and header into an internal table itab_header. </P><P></P><P>The values should be populated in the report as shown in the attached Format.</P><P></P><P>The Discrepancy report can be generated only for the line items where Plan is blank.</P><P></P><P>Loop at itab_item.</P><P></P><P> GL_Account = itab_item-gl_account.</P><P></P><P> Account Description = Description of the GL Account.</P><P></P><P> Internal Order / Cost Center = </P><P></P><P> Plan start = Select AUFNR from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.</P><P></P><P> Pool = itab_item-pool</P><P></P><P> Account = itab_item-account.</P><P></P><P> Start allocation period = itab_item-zzvalid_fr</P><P></P><P> Ownership as per start allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.</P><P></P><P> Allocation as per start allocation = Multiply itab_item-amount with ownership as per start allocation.</P><P> </P><P> End allocation period = itab_item-zzvalid_to</P><P></P><P> Ownership as per end allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_FR = itab_item-end_alloc_from and ZZPOOL = itab_item-pool.</P><P> Allocation as per end allocation = Multiply itab_item-amount with ownership as per end allocation.</P><P> </P><P> Variation = Allocation as per end allocation - Allocation as per start allocation</P><P> </P><P> Discrepancy = Depends on change in plan . If Plan is added in the end alloc say Plan is ended.</P><P> If Plan is not there in the end allocation say Plan is defunded.</P><P></P><P> NR Plan: Select ZZBILLTYPE from ZPBILLMASTER where PLAN = itab_item-plan and itab_item- gl_account .</P></BODY></HTML> Mon, 04 Jun 2007 19:35:13 GMT Former Member 2007-06-04T19:35:13Z SimulateAllocation/ Discrepency Report https://community.sap.com/t5/application-development-and-automation-discussions/simulateallocation-discrepency-report/m-p/2384782#M529851 <HTML><HEAD></HEAD><BODY><P>Hi experts </P><P></P><P>I have a tech. spec with me and I have to complete a report, can you help me out to write code for this.</P><P></P><P>Based on the entries on the screen , populate the item details in the screen into an internal table itab_item and header into an internal table itab_header. </P><P></P><P>The values should be populated in the report as shown in the attached Format.</P><P></P><P>The Discrepancy report can be generated only for the line items where Plan is blank.</P><P></P><P>Loop at itab_item.</P><P></P><P> GL_Account = itab_item-gl_account.</P><P></P><P> Account Description = Description of the GL Account.</P><P></P><P> Internal Order / Cost Center = </P><P></P><P> Plan start = Select AUFNR from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.</P><P></P><P> Pool = itab_item-pool</P><P></P><P> Account = itab_item-account.</P><P></P><P> Start allocation period = itab_item-zzvalid_fr</P><P></P><P> Ownership as per start allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.</P><P></P><P> Allocation as per start allocation = Multiply itab_item-amount with ownership as per start allocation.</P><P> </P><P> End allocation period = itab_item-zzvalid_to</P><P></P><P> Ownership as per end allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_FR = itab_item-end_alloc_from and ZZPOOL = itab_item-pool.</P><P> Allocation as per end allocation = Multiply itab_item-amount with ownership as per end allocation.</P><P> </P><P> Variation = Allocation as per end allocation - Allocation as per start allocation</P><P> </P><P> Discrepancy = Depends on change in plan . If Plan is added in the end alloc say Plan is ended.</P><P> If Plan is not there in the end allocation say Plan is defunded.</P><P></P><P> NR Plan: Select ZZBILLTYPE from ZPBILLMASTER where PLAN = itab_item-plan and itab_item- gl_account .</P></BODY></HTML> Mon, 04 Jun 2007 19:35:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/simulateallocation-discrepency-report/m-p/2384782#M529851 Former Member 2007-06-04T19:35:13Z Re: SimulateAllocation/ Discrepency Report https://community.sap.com/t5/application-development-and-automation-discussions/simulateallocation-discrepency-report/m-p/2384783#M529852 <HTML><HEAD></HEAD><BODY><P>The specs look pretty complete. Why don't you try coding it and get back to the forum if you have problems?</P><P></P><P>Rob</P></BODY></HTML> Mon, 04 Jun 2007 21:18:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/simulateallocation-discrepency-report/m-p/2384783#M529852 Former Member 2007-06-04T21:18:43Z