P_EWM_HandlingUnitHeaderLog02

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_HandlingUnitHeaderLog02.
-- 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: PEWMHUHDRLOG02

CREATE VIEW P_EWM_HandlingUnitHeaderLog02 AS
SELECT
  _gmHuHdr.HandlingUnitExternalID AS HandlingUnitExternalID,
  _gmHuHdr.Warehouse AS Warehouse,
  _gmHuHdr.HandlingUnitType AS HandlingUnitType,
  _gmHuHdr.PackagingMaterialUUID AS PackagingMaterialUUID,
  _gmHuHdr.PackagingMaterialType AS PackagingMaterialType,
  _gmHuHdr.HandlingUnitStatus AS HandlingUnitStatus,
  _gmHuHdr.StorageType AS StorageType,
  _gmHuHdr.StorageSection AS StorageSection,
  _gmHuHdr.StorageBin AS StorageBin,
  _gmHuHdr.HandlingUnitMaxWeight AS HandlingUnitMaxWeight,
  _gmHuHdr.GrossWeight AS GrossWeight,
  _gmHuHdr.NetWeight AS NetWeight,
  _gmHuHdr.WeightUnit AS WeightUnit,
  _gmHuHdr.HandlingUnitTareWeight AS HandlingUnitTareWeight,
  _gmHuHdr.HandlingUnitTareWeightUnit AS HandlingUnitTareWeightUnit,
  _gmHuHdr.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
  _gmHuHdr.GrossVolume AS GrossVolume,
  _gmHuHdr.HandlingUnitNetVolume AS HandlingUnitNetVolume,
  _gmHuHdr.HandlingUnitVolumeTolerance AS HandlingUnitVolumeTolerance,
  _gmHuHdr.VolumeUnit AS VolumeUnit,
  _gmHuHdr.HandlingUnitTareVolume AS HandlingUnitTareVolume,
  _gmHuHdr.HandlingUnitTareVolumeUnit AS HandlingUnitTareVolumeUnit,
  _gmHuHdr.HandlingUnitLength AS HandlingUnitLength,
  _gmHuHdr.HandlingUnitWidth AS HandlingUnitWidth,
  _gmHuHdr.HandlingUnitHeight AS HandlingUnitHeight,
  _gmHuHdr.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  _gmHuHdr.HandlingUnitMaxLength AS HandlingUnitMaxLength,
  _gmHuHdr.HandlingUnitMaxWidth AS HandlingUnitMaxWidth,
  _gmHuHdr.HandlingUnitMaxHeight AS HandlingUnitMaxHeight,
  _gmHuHdr.HandlingUnitMaxDimensionUnit AS HandlingUnitMaxDimensionUnit,
  _gmHuHdr.HandlingUnitUUID AS HandlingUnitUUID,
  _gmHuHdr.ParentHandlingUnitUUID AS ParentHandlingUnitUUID,
  _gmHuHdr.CreatedByUser AS CreatedByUser,
  _gmHuHdr.CreationUTCDateTime AS CreationUTCDateTime,
  _gmHuHdr.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  _gmHuHdr.LastChangedByUser AS LastChangedByUser,
  _gmHuHdr.HandlingUnitTopLevelInd AS HandlingUnitTopLevelInd,
  _gmHuHdr.HandlingUnitLogUUID AS HandlingUnitLogUUID
FROM P_EWM_HandlingUnitHeaderLog01 AS _LatestSnapshot
INNER JOIN I_EWM_HandlingUnitHeaderLog AS _gmHuHdr ON /* join condition not captured in parsed metadata */
;