Display of a key figure data in different UoM - Excel Planning View in SAP IBP

[former_member850208]

Hi All,

Is it possible to display a Key figure data in more than one UoM? We have following scenario:

There are two versions ( Base and UPSIDE) where we have maintained different base unit of measurement ( PC and KG) respectively with conversion factor 1PC = 2 KG. While loading data in excel planning view,

1. Both the versions are selected

2. While selecting KF to be displayed, Unit of measure to ID is selected as PC

When we load, we can see KF data for both the versions but their value remain same irrespective of conversion factor. For ex-

KF in base version (PC) = 100 100 100 100

KF in UPSIDE version ( KG) = 100 100 100

This is happening as we have selected PC while loading data but we want to see value in upside version after conversion ( 200 200 200 instead of 100 100 100)

Is there any way to do it? Kindly let me know.

[former_member850208]

Hi Lokesh,

Thanks for quick reply. Version specific conversion factor is maintained. It is same as base version. This is how it looks when i use target UoM= PC in Edit planning view> Key Figures. It is converting to PC in both version

This is how it looks when i use target UoM = EA in Edit planning view> Key Figures. It is converting to EA in both version

We want it to look like this irrespective of target UoM we choose while editing planning view where system should convert data based on base UoM maintained for that version