Skip to Content
Author's profile photo Former Member

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.

9-9-2014 14-51-06.jpg

  In the additional Data:

9-9-2014 14-51-58.jpg

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.

9-9-2014 14-46-51.jpg


When you go to ‘Additional data’ you can see the Alternate UoM updated:

9-9-2014 14-55-19.jpg


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.

9-9-2014 15-02-29.jpg

select transfer global setting and import the details of Currency, UoM etc:

9-9-2014 15-02-55.jpg


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):


APO system:

Lets access the global data of the product which got CIFed

9-9-2014 15-06-10.jpg


We can see the Alternate UoMs updated in the global data of Product.

9-9-2014 15-06-39.jpg


Now lets access the product in SDP94 in APO:

9-9-2014 15-09-23-2.png

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:

9-9-2014 15-11-32-2.png


As mentioned in the screen, these setting are per Planning book/User/selection.

9-9-2014 15-11-32-3.png

Reload the data view, and you can see the update:

9-9-2014 15-15-49.png


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.


Other options:

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.

9-9-2014 15-23-07.jpg

9-9-2014 15-23-33.jpg


Also, in Planning area we can make this setting for each keyfigure:

9-9-2014 15-25-27.jpg

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.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.