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.

To report this post you need to login first.

48 Comments

You must be Logged on to comment or reply to a post.

  1. Raju Prabhune

    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.

    (0) 
    1. 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.

      (0) 
      1. Jürgen L 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

        (0) 
  2. Sesha S B

    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.

    (0) 
  3. Jürgen L 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

    (0) 
  4. ANIL KUMAR GOLLAPUDI

    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 .

    (0) 
  5. Lakhya Pratim Baruah

    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

    (0) 
  6. Kumar Shreshtha

    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

    (0) 
    1. Jürgen L 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.

      (0) 

Leave a Reply