A_HandlingUnitHeaderDelivery

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 A_HandlingUnitHeaderDelivery.
-- 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: AHUHDRDLV

CREATE VIEW A_HandlingUnitHeaderDelivery AS
SELECT
  HandlingUnitInternalID,
  HandlingUnitExternalID,
  HandlingUnitExternalIdType,
  PackagingMaterial,
  Warehouse,
  ShippingPoint,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangedByUser,
  HandlingUnitGroup1,
  HandlingUnitGroup2,
  HandlingUnitGroup3,
  HandlingUnitGroup4,
  HandlingUnitGroup5,
  HandlingUnitLength,
  HandlingUnitWidth,
  HandlingUnitHeight,
  UnitOfMeasureDimension AS HandlingUnitUoMDimension,
  HandlingUnitBaseUnitOfMeasure,
  HandlingUnitContentDescription,
  PackagingMaterialType,
  PackagingMaterialGroup,
  PackagingMaterialCategory,
  HandlingUnitSecondExternalId,
  HandlingUnitLowerLevelRefer,
  HandlingUnitInternalStatus,
  PackingInstruction,
  _PackingInstructionHeader.PackingInstructionNumber AS PackingInstructionNumber,
  cast(HandlingUnitPackingObjectKey as vbeln) AS DeliveryDocument
FROM I_HandlingUnitHeader
LEFT OUTER JOIN A_OutbDeliveryHeader_1 AS _DeliveryDocumentHeader ON DeliveryDocument = _DeliveryDocumentHeader.DeliveryDocument  -- association [1..1]
LEFT OUTER JOIN I_PackingInstructionHeader AS _PackingInstructionHeader ON PackingInstruction = _PackingInstructionHeader.PackingInstructionSystemUUID  -- association [0..1]
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitExternalID = _Extension.HandlingUnitExternalID  -- association [0..1]
LEFT OUTER JOIN A_HandlingUnitItemDelivery AS _HandlingUnitItem ON /* condition not available in parsed metadata */  -- association [0..*]
;