I_PackingInstructionHeader

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_PackingInstructionHeader.
-- 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: IPACKINSTRHEADER

CREATE VIEW I_PackingInstructionHeader AS
SELECT
  packnr AS PackingInstructionSystemUUID,
  pobjid AS PackingInstructionNumber,
  partid AS PackingInstructionExternalName,
  height AS HandlingUnitHeight,
  width AS HandlingUnitWidth,
  length AS HandlingUnitLength,
  iheight AS HandlingUnitInnerHeight,
  iwidth AS HandlingUnitInnerWidth,
  ilength AS HandlingUnitInnerLength,
  unitdim AS HandlingUnitUoMDimension,
  sizefix AS HandlingUnitMeasuresAreFixed,
  totlvol AS HandlingUnitGrossVolume,
  loadvol AS HandlingUnitLoadVolume,
  allovol AS HandlingUnitAllowedLoadVolume,
  unitvol_max AS HandlingUnitVolumeUnit,
  tarevol AS HandlingUnitTareVolume,
  unitvol AS HandlingUnitTareVolumeUnit,
  volumfix AS HandlingUnitVolumesAreFixed,
  tolevol AS ExcessVolumeToleranceValue,
  totlwei AS HandlingUnitGrossWeight,
  loadwei AS HandlingUnitLoadWeight,
  allowei AS HandlingUnitAllowedLoadWeight,
  unitwei_max AS HandlingUnitWeightUnit,
  tarewei AS HandlingUnitTareWeight,
  unitwei AS HandlingUnitTareWeightUnit,
  weightfix AS HandlingUnitWeightsAreFixed,
  tolewei AS ExcessWeightToleranceValue,
  maxstwe AS PackingInstructionAllwdLoadQty,
  indclopa AS HandlingUnitIsClosed,
  cast( mapaco_item as packing_instruction_component preserving type ) AS LoadCarrierSystUUID,
  inddel AS PackingInstructionIsDeleted,
  checkprof AS PackingInstructionCheckProfSts,
  stfac AS StackingFactor,
  hu_type AS HandlingUnitType,
  crnam AS CreatedByUser,
  crdat AS CreationDate,
  chnam AS LastChangedByUser,
  chdat AS LastChangeDate,
  chtim AS LastChangeTime,
  lastchangeddatetime AS LastChangeDateTime
FROM packkp
LEFT OUTER JOIN I_PackingInstructionComponent AS _PackingInstructionComponent ON PackingInstructionSystemUUID = _PackingInstructionComponent.PackingInstructionSystemUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureDimension ON _UnitOfMeasureDimension.UnitOfMeasure = HandlingUnitUoMDimension  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HandlingUnitVolumeUnit ON _HandlingUnitVolumeUnit.UnitOfMeasure = HandlingUnitVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HandlingUnitTareVolumeUnit ON _HandlingUnitTareVolumeUnit.UnitOfMeasure = HandlingUnitTareVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HandlingUnitWeightUnit ON _HandlingUnitWeightUnit.UnitOfMeasure = HandlingUnitWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HandlingUnitTareWeightUnit ON _HandlingUnitTareWeightUnit.UnitOfMeasure = HandlingUnitWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_PackingInstructionText AS _Text ON PackingInstructionSystemUUID = _Text.PackingInstructionSystemUUID  -- association [0..*]
;