I_EWM_HandlingUnitHistory

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 I_EWM_HandlingUnitHistory.
-- 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.
-- SQL view name: IEWMHUHIST

CREATE VIEW I_EWM_HandlingUnitHistory AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  cast( WarehouseTask as /scdl/dl_docno_int ) AS ReferenceDocumentNumber,
  WarehouseTaskItem AS ReferenceDocumentItem,
  cast( WarehouseProcessCategory as /scwm/de_doccat ) AS ReferenceDocumentCategory,
  HandlingUnitUUID,
  EWMHandlingUnitExternalUUID,
  CreatedByUser AS ReferenceDocumentCreatedByUser,
  CreationUTCDateTime AS ReferenceDocCrtnUTCDateTime,
  LastChangedByUser AS ReferenceDocumentChangedByUser,
  ReferenceDocLastChgUTCDateTime
FROM P_EWM_HandlingUnitHistory04
-- UNION ALL with additional select branch(es): P_EWM_HandlingUnitHistory06
;