SimulateAllocation/ Discrepency Report

[Former Member]

Hi experts

I have a tech. spec with me and I have to complete a report, can you help me out to write code for this.

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.

The values should be populated in the report as shown in the attached Format.

The Discrepancy report can be generated only for the line items where Plan is blank.

Loop at itab_item.

GL_Account = itab_item-gl_account.

Account Description = Description of the GL Account.

Internal Order / Cost Center =

Plan start = Select AUFNR from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.

Pool = itab_item-pool

Account = itab_item-account.

Start allocation period = itab_item-zzvalid_fr

Ownership as per start allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_TO = itab_item- start_alloc_from and ZZPOOL = itab_item-pool.

Allocation as per start allocation = Multiply itab_item-amount with ownership as per start allocation.

End allocation period = itab_item-zzvalid_to

Ownership as per end allocation = Select ZZOWNER from ZPOOLOWNER table where ZZVALID_FR = itab_item-end_alloc_from and ZZPOOL = itab_item-pool.

Allocation as per end allocation = Multiply itab_item-amount with ownership as per end allocation.

Variation = Allocation as per end allocation - Allocation as per start allocation

Discrepancy = Depends on change in plan . If Plan is added in the end alloc say Plan is ended.

If Plan is not there in the end allocation say Plan is defunded.

NR Plan: Select ZZBILLTYPE from ZPBILLMASTER where PLAN = itab_item-plan and itab_item- gl_account .

[Former Member]

The specs look pretty complete. Why don't you try coding it and get back to the forum if you have problems?

Rob