Skip to Content
Author's profile photo Dibyendu Patra

Default alternative unit of measure and conversion in material master by using unit of measure group

Last week, I obtained a requirement from purchasing team, my super users are creating material masters, but sometimes they enter wrong conversion factor in material master or they forget to enter one or more alternative unit of measures. We use many unit of measures as alternative unit of measure. As we know once we create purchase order with the conversion from material master, then if we change the conversion in material master, purchase order still remain old conversion, either we need to create a new purchase order or new line item.

My purchasing team told me to default these conversion factors and all alternative unit of measures as they want. I got experience of a new functionality in SAP system (sorry, if you already know this). I want to share it. It is really simple.

We can achieve this by using Unit of Measure Group. I’ve found hint of this in this help document Units of Measure – Material Master (LO-MD-MM) – SAP Library.

It is a configuration step; you can find this step SPRO-IMG-Logistics – General-Material Master-Settings for Key Fields-Define Units of Measure Groups. You can call the view V_006M from SE11 or SE16, these entries are stored in table T006M.

In this step, we need to assign a unit of measure group as per our defined alternative unit of measure and all conversion factors.

Go to this path and execute this, click on new entries:

/wp-content/uploads/2015/07/1_751374.jpg

You can see this above screen.

     1.  This is unit of measure group. You can use a specific code with 4 alpha-numeric character.

     2. This is Alternative unit of measure. You need to give all alternative unit of measures which you want to assign in material master.

     3. This is counter. It is numerator of the conversion factor.

     4. This is Denominator. It is denominator of the conversion factor.

You need to use the counter and denominator as below:

Suppose your base unit of measure is PC and you want to use an alternative unit of measure as BAG. You conversion factor is 1 BAG = 200 PC, so you need to give alternative unit as BAG and Counter as 200 and Denominator as 1.

As per this rule, maintain all alternative unit of measures and it’s conversion as per your requirement. (Remember, you need to use only one unit group to specify these all alternative unit of measure and conversion into one, you can use multiple unit groups to use different alternative unit of measure and conversion factor. These all conversion factor will be calculated with base unit of measure.)

/wp-content/uploads/2015/07/2_751375.jpg

Save your entries.

Then go to create material. Maintain Base unit of measure as per your requirement in basic data 1 view. Now go to Additional Data – Unit of measure tab and open the field’s option as below:

/wp-content/uploads/2015/07/3_751382.jpg

You can find those all entries which you have created earlier. You can see the unit of measure group along with its assigned unit of measure.

Now just select your required unit of measure group. You can see after select the unit of measure group, system will fetch all those alternative unit of measures and conversion factors immediately which is assigned with this unit of measure group as below:

/wp-content/uploads/2015/07/4_751383.jpg

Note: Do not select same group second time, if you will select the same group again then these all entries will be fetched again. If you think you have selected wrong group, then you need to leave this screen (transaction) and you need to do it again from transaction MM01 or you can delete this manually one by one. Then again, you can select another unit of measure group.

/wp-content/uploads/2015/07/5_751384.jpg

Now just continue to next screen and finish your work.

If needed, then you can change the conversion or alternative unit of measure from the same IMG path.

Remember, after change the conversion in img path, system won’t change conversion in material master automatically. You need to change it manually or you can delete these conversions manually and then call the unit of measure group again to fetch the new alternative unit of measure along with conversion.

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Nice tip DV. Thanks a lot for sharing this doc to us.

      BR

      KNR

      Author's profile photo B V Yadav
      B V Yadav

      Nice Document Dev Sir, thanks for sharing.

      Regards,

      BV

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hey Dev

      Looks simple settings to control this. I'ill try this in my system when I get some time from busy schedule 😉 .

      Thank$

      Author's profile photo Ada Gu
      Ada Gu

      Thanks.It's very useful for me.

      Author's profile photo G.S. Lavakumar - MM
      G.S. Lavakumar - MM

      Hi Dev

      i really appreciate your attitude ,thank you very much for sharing your experience.

      Author's profile photo Chanabasappa Kallapur
      Chanabasappa Kallapur

      Thanks for sharing this Dev

      Author's profile photo Joseph Dmonte
      Joseph Dmonte

      This is useful document Dev sir.

      Author's profile photo Mahesh Patel
      Mahesh Patel

      Great Article! A few follow up questions to make the best use of the newly created alt UOM group.......

      1. How can I use Alt. UOM group with BAPI_MATERIAL_SAVEDATA? I couldn't find a field for it in the BAPI.
      2. Is there a way to mass update existing materials in the system with newly created Alt UOM group? MASS or MM17?

       

      Author's profile photo Federica Lerussi
      Federica Lerussi

      Hi Dev,

      We have decided to use PCS as base unit of measure for all products to avoid any misalignments, but we have recently realized that for some items the unity of measure that we usually use it is wrong.

      For example we consider a pac item with 10 pcs inside as 1 pc. So we decide to add the alternative unit of measure of these items in Pac using the base unit of measure as pcs as you have explained in your post.

      So the currently converison rule 1 pc = 1 pac has to become 1 pac = 10 pcs. So we need to multiply all the stock existing by 10. Example:

      Now we have 13 pcs of this item on stock, after the change has to be 130 pcs.(13 pac= 130 pcs)

      How could we do that? We have tried to create new stock with the existing batches with transaction MB1C movement 961, but the work is to do manually so we risk a lot of mistakes.

      Do you know if there is a simpler way to multiply the existing stock? I tried to use the denominator factor (X) in the alternative unit of measure, but I cannot modify this parameter for the base unit of measure.

      Could we use this denominator factor to reach the correct value of stock’s conversion for pcs as well?

      Do you know if anyone ever made it?

      Thank you in advance

      Best regards

      Federica

      Author's profile photo Manju Priya
      Manju Priya

      Nice Explanation

      Author's profile photo Tapan Rana
      Tapan Rana

      really appreciable....only doubt what about financial/accounting JE impact  - gut suggest it should not be touched and modified , kindly give light

      Author's profile photo Dibyendu Patra
      Dibyendu Patra
      Blog Post Author

      No. There wont be any impact in finance/accounting.

      Author's profile photo Tapan Rana
      Tapan Rana

      Greetings & thanks for update

      Author's profile photo Rahul Kumar
      Rahul Kumar

      Great Article! Thanks, for sharing.