Setting up Alternate UoM as default in Data View
In this document, I will share my experience in setting up default alternate Unit of Measure for a Product in Data view.
First, when we maintain data in ECC, we upload the data in material master and maintain alternate Unit of Measure.
Also, for example: we have sales order unit, which could be different from base unit of Measure.
And, all users may not be comfortable to see the data in Base unit of measure in a data view.
For example Sales team what to see the data in Sales order unit of Measure than the base unit of measure.
Below are the steps which help you to set up the Alternate Unit of Measure as default UoM for a user (without hardcoding in planning area):
Lets maintain a Base unit of Measure and see the ‘additional data’ tab for the alternate UoM.
In the additional Data:
So the Base UoM is PC and No alternate UoMs.
Maintain Sales Order Unit of Measure:
Now lets say, we want EA (each) as Sales order Unit.
When you go to ‘Additional data’ you can see the Alternate UoM updated:
Now, CIF the data to APO system.
Prerequisites before CIFing the data to make sure that all UoMs data/config between both systems are up to date.
Below is the screenshot of APO system where you can pull the UoM data from ECC to APO. I will not dwell much into this process, in this blog/document.
select transfer global setting and import the details of Currency, UoM etc:
Choose the data you want to receive from source system into APO and also choose the mode…you can try on simulation mode to learn on the process.
Now, CIF the Plant data, Material data to APO system. ( I will not dwell much into Model set up and details in this blog):
Lets access the global data of the product which got CIFed
We can see the Alternate UoMs updated in the global data of Product.
Now lets access the product in SDP94 in APO:
We can see the base unit of measure as default for this product.
Now, if we want to change the default UoM to sales order unit of Measure (or alternate UoM), then select the user setting in the planning table:
As mentioned in the screen, these setting are per Planning book/User/selection.
Reload the data view, and you can see the update:
That means, if a new user want to see the data in other UoM, then his settings need to be maintained too. Or even, if the same user wants to see in different UoM, then that can be done using other selection profile.
When you create Planning area, you can choose the base unit of measure in which the Planning area data should run. But, this would apply for all users, products, data etc.
Also, in Planning area we can make this setting for each keyfigure:
If you set this indicator, for that keyfigure, the UoM is always shown in Base UoM, which can be other than Planning area UoM (this can lead to inconsistency), for all materials, data combinations etc.
So, given the options, we can decide whether we want to generate different selection profiles for different UoMs, maintain user settings and work with data accordingly. This option could be one time effort in generating more profiles and user combinations but is flexible.