A_HandlingUnit

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_HandlingUnit.
-- 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.

CREATE VIEW A_HandlingUnit AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  PackagingMaterial,
  PackagingMaterialType,
  Plant,
  StorageLocation,
  ShippingPoint,
  ParentHandlingUnitNumber,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  cast( HandlingUnitLength as laeng ) AS HandlingUnitLength,
  cast( HandlingUnitWidth as breit ) AS HandlingUnitWidth,
  cast (HandlingUnitHeight as hoehe ) AS HandlingUnitHeight,
  UnitOfMeasureDimension,
  HandlingUnitReferenceDocument AS HandlingUnitPackingObjectKey,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  HandlingUnitProcessStatus,
  StorageType,
  StorageSection,
  StorageBin
FROM I_HandlingUnitHeaderCombined
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitExternalID = _Extension.HandlingUnitExternalID  -- association [0..1]
LEFT OUTER JOIN A_HandlingUnitItem AS _HandlingUnitItem ON /* condition not available in parsed metadata */  -- association [0..*]
;