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:
and the same in the stock overview transaction MMBE
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
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.
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)
Let us enter a purchase order of 20 and see how the situation develops.
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?
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
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.
Hi,
thanks a lot
Some Clarity came regarding Unrestricted stock Nice 🙂 post
Very well explained !! Thanks for sharing.
Regards,
Hi Jurgen...
Nice document. Thanks for sharing and supporting...
Regards,
AKPT
Than you for sharing helpful document.
Srinu.
Hi Jurgen,
Thanks for sharing nice document.
Regards,
Subbu.
Hi,
Nice one...........Thank you..........
Nice one.
Thanks for sharing it.
Hello Jurgen,
Well explained with precise statements. Screenshots really helped 🙂 🙂
Thank you.
Thanks Jurgen,
you are the best...
Regards,
Uday K.
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.
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
Dramatic presentation! You should be Education ➕ 😀
Thank you all for the nice compliments.
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.
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
Hi,
Thanks for your response. I was not aware of that.
You have a good one.
Thanks.
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.
Hi all;
Thanks for sharing Mr.Jurgen related with MM/PP intgration and details.
Regards.
M.Ozgur Unal
very helpful
thanks for sharing..you are the great 🙂
Regards,
Hanmanth
Thanks for sharing, Jurgen.
Thanks for sharing....Very helpful
Very good Sir..Explained clearly about the Available stock functionality.
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
Precisely explained the difference between MD04 and CC09,Good
Hi Jurgen,
Thanks for sharing the document and knowledge. Expecting more....
thanks for sharing nice document
thanks for the nice explanation.
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
Now I am conviced too 🙂
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 .
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
Excellent piece of information
Thanks,
Asha
Hi Jurgen,
Nice explanation on a commonly (mis) understood concept.
Thanks
Rakesh
Hi Jurgen,
It's very useful document. Thanks for sharing.
Thanks & Regards,
Ramagiri
Thanks for the info
Hi Jurgen,
Nice document. Thanks for your knowledge sharing.
Regards,
Manikandan G
Thank you for sharing !!
Hi Jürgen L
Thanks for sharing your knowledge. Good document explained in simple way to understand.
Thanks & Regards,
Ramagiri
Hi Jurgen,
Very well documented. Thanks for sharing.
Cheers
ray
Hi Jurgen,
It is very nice and life time document. Thanks for sharing
Regards,
Umapathy
good, very inspiring.
Hi Jurgen,
Thanks for sharing the document.
Regards.
thank you for this very useful explanation.
Thank you Jurgen!!!! Very useful and helpful document
regards,
Sean
Thanks...looks like all these answer lies beyond MM alone.
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
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.
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!
exact this is the case
thanks a lot dear
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
Nice document with every required detail (in the original blog as well as in the answers to the questions).