Intercompany COGS allocation - Script logic

[Former Member]

Hi All

Below is the requirement to write the script logic in SAP 10.0 NW

Objective : Total COGS Amount (In Cell M17, 800/- ) should be distributed to respective levels at each Country / GPH / SBU of COGS amount but at the same time for distributing at each ICP of Sales Account combination.( i.e., we should not consider the ICP of COGS for the destination Records)

In the below image:

Source 1:  Sales information

Source 2:  COGS information

Results Expected : All the resultant records should have dimension combination considered from COGS(Source-2) except the ICP combination from Sales (Source-1).

Is it is possible through script logic, to get in the destination records with few dimension members from one combination (ICP from Sales account records )  and the rest from other combination (Country/SBU/GPH from COGS Account records).

The below Column N and Column O show the explanation of the calculations for getting the amounts.

I have used the *LOOKUP functions and *WHEN *ENDWHEN functions and tried. However, I could not figure out how to bring the ICP members from Sales Account combination to the destination records instead of considering from COGS account combination (which comes by default when we use the *WHEN function with COGS account).

Looking forward your help in this regard.

Thanks

Srikant

[Former Member]

Hi Srikant,

It looks to me as a regular RUNALLOCATION. Try scoping Source-2 as WHAT and Source-1 as Using with those NO_... members. WHERE will be same as WHAT except ICP is from USING.

Regards,

Gersh

[former_member186338]

Sorry, the explanation is not clear and screenshot is completely unreadable. Pleas provide the script you created and explain what is wrong...

Vadim