Symptom
- CDS view or API that provides relationships: Product–Material, Batch–Batch Number, Storage Bin–Serial Number.
- Expected hierarchy: Product → Batch → Storage Bin → Serial Number.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
Not Relevant
Cause
Serial numbers are not exposed via the CDS view I_EWM_PHYSSTOCKPROD. They are only available through the remote API API_WHSE_PHYSSTOCKPROD.
Resolution
- To retrieve physical stock data (product, batch, storage bin, handling unit), use the C1-released CDS view I_EWM_PHYSSTOCKPROD or the remote API API_WHSE_PHYSSTOCKPROD.
- To also retrieve serial numbers, use the API Warehouse Physical Stock by Product – Read, Update (A2X), service API_WHSE_PHYSSTOCKPROD, via the navigation _SerialNumber of the entity WarehousePhysicalStockProducts (entity WhsePhysStockProdSerialNumber). The CDS view I_EWM_PHYSSTOCKPROD does not provide an association to serial numbers.
- When using the CDS view, the hierarchy Product → Batch → Storage Bin can be completed with:
- 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)
See Also
SAP Business Accelerator Hub – Warehouse Physical Stock by Product – Read, Update (A2X), versão SAP S/4HANA Cloud Public Edition: [URL]
Keywords
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
SAP Knowledge Base Article - Public