Skip to Content
Author's profile photo Jürgen Lins

Unrestricted use stock not equal to available stock

A frequent misunderstanding is the assumption that the unrestricted use stock is identical with available stock

Unrestricted use stock is a stock type, that can be used for everything, has no restriction based on its condition. Other stock types are quality stock and blocked stock.

Available stock can be equal, can even be more than unrestricted use stock, can be less than unrestricted use stock. You define yourself in the ATP checking rules how you calculate the available part of your stock

A look into our warehouse:

MMBE_unrestricteduse.PNG

and the same in the stock overview transaction MMBE

MMBE_unrestrictquality.PNG

You see 263 are in unrestricted use, 1 is in quality inspection.

But how much is available?

Depends on the point of view.

If you are a CSR and you want to check how much of this can be sold with the next order or if you are  checking the stock/requirements list e.g. as a planner.

On the left you see transaction CO09 availability overview used by the CSR, on the right the Stock/Requirements list from the planner

CO09_MD04.PNG

Click the picture to enlarge, if you can’t read it


CO09 transaction shows 262 available, MD04 shows 264 available in the stock line on top. And both do not equal the 263 unrestricted use stock.


Why is this?

CO09 actually starts with 263, you can see this in Rec./reqd qty column, the ATP quantity got immediately reduced by the reservation of 1. And it did not include the quality inspection stock.

This is defined in OVZ9 Availability check control. The availability check 02 is coming from the material master, the 01 is my selected checking rule when executing CO09.

OVZ9.PNG

As you can see, safety stock is defined as available here, and on the right it is defined what is considered  as incoming and outgoing movements.


Contrary MD04, the stock requirements list shows 264 as available, but why? Because Quality inspection stock is included into available stock by definition of Net requirements calculation.

Additionally you can define in customizing transaction OMI8 Available stocks if you include even stock in transfer, blocked stock and restricted use stock (this is a batch status)

OMI8available stocks.PNG



Let us enter a purchase order of 20 and see how the situation develops.

CO09_MD04after PO.PNG

Both transactions show the purchase order as MRP element, both numbers go up by 20.

CO09 shows now 282 and MD04 shows 283

Wait…CO09 shows as well 262, why 2 different ATP quantities in CO09?

Because CO09 shows a total at plant level, and it shows a total at storage location level (and it will have a total at batch level if the material is batch managed)

And since no storage location was entered in the purchase order, only the available stock at plant level goes up.

And why is a purchase order considered as available stock? See your checking rule for CO09, purchase orders are marked to be considered as incoming movement. And in MD04 it is considered too, the available stock goes up at the date when the goods are planned to be delivered.


Next experiment. I add a safety stock of 50 in the material master MRP2 view. What happens to CO09 and MD04?

CO09_MD04after safety stock.PNG

As expected, based on the checking rule definition, CO09 does not change because safety stock is defined as available.

But MD04 got a new line showing the safety stock, and reduces this quantity from the available quantity.



One last activity, I add a sales order for 100

CO09_MD04after SDorder.PNG

And in both transactions the sales order can be seen as a reduction from the available quantity…at plant level

It is not reduced from the storage location level, because the storage location was not entered in the sales order.


I hope this rough overview with these small examples helps you to know that unrestricted use stock is different from available stock.

