SAP Knowledge Base Article - Public

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

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

 

  1. 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.
  2. 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.
  3. 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

Product

SAP S/4HANA Cloud Public Edition all versions