Copy Values within same KF with different Product ID

[former_member267321]

Hi,

We have a requirement to copy key figure values within the same key figure but to different product ID.

EX. Unconstrained Demand Qty

PRDID- A, CUSTID-B, PERIOD- MARCH, Qty -100

Copy to

PRDID-X, CUSTID- B, PERIOD-MARCH, Qty-100

So, same values should be copied to different SKU but within same key figure.

Please suggest how to do this?

Regards,

Kiran

[piyush_parekh · Accepted solution]

Hi Kiran,

This can be achieved using Data Realignment functionality in IBP. Please find below SAP Help link for reference.

https://help.sap.com/viewer/feae3cea3cc549aaa9d9de7d363a83e6/2102/en-US/463d888ebb2447a8b117961d4e97...

Regards,

Piyush

[ayanbishnu1981]

Hi Kiran

Do you have any relationship between PRDID A and X ? In case you have that where lets say you have table that say PRDID A need to be copied to PRDID X or / and Y, Z and so on. If that is the case you can automate the copy process using attribute transaformation in IBP where you need to create a new custom MDT of type compound / reference, which will have a identical base planing level as as the source KF, but with a different ID. The custom MDT will store the From and TO relationsip from PRDID A to PRDID X or even PRDID A to X,Y and Z equally or using any %. and once the value is updated you can copy that back to the source KF either using copy operator or manual. One limitation is you if you use KF1 as a source and KF2 as a target using expression then u cant use the KF2 as a source to update back KF1, as that will create a cyclic reference and the planning area wont be activated. So either you have to break the cycle using copy operator or using a 3rd intermidiate KF

And in case you have the relationship and have this requirement to be performed adhoc, then realignment is the option as mentioned by Piyush above.