3742457 - CDS View and API to Retrieve the Physical Stock which contains Batch Information and Serial Numbers in Public Cloud

• CDS view or API that provides relationships: Product–Material, Batch–Batch Number, Storage Bin–Serial Number.
• Expected hierarchy: Product → Batch → Storage Bin → Serial Number.

 SAP S/4HANA Cloud Public Edition

Not Relevant

1. Use the C1-released CDS view I_EWM_PHYSSTOCKPROD or the remote API API_WHSE_PHYSSTOCKPROD to retrieve physical stock data for the required product.
2. Include serial numbers by consuming the association to I_EWM_SERIALNUMBER from I_EWM_PHYSSTOCKPROD.
3. Leverage the view’s integrated sources to complete the hierarchy:

• Batch details via I_BatchDistinct.
• Product details via I_Product.
• Storage bin via I_EWM_StorageBin_2.
• Handling unit header via I_EWM_HandlingUnitHdr_2 (if needed for your scenario).

1. Build the required hierarchy Product → Batch → Storage Bin → Serial Number from the fields exposed by I_EWM_PHYSSTOCKPROD. This is the recommended option to derive the relationship when a single direct standard view is not available.

• refer to: CDS views documentation
• refer to: Community: Product storage CDS view or API
• refer to: Blog: Create CDS views in SAP S/4HANA Cloud and consume them as APIs

i_ewm_physstockprod, api_whse_physstockprod, cds view, ewm, physical stock, batch to storage bin, serial number, product batch hierarchy, i_ewm_serialnumber, i_batchdistinct, i_ewm_storagebin_2, i_product, warehouse management, s/4hana cloud public edition, storage bin linkage , KBA , SCM-EWM-WOP-2CL , Warehouse Order Processing (Public Cloud) , Problem