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.

[piyush_parekh · Accepted solution]

Hi,

Maintain uom as 1BU and uom conversion factor as 1 in respective version-specific MDTs against this product. While pulling data in planning view, select target UoM as 1BU. This will show data in their respective Base UoM. Base Version will show data in EA, other version will show data in PC.

Hope this helps!!

Regards,

Piyush

[former_member850208 · Accepted solution]

Hi Piyush,

Thanks. It worked.