Skip to Content
Author's profile photo Dibyendu Patra

Create Info Record for different Order Unit

*******************************************************************************************************

I have created a video for this functionality with a real time example in SAP system.

Link : Automatic price in Purchase order for different Order unit in SAP MM

*******************************************************************************************************

Business Scenario

As we know about info record and order unit. In this document we are going to learn how to create an info record with different price for different order unit.

Sometimes we purchase a material in different different order unit, as example in BAG, KG, BOX etc etc. and the vendor will take the different price for the different order unit.

As suppose vendor will take Rs. 50 for KG, Rs. 100 for BAG and Rs. 500 for BOX.

Here you can maintain the price for different order unit in info record. So we don’t have to maintain manually price for the different order unit.

Prerequisites

1. We have to maintain variable order unit in material master record.

Go to MM02, in purchasing tab

ScreenShot.jpg

The variable order unit will control your further action. This option will allow to use different price for different order unit. You need to maintain the variable order unit as 2-Active with own price.

Then maintain the unit of measure as per your requirement.

Go to Additional Data-Units of measure

ScreenShot.jpg

Maintain conversion as per your requirement.

2. Access Sequence

To use this facility, you need to be sure that your access sequence has the condition table 66 for ‘Info record per order unit’ and 67 for ‘Plant Info Record per Order Unit’. Otherwise, you can’t able to maintain condition record for order unit.

These condition tables are already maintained for access sequence 0002.

/wp-content/uploads/2013/12/dev_746027.jpg

If you are using any custom access sequence, then you need to maintain the condition table 66 and 67.

3. Create Info record

We have to create info record for this material with particular vendor.

Go to ME11. Give the vendor, material, purchase organization and plant and then press enter.

ScreenShot.jpg

You can see in general data, the variable order unit as 2 is automatically copied from material master.

Then press enter, you will go to the Purch. Organization Data 1 tab.

ScreenShot.jpg

Here enter you all information, and give the price for KG in net price field.

Then press Condition tab

ScreenShot.jpg

After pressing condition tab, a pop-up will shown to you (like as above screen shot) with all unit which you have maintained in material master.

We have to maintain different price in condition for each unit of measure.

Now select the KG and press Choose (You can double click on KG)

ScreenShot.jpg

Here maintain the price for KG (it will automatically picked because we have maintained price for KG in Purch. Organization Data 1 tab).

Then press back button.

You will go back to the Purch. Organization Data 1 tab. Then again press condition tab. Again you will see the pop-up box as shown in previous figure.

Now double click on the unit of measure BAG.

ScreenShot.jpg

Here maintain the price for BAG. As I have already said we will pay Rs. 100 for order unit BAG.

Then press back again.

You will go back to the Purch. Organization Data 1 tab. Then again press condition tab. Again you will see the pop-up box as shown in previous figure.

Now double click on the unit of measure BOX.

ScreenShot.jpg

Maintain the price for BOX. As I have already said we will pay Rs. 500 for order unit BOX.

Now save your info record.

 

Result

Now we are going to create a Purchase order for the same vendor and material.

Go to ME21N, fill the all details.

In line item, enter all details without price..

Firstly the default order unit will come PC and we can see the rate as well as maintained in info record.

ScreenShot.jpg

We can see the price Rs. 50 has come to Purchase order as we have maintained Rs. 50 for KG in info record.

Now I am going to change the order unit as BAG in this PO.

ScreenShot.jpg

Here you can see our price is automatically changed with Rs. 500, as we maintained Rs. 500 for BAG in info record.

Now I am going to change the order unit as BOX in this PO.

ScreenShot.jpg

We can also see here, the price will change automatically with Rs. 500 as we have maintained Rs. 500 for BOX.

Now you can save your PO with this order unit as per your requirement.

In this way we can maintain different price in info record for different order unit.

No need to do any configuration, just create the info record properly. You will able to fetch the price according to the info record.

You just need to be sure that you have the condition table as 66 – Info record per order unit for your access sequence. To know more about condition table and access sequence and how to assign each other, then have a look into the blog post Pricing procedure Steps and Details in SAP MM.

