CDS view Required - S4Hana Public Cloud MD04 - stock functionality (released)

[LaurensSteffers]

Hi all,

we would like to use the stock calculation of the MD04 in a separate application (side-by-side). We try to find some CDS views which are actually released and cover the functionality. We can find the actual stock variants (i_materialstock..., I_EWM_AVAILABLESTOCK etc) but we also need to take reservations into account. 

Any option or combination available (released!) which we can use to cover the md04 functionality in a CDS view (API would be ok as well). 

Kind regards

Laurens

Addition: Well, we had a look and see we still have issues. It looks like the API (supply/demand) is walking through the MD04 functionality (takes all receipts and issues into account), but we only want to have the CO09 functionality (receipts and issues which much be taken into account regarding the availability check).

[LaurensSteffers · Accepted solution]

Well, we checked with SAP directly and they came up with note: https://me.sap.com/notes/3333633

We discovered that this API does the trick: https://api.sap.com/api/API_PRODUCT_AVAILY_INFO_BASIC/overview

Specifically: 

sap/opu/odata/SAP/API_PRODUCT_AVAILY_INFO_BASIC/DetermineAvailabilityAt?SupplyingPlant='1010'&Material='00000000000000001'&ATPCheckingRule='A'&RequestedUTCDateTime=datetimeoffset'2024-05-17T17:00:00Z'

Hope this helps other people 🙂

So, next stop is to find the CDS view behind it #dontthinkso

[Corey]

Hi Laurens,

There is no CDS view available yet for this.
You may use this API alternatively . 
https://hub.sap.com/api/API_MRP_MATERIALS_SRV_01/resource/Supply_and_Demand
See also the online help.
https://help.sap.com/docs/SAP_S4HANA_CLOUD/d35113ee62644d3abee1aaec148291d9/40ca14cc187949798862ee56...

Best regards
Corey

[LaurensSteffers]

Thank you Corey, I'll have a look today at the API "results" on our system and see if it matches our expectations. Thanks again!

[LaurensSteffers]

Well, we had a look and see we still have issues. It looks like the API (supply/demand) is walking through the MD04 functionality (takes all receipts and issues into account), but we only want to have the CO09 functionality (receipts and issues which much be taken into account regarding the availability check). It looks like the availability check is not taken into account in the API.

[LaurensSteffers]

I added some more comments and images in the original question.