P_EWM_HandlingUnitHeaderLog04

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_HandlingUnitHeaderLog04.
-- 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: PEWMHUHDRLOG04

CREATE VIEW P_EWM_HandlingUnitHeaderLog04 AS
SELECT
  _HeaderLog.HandlingUnitExternalID AS HandlingUnitExternalID,
  _HeaderLog.Warehouse AS Warehouse,
  _HeaderLog.HandlingUnitType AS HandlingUnitType,
  _HeaderLog.PackagingMaterialUUID AS PackagingMaterialUUID,
  _PackagingMaterial.Product AS PackagingMaterial,
  _HeaderLog.PackagingMaterialType AS PackagingMaterialType,
  _HeaderLog.HandlingUnitStatus AS HandlingUnitStatus,
  _HeaderLog.StorageType AS StorageType,
  _HeaderLog.StorageSection AS StorageSection,
  _HeaderLog.StorageBin AS StorageBin,
  _HeaderLog.HandlingUnitMaxWeight AS HandlingUnitMaxWeight,
  _HeaderLog.GrossWeight AS GrossWeight,
  _HeaderLog.NetWeight AS NetWeight,
  _HeaderLog.WeightUnit AS WeightUnit,
  _HeaderLog.HandlingUnitTareWeight AS HandlingUnitTareWeight,
  _HeaderLog.HandlingUnitTareWeightUnit AS HandlingUnitTareWeightUnit,
  _HeaderLog.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
  _HeaderLog.GrossVolume AS GrossVolume,
  _HeaderLog.HandlingUnitNetVolume AS HandlingUnitNetVolume,
  _HeaderLog.HandlingUnitVolumeTolerance AS HandlingUnitVolumeTolerance,
  _HeaderLog.VolumeUnit AS VolumeUnit,
  _HeaderLog.HandlingUnitTareVolume AS HandlingUnitTareVolume,
  _HeaderLog.HandlingUnitTareVolumeUnit AS HandlingUnitTareVolumeUnit,
  _HeaderLog.HandlingUnitLength AS HandlingUnitLength,
  _HeaderLog.HandlingUnitWidth AS HandlingUnitWidth,
  _HeaderLog.HandlingUnitHeight AS HandlingUnitHeight,
  _HeaderLog.UnitOfMeasureDimension AS UnitOfMeasureDimension,
  _HeaderLog.HandlingUnitMaxLength AS HandlingUnitMaxLength,
  _HeaderLog.HandlingUnitMaxWidth AS HandlingUnitMaxWidth,
  _HeaderLog.HandlingUnitMaxHeight AS HandlingUnitMaxHeight,
  _HeaderLog.HandlingUnitMaxDimensionUnit AS HandlingUnitMaxDimensionUnit,
  _HeaderLog.HandlingUnitUUID AS HandlingUnitUUID,
  _HeaderLog.ParentHandlingUnitUUID AS ParentHandlingUnitUUID,
  _ParentHandlingUnit.HandlingUnitExternalID AS ParentHandlingUnitNumber,
  _HeaderLog.CreatedByUser AS CreatedByUser,
  _HeaderLog.CreationUTCDateTime AS CreationUTCDateTime,
  _HeaderLog.LastChangedByUser AS LastChangedByUser,
  _HeaderLog.HandlingUnitTopLevelInd AS HandlingUnitTopLevelInd,
  _HeaderLog.HandlingUnitLogUUID AS HandlingUnitLogUUID,
  _HeaderLog.DeliveryUUID AS DeliveryUUID,
  _ReferenceDocument.ReferenceDocumentNumber AS ReferenceDocumentNumber
FROM P_EWM_HandlingUnitHeaderLog03 AS _HeaderLog
LEFT OUTER JOIN P_EWM_HandlingUnitHeadDlvRef01 AS _ReferenceDocument ON DeliveryUUID = _ReferenceDocument.DeliveryUUID  -- association [1..1]
LEFT OUTER JOIN I_Product AS _PackagingMaterial ON PackagingMaterialUUID = _PackagingMaterial.ProductUUID  -- association [1..1]
LEFT OUTER JOIN P_EWM_HandlingUnitHeaderLog02 AS _ParentHandlingUnit ON _HeaderLog.ParentHandlingUnitUUID = _ParentHandlingUnit.HandlingUnitUUID AND _HeaderLog.HandlingUnitTopLevelInd <> 'X'  -- association [0..1]
;