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

[AyanBishnu]

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.

[KacperBenner]

Hi , Thanks for your input! I see your point about using attribute transformation with a custom MDT to store the "From → To" relationship for product mapping. However, in this case, I don’t think this approach is suitable for copying key figure values within the same key figure for a different Product ID. Why Attribute Transformation is not the right solution here: 🔹 Attribute Transformations are designed for master data, not transactional key figure values. They work well when modifying attributes (e.g., assigning categories or flags) but don’t perform direct key figure value copies. 🔹 Using a custom MDT with a reference ID does not solve the issue of copying values within the same key figure. The planning area still expects the key figure values to be assigned at the original product level, and additional logic would be needed to ensure correct mapping. 🔹 Cyclic dependencies and planning area activation issues. As you mentioned, if KF1 is used as a source for KF2, we can’t use KF2 as a source to update back KF1. This further complicates the process and introduces unnecessary complexity. Why Realignment Makes More Sense If the requirement is ad-hoc, then realignment rules are the best option. They are designed to reassign key figure values based on a mapping table and work within the same key figure without needing additional logic. Would you agree that realignment is the best approach for this use case, or do you see another potential method that aligns better with SAP IBP's capabilities? Thanks for your insights! Best regards, Kacper