P_EWM_HandlingUnitItem05

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_EWM_HandlingUnitItem05.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_EWM_HandlingUnitItem05 AS
SELECT
  EWMWarehouse,
  HandlingUnitNumber,
  StockItemUUID,
  CurrentNumberOfKeyTable,
  EWMStockType,
  EWMAvailabilityGroup,
  EWMLocIndepStockType,
  StockType,
  DeliveryCategory,
  EWMDocumentCategory,
  DeliveryUUID,
  EWMRefDeliveryDocumentNumber,
  DeliveryItemUUID,
  EWMRefDeliveryDocumentItem,
  ProductUUID,
  Product,
  ProductName,
  BatchUUID,
  Batch,
  EntitledToDisposeParty,
  EWMStockOwner,
  BusinessPartnerUUID,
  Supplier,
  Plant,
  _PlantMapping.StorageLocation AS StorageLocation,
  LogicalSystem,
  HandlingUnitQuantity,
  HandlingUnitBaseUnitOfMeasure,
  HandlingUnitAltUnitOfMeasure,
  ShelfLifeExpirationDate,
  GoodsReceiptUTCDateTime,
  CountryOfOrigin,
  _CountSerialNo.HandlingUnitNumberOfSerialNumb AS HandlingUnitNumberOfSerialNumb,
  SerialNumberProfile,
  ParentHandlingUnitUUID
FROM P_EWM_HandlingUnitItem04_2
LEFT OUTER JOIN I_EWM_PlantStorLocMapToWhse AS _PlantMapping ON EWMWarehouse = _PlantMapping.EWMWarehouse AND Plant = _PlantMapping.Plant AND LogicalSystem = _PlantMapping.ERPLogicalSystem AND EWMAvailabilityGroup = _PlantMapping.EWMAvailabilityGroup  -- association [1..1]
LEFT OUTER JOIN P_EWM_HandlingUnitItemSrlNo02 AS _CountSerialNo ON ParentHandlingUnitUUID = _CountSerialNo.ParentHandlingUnitUUID AND StockItemUUID = _CountSerialNo.StockItemUUID  -- association [1..1]
;