A_HndlgUnitHdrForInbDeliv

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_HndlgUnitHdrForInbDeliv.
-- 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: AHUHDRINBDLV

CREATE VIEW A_HndlgUnitHdrForInbDeliv 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_InbDeliveryHeader_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_HndlgUnitItemForInbDeliv AS _HandlingUnitItem ON /* condition not available in parsed metadata */  -- association [0..*]
;