Available Material SAP 4/HANA Public Cloud

[AdamHorne]

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. 

[jagdeepsingh83]

@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.

[DominikTylczyn]

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.

[DominikTylczyn]

Hello @AdamHorne 

You can read material availability with the BAPI_MATERIAL_AVAILABILITY function. I think that the best you can get. The function reads ATP information for a single material only.

Best regards

Dominik Tylczynski

[jagdeepsingh83]

Check the Monitor Material Coverage Fiori App or MD04 (not sure if you can use this Public Cloud or not)-to see what you are looking for.

[AdamHorne]

Thank you - but ideally would like to get a report (if not a custom CDS) to see "available" stock

[DominikTylczyn]

MD04 doesn't show available stock!