I_EWM_HandlingUnitHeaderC

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_HandlingUnitHeaderC.
-- 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: IEWMHUHDRC

CREATE VIEW I_EWM_HandlingUnitHeaderC AS
SELECT
  _SnapshotHandlingUnit.HandlingUnitExternalID AS HandlingUnitExternalID,
  _SnapshotHandlingUnit.Warehouse AS Warehouse,
  _SnapshotHandlingUnit.PackagingMaterial AS PackagingMaterial,
  _SnapshotHandlingUnit.PackagingMaterialType AS PackagingMaterialType,
  _SnapshotHandlingUnit.StorageType AS StorageType,
  _SnapshotHandlingUnit.HandlingUnitStatus AS HandlingUnitStatus,
  _SnapshotHandlingUnit.StorageSection AS StorageSection,
  _SnapshotHandlingUnit.StorageBin AS StorageBin,
  _SnapshotHandlingUnit.HandlingUnitType AS HandlingUnitType,
  _SnapshotHandlingUnit.GrossWeight AS GrossWeight,
  _SnapshotHandlingUnit.NetWeight AS NetWeight,
  _SnapshotHandlingUnit.HandlingUnitMaxWeight AS HandlingUnitMaxWeight,
  _SnapshotHandlingUnit.WeightUnit AS WeightUnit,
  _SnapshotHandlingUnit.HandlingUnitTareWeight AS HandlingUnitTareWeight,
  _SnapshotHandlingUnit.HandlingUnitTareWeightUnit AS HandlingUnitTareWeightUnit,
  _SnapshotHandlingUnit.GrossVolume AS GrossVolume,
  _SnapshotHandlingUnit.HandlingUnitNetVolume AS HandlingUnitNetVolume,
  _SnapshotHandlingUnit.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
  _SnapshotHandlingUnit.VolumeUnit AS VolumeUnit,
  _SnapshotHandlingUnit.HandlingUnitTareVolume AS HandlingUnitTareVolume,
  _SnapshotHandlingUnit.HandlingUnitVolumeTolerance AS HandlingUnitVolumeTolerance,
  _SnapshotHandlingUnit.HandlingUnitTareVolumeUnit AS HandlingUnitTareVolumeUnit,
  _SnapshotHandlingUnit.HandlingUnitLength AS HandlingUnitLength,
  _SnapshotHandlingUnit.HandlingUnitWidth AS HandlingUnitWidth,
  _SnapshotHandlingUnit.HandlingUnitHeight AS HandlingUnitHeight,
  _SnapshotHandlingUnit.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  _SnapshotHandlingUnit.HandlingUnitMaxLength AS HandlingUnitMaxLength,
  _SnapshotHandlingUnit.HandlingUnitMaxWidth AS HandlingUnitMaxWidth,
  _SnapshotHandlingUnit.HandlingUnitMaxHeight AS HandlingUnitMaxHeight,
  _SnapshotHandlingUnit.HandlingUnitMaxDimensionUnit AS HandlingUnitMaxDimensionUnit,
  _SnapshotHandlingUnit.ReferenceDocumentNumber AS ReferenceDocumentNumber,
  _SnapshotHandlingUnit.CreatedByUser AS CreatedByUser,
  _SnapshotHandlingUnit.CreationUTCDateTime AS CreationUTCDateTime,
  _SnapshotHandlingUnit.LastChangedByUser AS LastChangedByUser,
  cast( _SnapshotHandlingUnit.LastChangeUTCDateTime as tzntstmps preserving type ) AS LastChangeUTCDateTime,
  _SnapshotHandlingUnit.ParentHandlingUnitNumber AS ParentHandlingUnitNumber,
  HandlingUnitUUID
FROM P_EWM_HandlingUnitHeader05 AS _HandlingUnitUnion
LEFT OUTER JOIN P_EWM_HandlingUnitHeaderLog04 AS _SnapshotHandlingUnit ON _HandlingUnitUnion.HandlingUnitExternalID = _SnapshotHandlingUnit.HandlingUnitExternalID AND _HandlingUnitUnion.Warehouse = _SnapshotHandlingUnit.Warehouse  -- association [0..1]
-- UNION ALL with additional select branch(es): P_EWM_HandlingUnitHeader02
;