SAP IBP: Attribute Transformation for Fixing Source of UoM equals to "API"

[Former Member]

Dear Expert,

Currently our customer is having a new requirement for calculating "Projected Stock Coverage" with Target UoM conversion fixed into API.

I tried to read some use case of attribute transformation. Normally we use attribute transformation for changing one attribute with another similar attribute (ex: product & product substitute, etc..).

But for our requirement case, instead of using target UoM chosen from excel "edit planning view", we would like to make the target of UoM conversion always fixed into "API" UoM. Is it possible to achieve this by using the attribute transformation?

Regards,
Julius

[drbanning · Accepted solution]

Lingaiah,

I was not aware we could fix the calculation to always display a specific UOM. I know that we can do an 'IF' statement that would display the value if UOMTOID = 'API', but that will only display the value when the UOM is set to API in the Excel Planning view.

Is there any way to always display the value in the 'API' measure, regardless of the UOM setting in the Excel planning view? Much like the value will always display in the base uom if you don't have the UOM calculation conversion setup for the KF.

Dan

[lingaiahvanam]

Hi,

You can create a new key figure Projected Stock CoverageAPI reference with Projected Stock Coverage and write the calculation to fix UOM to API.

Check this scenario and let me know if it is not working.

Best Regards,

Lingaiah

[amit_amit_8844]

Hi Lingaiah...we have similar requirement where we want to display value of Keyfigure in always fixed UOM instead of what is selected in Planning view....as you mentioned to write the calcualtion to fix UOM ...so can you ive more infor on this on how to write ths calculation?