Assigned Tags

      70 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi,

      Thank you so much for sharing this interesting feature.

      With Warmest Regards,

      Mahboob Rahman

      Author's profile photo Vishnu Kumar Subbarayalu
      Vishnu Kumar Subbarayalu

      Hello Dev,

      Nice Document with Proper Explanation.
      Thank you so much for sharing.

      Regards,
      Vishnu...

      Author's profile photo Former Member
      Former Member

      Thanks Dev for Good Doc Keep On going Like this....i tried it worked thanks a lot

      Regards

      Shiva

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Thanks for sharing good info. Keep up the good work!

      We all are waiting for new updates and new innovation blogs! 🙂

      Regards,

      Hari Suseelan

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

      Thank you Suseelan Hari..

      Keep in touch.....

      Author's profile photo Former Member
      Former Member

      You are welcome. Definitely I will.

      Regards,

      Hari Suseelan

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      As usual nice document. Keep Rocking...

      Regards,

      Subbu.

      Author's profile photo Cecil D'Souza
      Cecil D'Souza

      Always well explained with screen shots. Good document. In one place under Pre-requisites, I think it is 'maintain conversion' but you have mentioned 'maintain conversation'.

      Author's profile photo Ravishankar Venkat Ramanan
      Ravishankar Venkat Ramanan

      Hello Dev Ji,

      Good work as always 🙂

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Thanks for document, I tried it.

      Dev.jpg

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      thanks for sharing Patra

      Author's profile photo Jürgen L
      Jürgen L

      Good docu, I had not know this function before. Yesterday I cross checked some of our systems and did not find it anywhere in use.

      Author's profile photo Former Member
      Former Member

      Hi,

      Superb documents keep it  up.

      thanks 🙂

      Author's profile photo Former Member
      Former Member

      Nice document dev 😉

      Author's profile photo Former Member
      Former Member

      Hi,
      Very detailed explanation with simple presentation, Thank you for sharing your knowledge with us 🙂

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

      Thanks for the nice comment....

      Author's profile photo Cecil D'Souza
      Cecil D'Souza

      If Jurgen the master approves of your presentation and document, then you have done a pretty good job and you can pat yourself on the back for your effort. We are all grateful to all you guys for helping and for sharing your knowledge and experience.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      I have made my material order unit 1 PAC = 10 PC, 1 BAG = 60 PC in the material master and also select Variable Purchase Order Unit 2. However, when I go to create info record there was no pop up upon clicking "Condition" tab.

      Is there any configuration I am missing here?

      Thanks

      Danny

      Author's profile photo Former Member
      Former Member

      Hi Danny..

      Have you maintained Variable Order unit as " 2 - Active with own price " in the info record General data?

      Regards

      Sesha.

      Author's profile photo Former Member
      Former Member

      Hi Sesha,

      You are right, I didn't maintain variable order unit at purchase info record.

      Danny

      Author's profile photo Former Member
      Former Member

      Hi Danny,

      Oh great...SCN rocks..

      Regards

      Sesha.

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

      Check the same variable order unit in info record creation time.

      Author's profile photo Pedro Perez
      Pedro Perez

      I have a question, what if a materials can be purchased by different vendors and they have different conversions for the same unit. For example for one vendor a box has 10 units and another one has 15 units/box. What should be done in this cases?

      Thank you¡

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

      Yes, you can do that...

      Just maintain the conversion factor differently in info record.

      ScreenShot.jpg

      Create two info record with two different conversion for two vendor with same material..

      Try it yourself and revert back.

      Author's profile photo Nitin Jinagal
      Nitin Jinagal

      Dev.. Nice write up but honestly saying, I didn't follow much as I have never worked in MM 🙁

      But surely it would come handy sometime so I have bookmarked it 🙂

      I want to ask if anytime if possible, can you release a document for the basic functionality of MM (I'm asking from QM point of view). I'll explain,

      1. Creating a PO
      2. Doing MIGO/GR against it & accordingly posting the stock to UR, Blocked or QI.
      3. Next process could be either of consumption or Quality inspection
      4. In both situation, if return to vendor is required, what are the basic steps?
      5. Prerequisites of return process.

      I don't if you have already released such document or someone else because I never searched intensely (don't know what would suit me).

      If you know about such doc, please share with me!! If not, do release anytime you want as per your comfort.

      I don't even know if I need to create a thread for this because everybody would jump onto me as this is not something hard to get 🙂 , I just don't know how to get !!

      ntn

      Author's profile photo Jürgen L
      Jürgen L

      Those basics are well explained in help.sap.com and Best practice packages, a moderator would reject such documents.

      Author's profile photo Nitin Jinagal
      Nitin Jinagal

      Oops! That's why I already mentioned that. Will refer few help documents and thereafter, I think I should raise query, if any

      ntn

      Author's profile photo Sanjib Naik
      Sanjib Naik

      Hi Dev,

      Its really valuable information, thank you so much for sharing this doc, please keep  it up superb  for sharing  valuable effort.

      Best regards,

      Sanjib Naik.

      Author's profile photo Former Member
      Former Member

      Really very valuable information Dev.  Thank you for sharing.

      Regards

      Ravikant

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Good Doc indeed!

      1. At the end of the Blog Unit "PC" appears, I think you mean it "Kg".

      2. In which case Var Ord Unit = "1" (active) to be used?

      3. Is it possible to have Var Ord Unit as "1" for Vendor 1 and "2" for Vendor 2. But if it is getting defaulted from Material Master to Info Record, then how to do that. But this question has dependency on Question 2.

      Regards

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

      1. Correct, that was a mistake, I have changed this. (Thank You for the support)

      2. Var. Order Unit 1 is used when we have to use different unit in purchasing document.

      3. Yes, you can use 1 for vendor 1 and 2 for vendor 2.

      At this position you have to change the variable order unit in info record.

      Author's profile photo Former Member
      Former Member

      Hi Mahi,

      In addition to Dev Sir comment one more information for question 3. Of course you can use Var Ord unit as "1" for vendor 1 and "2" for Vendor 2. But if you use Var Ord unit as "1" in inforecord you may not go for Different prices for different order units. Only it is possible if you use Var ord unit "2" in inforecord.

      Regards

      Sesha.

      Author's profile photo Former Member
      Former Member

      Simple, New and very much useful. thanks

      Author's profile photo Former Member
      Former Member

      very useful document...

      nice work dude....

      Author's profile photo Former Member
      Former Member

      I have got a similar requirement for Purchasing Cotton. Cotton are purchased using Bale as UoM. Price is negotiated with different UoM like Candy/Mound. Conversion between KG to CND/MND is fixed. But, 1 bale can contain , 165-175 KG. I believe this document will help me in testing this scenario. Nice one.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Thank you for this nice document.

      Good work.

      Regards

      Keerthi

      Author's profile photo subramanian sankaran
      subramanian sankaran

      Hi DeV,

      Nice one. It will help me in future.

      Author's profile photo Former Member
      Former Member

      nice one.

      Author's profile photo Former Member
      Former Member

      ultimate and fantastic

      Author's profile photo Former Member
      Former Member

      Hi dev

      can you tell me what are the fields you have taken

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

      which field you are talking about ?

      Regards

      Dev

      Author's profile photo Former Member
      Former Member

      for the pricing procedure

      Author's profile photo Former Member
      Former Member

      Hi Dev,

                Its Help full Doc.

      Author's profile photo Nitin U Kaple
      Nitin U Kaple

      Very good document.

      Author's profile photo Amit A. Kothekar
      Amit A. Kothekar

      Hi Dev,

      Its really a nice and informative document.

      I checked this in my system and found that system allows me to put any UoM in Purchase Order Unit field. Ex. if I maintain conversion for a material in MMR Yard - Meter, Yard - Feet but I can keep the Purchase unit other than these two also.

      How can I stop this and only allow those which I have maintain in MMR.

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

      If you set the field value 1 or 2 for Variable Order Unit, Then system will allow to use all unit of measure (which is assign with material master) for PO order unit.

      If you set the value as blank, then system will always take the base unit of measure as PO unit or Order unit as PO unit (If any).

      Author's profile photo Amit A. Kothekar
      Amit A. Kothekar

      I have set this indicator as you suggested but still system allows me to pick any Purchase Unit irrespective of MMR.

      I also tried after changing the message 06340 as E but the result was same.

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

      Check again. The conversion must be maintained in material master - Additional data - Unit of measure.

      If the unit of measure is not maintained in material master then system will prompt a error message as "Order unit XXX cannot be converted into base unit XXX".

      If you are still facing same error, then please create a discussion with screen shot for material master and PO.

      Author's profile photo Amit A. Kothekar
      Amit A. Kothekar

      Hi Dev,

      Please find the screenshots, from MMR and Info Record, for reference. I have not maintain any Uom other than Basic Unit still system allows me to select any Purchase Order Unit in Info Record.

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

      It is correct, you can use any unit of measure order unit in info record. It doesn't depend on your material master, It will pick the conversion (below). But it will be valid for only this vendor which is in the info record.

      Author's profile photo Amit A. Kothekar
      Amit A. Kothekar

      But how to control it? My client does not want user to put any unit other than maintained in MMR.

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

      I think you should create a discussion regarding your issue.

      Author's profile photo Former Member
      Former Member

      Hi Amit,

      You can try with Order unit in Material master Basic data.

      Regards

      Sesha

      Author's profile photo Former Member
      Former Member

      Hi DEV,

      Wonderful Document with better clarity and beautiful explanations...Waiting to see some more like this....

      Good Effort....

      With Warmest Regards,

      Sathish

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Is there a way that we can have a different UOM for subcontract process?  We have a vendor that is charging per lot us for outside process but our finished part and component part is in pc.

      Thank you for any insight.

      Sally

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

      If you will set the variable order unit as 1 or 2, then you can use different order unit in PO as per your requirement. You just need to maintain the conversion in MMR.

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      When we set up a subcontract purchasing info record there is not a part number associated with it so therefore it will not pull the order unit in to the PIR.  Is there some way to connect it somehow?

      Author's profile photo kumar kumar
      kumar kumar

      Hi Dev, once again u done a good job for Sharing a such nice Document. Thanks & Regards Kumar

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      Its really a nice document. Thanks for sharing. 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Hi Dev,

      It is really nice document. I have not used it. I had some doubts while practicing on sandbox earlier, after reading your document i have cleared my doubts, Thanks for sharing 🙂

      Author's profile photo Former Member
      Former Member

      Hi Dev ,

      Thanks for sharing such a nice document

      Author's profile photo Former Member
      Former Member

      Hello Dev,

      This is very informative.. Thanks for sharing!!!

      I have a scenario.

      Is it possible to have vendor auto-picked from PIR based on the "Order unit "

      Suppose I have 2 vendors P and Q delivering the same goods G in packs of 180 kgs and 190kgs respectively.

      If my ordered quantity is a multiple of 180 kg then vendor P should be auto-picked in the PR, if the quantity ordered is a multiple of 190 kg then Vendor Q should be picked.

      Based on your above document I've come across half the possible solution.

      i.e by creating two different order units X(180kg) and Y(190 kg). If we maintain PIR with these order units separately(combination of Vendor Q and Order UoM X - PIR 1 and Combination of Vendor Q and Order UoM Y - PIR 2.

      If in the PIR I change the Order Unit to desired one will the PR pick the right vendor?

      Regards

      Gayana

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

      No. Vendor can be defaulted only from source of supply (source determination), not only from info record.

      General concept of info record is to pick price with some combination.

      Author's profile photo Former Member
      Former Member

      Nice document. Very informative Thanks for sharing.

      Author's profile photo Mohamed Hefnawy
      Mohamed Hefnawy

      Thanks Man, the illustration procedure is very powerful.

      Author's profile photo Srinivas K
      Srinivas K

      It is very good Thanks 🙂

      Author's profile photo Former Member
      Former Member

      One we maintain various ordering units, which ordering unit will MRP propose and how can I make MRP propose ordering unit according to my requirement?

      Author's profile photo Former Member
      Former Member

      Nice document 🙂

      Author's profile photo G. Manchikalapudi
      G. Manchikalapudi

      Hi Dibyendu Patra,

      First of all nice document and explained in details.

      I have one query: Is there any limit to these Variable order unit which can be maintained in info record. SInce in my case I have 8 AUoM maintained in material master and in info record I could see only 5. When I delete or add any AUoM it start appearing in Info record.

      SO my further query is whether it consider last 5 updated AUoM or what is the logic?

      Thanks,

      Mahesh

      Author's profile photo Citizen Citizen
      Citizen Citizen

      We have all this set up and as in your example it works for purchase order. However, it doesn't work for purchase requisition. It determines the inforecord, however, doesn't inform or change the purchase unit of measure. any idea why? Even if I change it manually, it doesn't change it.