cancel
Showing results for 
Search instead for 
Did you mean: 

Available Material SAP 4/HANA Public Cloud

AdamHorne
Explorer
0 Kudos
242

I want to see the quantity of material available after any commitments. I can do it in the stock overview app but its by single material.

What I would like is a table showing the material, stock on hand, commitments and then what is available.   

If not in a view is there a CDS table that would show it? If so what is the CDS name. 

 

AdamHorne_0-1742283792759.png

 

View Entire Topic
jagdeepsingh83
Active Contributor

@AdamHorne You can check Stock - Multiple Materials -- O data Service -MMIM_MULTIPLE_MATERIAL_SRV--I guess Data Model is F0_MMIM_MATSTOCKQUANVALBYDATE

Also it is worth using the API- on product availability -ProductAvailabilityDeterminationIn

@DominikTylczyn --MD04 does show available stock and also show the commitments --my first answer was based on the question that said available stock after commitment -_Screenshot for your reference.

jagdeepsingh83_0-1742447496231.png

 

 

DominikTylczyn
SAP Champion
SAP Champion

MMIM_MULTIPLE_MATERIAL_SRV shows stock of several materials, that is still not available stock according to ATP logic. However ProductAvailabilityDeterminationIn is very promising. That is a great tip!

MD04 doesn't show stock availability. CO09 does. Let me explain with a simple case:. Let's consider the following situation:

  • today, current stock 100 PC
  • today + 10 days, sales order, confirmed quantity 70 PC

What is the available stock at today + 5 days? If you look in MD04, it will be 100 PC. However, according to ATP logic, available stock at today + 5 days is 30 PC. That shows in CO09 and that would be the result of ATP check if a sales order is created for today + 5 days.