Assigned Tags

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

      Hi,

      thanks a lot

      Some Clarity came regarding Unrestricted stock Nice 🙂 post

      Author's profile photo Former Member
      Former Member

      Very well explained !! Thanks for sharing.

      Regards,

      Author's profile photo PRASOON AK
      PRASOON AK

      Hi Jurgen...

          Nice document. Thanks for sharing and supporting...

      Regards,

      AKPT

      Author's profile photo Srinu S
      Srinu S

      Than you for sharing helpful document.

      Srinu.

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

      Thanks for sharing nice document.

      Regards,

      Subbu.

      Author's profile photo SAP ERP
      SAP ERP

      Hi,

      Nice one...........Thank you..........

      Author's profile photo varun yadav
      varun yadav

      Nice one.

      Thanks for sharing it.

      Author's profile photo Ravishankar Venkat Ramanan
      Ravishankar Venkat Ramanan

      Hello Jurgen,

      Well explained with precise statements. Screenshots really helped 🙂 🙂

      Thank you.

      Author's profile photo Uday Kumar
      Uday Kumar

      Thanks Jurgen,

      you are the best...

      Regards,

      Uday K.

      Author's profile photo Former Member
      Former Member

      Excellent document, as usual!!!

      Sir, Availability date of PO is as per PO delivery date or planned delivery time from material master? Will system ask for rescheduling if PO delivery date is in past?

      Thanks.

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      the most accurate information is pulled, which is in case of an existing PO, the information from the purchase order. The availability date is the delivery date plus the goods receipt processing time considering your plant calendar.(non-working days)

      more details and a nice graphic in: Scheduling - SAP Forecasting and Replenishment

      Author's profile photo Ajit Kumar
      Ajit Kumar

      Dramatic presentation!   You should be Education ➕ 😀

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      Thank you all for the nice compliments.

      Author's profile photo Dee Cee
      Dee Cee

      Hi Jurgen,

      Great document explained in a precise and simple to understand way.

      This also takes people to understand the very good and powerful feature of Availability Check.

      I do understand that this document is purely to understand the meaning of Unrestricted Use Stock from different perspectives. 

      It would be nice if you can expand your explanation the field RLT which in my experience confuses a lot of people on how it behaves in calculating and confirming availability.

      Would it be too much to ask if you can add that piece here ? 🙂 Or you dealt with Availability Check in detail somewhere else ??

      Your

      Thanks.

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      Hi,

      I appreciate your comment, but enhancing it with replenishment lead times would actually take the focus away from purpose of that document. It was really just meant as evidence that unrestricted use stock is not the same as available stock. RLT is actually often subject in Uwe Goehring's blogs. He wrote actually 22 of 23 blogs that can be found when searching for "replenishment lead time"

      He has even a great video on availability check in Youtube: SAP availability check options - YouTube

      Author's profile photo Dee Cee
      Dee Cee

      Hi,

      Thanks for your response. I was not aware of that.

      You have a good one.

      Thanks.

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

      Thanks for sharing your knowledge and your contribution is so impressive. As usual once again very good presentation from your side...

      Regards

      Sesha.

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi all;

      Thanks for sharing Mr.Jurgen related with MM/PP intgration and details.

      Regards.

      M.Ozgur Unal

      Author's profile photo Former Member
      Former Member

      very helpful

      Author's profile photo Former Member
      Former Member

      thanks for sharing..you are the great 🙂

      Regards,

      Hanmanth

      Author's profile photo Former Member
      Former Member

      Thanks for sharing, Jurgen.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing....Very helpful

      Author's profile photo Former Member
      Former Member

      Very good Sir..Explained clearly about the Available stock functionality.

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      Thank you all very much for this positive feedback. I had really not expected it for this little piece of clarification on a common misunderstanding

      Author's profile photo Former Member
      Former Member

      Precisely explained the difference between MD04 and CC09,Good

      Author's profile photo Ravi Babu Pasumarthi
      Ravi Babu Pasumarthi

      Hi Jurgen,

      Thanks for sharing the document and knowledge. Expecting more....

      Author's profile photo Girish Adaviswamy
      Girish Adaviswamy

      thanks for sharing nice document

      Author's profile photo subramanian sankaran
      subramanian sankaran

      thanks for the nice explanation.

      Author's profile photo Caetano Almeida
      Caetano Almeida

      Hello Jürgen

      This is a very useful document, since I have seen many questions on this topic.

      I'll add this document to my bookmarks.

      BR

      Caetano

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      Now I am conviced too 🙂

      Author's profile photo Former Member
      Former Member

      Thanks  for  sharing the   document .

      So many are  confused  with actual and  available  stock .

      Now  you clearly explained  with screenshots .

      I hope  for  all the  MM/PP  consultants  have  understand the  difference between them .

      Author's profile photo Former Member
      Former Member

      As usual, proud to have someone like you in this forum who is willing to share good knowledge. I will take a print of this document and keep this handy - will definitely save me from PP  😳 blushes

      Author's profile photo Former Member
      Former Member

      Excellent piece of information

      Thanks,

      Asha

      Author's profile photo Rakesh M Choudhary
      Rakesh M Choudhary

      Hi Jurgen,

      Nice explanation on a commonly (mis) understood concept.

      Thanks

      Rakesh

      Author's profile photo Ramagiri Srinivas Rao
      Ramagiri Srinivas Rao

      Hi Jurgen,

      It's very useful document. Thanks for sharing.

      Thanks & Regards,

      Ramagiri

      Author's profile photo Former Member
      Former Member

      Thanks for the info

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

          Nice document. Thanks for your knowledge sharing.

      Regards,

      Manikandan G

      Author's profile photo Former Member
      Former Member

      Thank you for sharing !!

      Author's profile photo Ramagiri Srinivas Rao
      Ramagiri Srinivas Rao
      Hi Jürgen L

      Thanks for sharing your knowledge. Good document explained in simple way to understand.

      Thanks & Regards,

      Ramagiri

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

      Very well documented. Thanks for sharing.    


      Cheers

      ray

      Author's profile photo Uma pathy
      Uma pathy

      Hi Jurgen,

      It is very nice and life time document. Thanks for sharing

      Regards,

      Umapathy

      Author's profile photo Former Member
      Former Member

      good, very inspiring.

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

      Thanks for sharing the document.

      Regards.

      Author's profile photo Peter Wallner
      Peter Wallner

      thank you for this very useful explanation.

      Author's profile photo Former Member
      Former Member

      Thank you Jurgen!!!!  Very useful and helpful document

      regards,

      Sean

      Author's profile photo Former Member
      Former Member

      Thanks...looks like all these answer lies beyond MM alone.

      Author's profile photo Former Member
      Former Member

      Hi Jurgen,

      Indeed its a good Explanation. But a common question that every client puts in that they need a report which will show them the "Actual Available" qty ( CO09) and they are really not interested in MMBE qty because if they go on allocating stock based on MMBE , they wont be able to get Sales Order created with confirmed qty.From report perspective, its all right.

      But when we need this information in custom reports or interfaces, it becomes a challenge.
      So, is there a table or a calculation available which can help us in arriving at CO09 figure?

      Thanks
      Shreshtha

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      As always it depends on the people who look at something, the warehouse  folks is interested in real hard numbers, they look at MMBE to see their physical current stock.
      A sales rep may look at CO09 to see what he can promise to the customer at a certain time
      and a production planner looks at MD04 to see the values relevant for them.
      And I just hope that none of those folks  does look or expect any paper report because then they have not understood the meaning of the tools and their shown numbers.
      Business is not static and does not only change once a day, it changes continuously during the working hours, you need online tools that show the right number right on time.

      Author's profile photo Ping Tong
      Ping Tong

      Nice point of view, business is dynamic.

      I got into this post when I'm searching for the question, in which tables the reserved stock numbers or available stock numbers are held for storage location and plant levels. It seems there is no such a number in table, but in memory of system - dynamically calculated by other data in database like stock and reservation records. Is that such a case?

      Thanks!

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      exact this is the case

      Author's profile photo MD MONIR HOSSAIN
      MD MONIR HOSSAIN

      thanks a lot dear

      Author's profile photo Catalin Mihalcea
      Catalin Mihalcea

      Hi Jurgen,

      What if you have unchecked the field “Include safety stock”  in the checking rule definition after you have added 50 pcs of safety stock? In this case how CO09 would look like?

      I’m asking this because I made some tests and I don’t see any difference in CO09 if I check or uncheck the field “Include safety stock” (in my expectation the available quantity should be diminished with the safety stock quantity when the field is unchecked).

      Are there any other settings in order to take the safety stock into consideration for availability check?

       

      Thank you very much for your answer,

      Catalin

      Author's profile photo Amitabh Bansal
      Amitabh Bansal

      Nice document with every required detail (in the original blog as well as in the answers to the questions).