Keep trace of any stock out situations

[former_member728727]

Hi,
Is there any kind of way to keep track of stock out? Let's say a breakdown occurs, and there are no spares in stock to be able to correct the breakdown. Is it possible with standard SAP MM/PM to record this? And even further, is it possible to keep this record connected to a specific Material Master?

The idea is to keep track if we have a breakdown in an motor let say, and we do not have it in stock, we want to understand that the reason for production stop-time was partly because of that we didn't had a spare motor in stock at the factory.

[Oscar_DC · Accepted solution]

That's a great question!

Here's the problem you will have with this and different ways to solve it

If you have a technician walk to the storeroom, not find what he needs and then just leave, SAP will have no record of the stock out situation.

If you reserve the material, your operations are up-to-date and you run the material availability check, then you will know that there was an order which had a shortage for a material. You can see all of the statuses for your orders and build a custom report for that if needed.

I've also seen folks try to create a custom tcode for this. Basically just a running list of a combination of material and Pm order operation for stock out instances.

I want to see what more folks say!

[former_member728727 · Accepted solution]

Hi!
Thank you for your input! It's a very interesting topic for sure. And maybe I don't see the details of the day-to-day work here but, if a breakdown occurs, then they have been no change to reserve or plan any stock movement, meaning it is an underlying spare part probabilities strategy of define what component do we need to stock and where

Let say for the sake of the scenario that we in normal cases have motor A in stock, 1PC just for safety stock, but somewhere along the day-to-day work, the material planning have failed in some way (could be human error, system error, supplier shortage etc.), we still have to understand that one of the causes to production stop was shortage of stock for that motor. Meaning we have to report in some way, that we couldn't correct the breakdown due to stock shortage..
maybe I'm talking in circles now, but just want to be clear with my issue..
Thank you!

[Oscar_DC · Accepted solution]

This makes perfect sense now. While I understand everybody's effort to give you alternatives to prevent a material shortage from happening or correct material shortage after it has been identified - I completely understand that a material shortage can have an impact on an equipment record and shut it down. All you're asking is for a way to track it !

Now - let's clarify a couple of things. When I mention "orders and operations" - I'm referring to a Plant Maintenance Order and a Plant Maintenance Operation - not a Production Order.

You might be processing a production order using a piece of equipment which suddenly breaks down. Assuming this issue is considered an emergency, your maintenance team would create a Maintenance Notification and a Plant Maintenance Order to fix the equipment which broke.

Your maintenance notification would include the equipment record which broke, when the malfunction started, which part broke, why it broke, which damage was done etc.

If your maintenance team finds the parts that they need to execute the maintenance job, then they would just issue those parts to the Plant Maintenance Order creating a goods issue.

If they don't find them, then they have to create a material reservation for the PM order to make sure that the parts will actually get ordered.

Depending on how you have the Material Availability Check configured, at the time in which your maintenance technicians save or release the maintenance order, your PM order will have a MATERIAL SHORTAGE MSPT status.

If you run the material availability check as a batch job every day, your PM order status will change to MAC - or something similar- when you have all of the material needed to process the plant maintenance order.

If you analyze the status history of your Plant Maintenance Orders you could know which PM orders, for which assets had a Material Shortage status and for how long.

All of this is easier said than done ... but that's a way to get it done.

Realistically - your PM process might not be mature enough to do this. For example: not all of your spare parts might have material numbers, you might not be using maintenance notifications and orders consistently, you might have a lot of backlog PM orders which doesn't allow the Material Availability Check to run correctly, not all of your equipment records are in Plant Maintenance, etc ..

This is why folks sometimes do not do this in the PM module ... and find other ways of documenting how shortages impacted production.

keep in mind - I've never used production planning ! I'm just an MM and PM guy.

Thanks

[pascal_bellerose2 · Accepted solution]

I was looking for a way to detect stockouts so we can track improvement of MRP efficiency and you really nailed it! I did think about that MSPT status at all and since the order's status history is stored in a table, we can access it and read the number of times MSPT status was applied to an order to get eh number of stockout occurences! Thanks Oscar_DC!