P_EWM_HandlingUnitItem02

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_HandlingUnitItem02.
-- 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_HandlingUnitItem02 AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  StockItemUUID,
  DeliveryCategory,
  DeliveryUUID,
  DeliveryItemUUID,
  _LogisticExecutionDelivery.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  _LogisticExecutionDelivery.ReferenceDocumentItemNumber AS ReferenceDocumentItemNumber,
  ProductUUID,
  _Product.Product AS Product,
  _Product._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  HandlingUnitQuantity,
  HandlingUnitBaseUnitOfMeasure,
  HandlingUnitAltUnitOfMeasure,
  BatchUUID,
  _Batch.Batch AS Batch,
  ShelfLifeExpirationDate,
  GoodsReceiptUTCDateTime,
  CountryOfOrigin,
  ParentHandlingUnitUUID,
  EntitledToDisposeParty,
  P_EWM_HandlingUnitItem01._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID
FROM P_EWM_HandlingUnitItem01
LEFT OUTER JOIN I_Product AS _Product ON ProductUUID = _Product.ProductUUID  -- association [1..1]
LEFT OUTER JOIN I_Batch AS _Batch ON BatchUUID = _Batch.BatchExtWhseMgmtInternalId  -- association [1..1]
LEFT OUTER JOIN P_EWM_HandlingUnitItemDlvRef01 AS _LogisticExecutionDelivery ON DeliveryUUID = _LogisticExecutionDelivery.DeliveryUUID AND DeliveryItemUUID = _LogisticExecutionDelivery.DeliveryItemUUID AND DeliveryCategory = _LogisticExecutionDelivery.DeliveryCategory  -- association [0..1]
;