I_HandlingUnitHeader

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 I_HandlingUnitHeader.
-- 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 I_HandlingUnitHeader AS
SELECT
  venum AS HandlingUnitInternalID,
  exidv AS HandlingUnitExternalID,
  exida AS HandlingUnitExternalIdType,
  vstel AS ShippingPoint,
  lstel AS LoadingPoint,
  vhilm AS PackagingMaterial,
  werks AS Plant,
  pstyv AS SalesDocumentItemCategory,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  lgort AS StorageLocation,
  lgnum AS Warehouse,
  brgew AS GrossWeight,
  ntgew AS NetWeight,
  magew AS HandlingUnitMaxWeight,
  gewei_max AS WeightUnit,
  tarag AS HandlingUnitTareWeight,
  gewei AS HandlingUnitTareWeightUnit,
  gewto AS HandlingUnitWeightTolerance,
  btvol AS GrossVolume,
  ntvol AS HandlingUnitNetVolume,
  mavol AS HandlingUnitMaxVolume,
  voleh_max AS VolumeUnit,
  tavol AS HandlingUnitTareVolume,
  voleh AS HandlingUnitTareVolumeUnit,
  volto AS HandlingUnitVolumeTolerance,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  eruhr AS CreationTime,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  aezet AS LastChangeTime,
  vegr1 AS HandlingUnitGroup1,
  vegr2 AS HandlingUnitGroup2,
  vegr3 AS HandlingUnitGroup3,
  vegr4 AS HandlingUnitGroup4,
  vegr5 AS HandlingUnitGroup5,
  laeng AS HandlingUnitLength,
  breit AS HandlingUnitWidth,
  hoehe AS HandlingUnitHeight,
  meabm AS UnitOfMeasureDimension,
  meins AS HandlingUnitBaseUnitOfMeasure,
  vbeln_gen AS HandlingUnitDeliveryWithPkgItm,
  posnr_gen AS HandlingUnitGenDeliveryItem,
  inhalt AS HandlingUnitContentDescription,
  vhart AS PackagingMaterialType,
  magrv AS PackagingMaterialGroup,
  gewfx AS HandlingUnitWeightVolumeIsFix,
  veltp AS PackagingMaterialCategory,
  exidv2 AS HandlingUnitSecondExternalId,
  vhilm_ku AS HandlingUnitCustomerPackMat,
  _ERPHandlingUnitReferenceDoc.HandlingUnitRefDocType AS HandlingUnitPackingObjectType,
  _ERPHandlingUnitReferenceDoc.HandlingUnitReferenceDocument AS HandlingUnitPackingObjectKey,
  handle AS SourceHandlingUnitUUID,
  kzgvh AS HandlingUnitIsClosed,
  adge_dg AS HazardousSubstanceIndicator,
  uevel AS HandlingUnitLowerLevelRefer,
  status AS HandlingUnitInternalStatus,
  cast( packvorschr as pl_packnr preserving type ) AS PackingInstruction,
  packvorschr_st AS PackingInstructionStatus,
  labeltyp AS PackInstructExtLabelNotPrinted,
  zul_aufl AS PackingInstructMaxLoadQuantity,
  erlkz AS HandlingUnitIsComplete,
  hu_system AS HandlingUnitStockMgmtType,
  slot_num AS HandlingUnitSlotNumber,
  supplyarea AS ProductionSupplyArea,
  jit_relevant_ind AS HndlgUnitRlvnceForJIT
FROM vekp AS HandlingUnitHeader
LEFT OUTER JOIN I_HandlingUnitItem AS _Item ON HandlingUnitInternalID = _Item.HandlingUnitInternalID  -- association [0..*]
LEFT OUTER JOIN I_ERPHandlingUnitReferenceDoc AS _ERPHandlingUnitReferenceDoc ON HandlingUnitInternalID = _ERPHandlingUnitReferenceDoc.HandlingUnitInternalID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON _WeightUnit.UnitOfMeasure = WeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitTare ON _WeightUnitTare.UnitOfMeasure = HandlingUnitTareWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON _VolumeUnit.UnitOfMeasure = VolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnitTare ON _VolumeUnitTare.UnitOfMeasure = HandlingUnitTareVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureDimension ON _UnitOfMeasureDimension.UnitOfMeasure = UnitOfMeasureDimension  -- association [0..1]
LEFT OUTER JOIN I_Material AS _PackagingMaterial ON _PackagingMaterial.Material = PackagingMaterial AND ( _PackagingMaterial.MaterialType = 'VERP' OR _PackagingMaterial.MaterialType = 'LEIH' )  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON _ShippingPoint.ShippingPoint = ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_LoadingPoint AS _LoadingPoint ON _LoadingPoint.ShippingPoint = ShippingPoint AND LoadingPoint = _LoadingPoint.LoadingPoint  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransportType AS _PackagingMaterialType ON _PackagingMaterialType.MeansOfTransportType = PackagingMaterialType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupPackMaterials AS _PackagingMaterialGroup ON _PackagingMaterialGroup.MaterialGroup = PackagingMaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _SalesDocumentItemCategory ON SalesDocumentItemCategory = _SalesDocumentItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitPackMatCategory AS _PackagingMaterialCategory ON PackagingMaterialCategory = _PackagingMaterialCategory.PackagingMaterialCategory  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitPackObjectType AS _PackingObjectType ON HandlingUnitPackingObjectType = _PackingObjectType.HandlingUnitPackingObjectType  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitHistory AS _HandlingUnitHistory ON _HandlingUnitHistory.SourceHandlingUnitUUID = SourceHandlingUnitUUID  -- association [0..*]
;