I_HandlingUnitHeaderCombined

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_HandlingUnitHeaderCombined.
-- 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_HandlingUnitHeaderCombined AS
SELECT
  HandlingUnitExternalID,
  cast(' ' as /scwm/lgnum preserving type) AS Warehouse,
  HandlingUnitCharUUID,
  HandlingUnitCharUUID AS HandlingUnitInternalCharUUID,
  HandlingUnitExternalIdType,
  Plant,
  StorageLocation,
  ShippingPoint,
  HandlingUnitInternalID,
  HandlingUnitLowerLevelRefer,
  _HandlingUnitParentHdr.HandlingUnitExternalID AS ParentHandlingUnitNumber,
  cast( ' ' as exidv preserving type ) AS HighestLevelHandlingUnitNumber,
  PackagingMaterial,
  PackagingMaterialType,
  PackingInstruction,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  WeightUnitISOCode,
  WeightUnitSAPCode,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  HndlgUnitTareWeightUnitISOCode,
  HndlgUnitTareWeightUnitSAPCode,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  VolumeUnitISOCode,
  VolumeUnitSAPCode,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HndlgUnitTareVolumeUnitISOCode,
  HndlgUnitTareVolumeUnitSAPCode,
  cast( HandlingUnitLength as abap.quan( 15, 3 ) ) AS HandlingUnitLength,
  cast( HandlingUnitWidth as abap.quan( 15, 3 ) ) AS HandlingUnitWidth,
  cast( HandlingUnitHeight as abap.quan( 15, 3 ) ) AS HandlingUnitHeight,
  UnitOfMeasureDimension,
  UnitOfMeasureDimensionISOCode,
  UnitOfMeasureDimensionSAPCode,
  HandlingUnitPackingObjectType,
  cast( HandlingUnitPackingObjectKey as char20 preserving type ) AS HandlingUnitReferenceDocument,
  cast( '' as abap_boolean preserving type ) AS HandlingUnitHasCrossRefDoc,
  CreatedByUser,
  dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client, 'NULL'), $session.client, 'NULL' ) as CreationDateTime AS clientNULLasCreationDateTime,
  case when LastChangeDate is initial then dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client, 'NULL'), $session.client, 'NULL' ) else dats_tims_to_tstmp( LastChangeDate, LastChangeTime, abap_system_timezone( $session.client, 'NULL'), $session.client, 'NULL' ) end as LastChangeDateTime AS clientNULLendasLastChangeDateTime,
  HandlingUnitInternalStatus,
  SourceHandlingUnitUUID,
  HandlingUnitSecondExternalId,
  HandlingUnitSlotNumber,
  HandlingUnitWeightVolumeIsFix,
  HndlgUnitRlvnceForJIT,
  cast(' ' as /scwm/lgtyp preserving type) AS StorageType,
  cast(' ' as /scwm/lgber preserving type) AS StorageSection,
  cast(' ' as /scwm/lgpla preserving type) AS StorageBin,
  cast(' ' as /scwm/de_rsrc preserving type ) AS EWMResource,
  cast(' ' as /scwm/de_dstgrp preserving type) AS EWMConsolidationGroup,
  cast('' as /scwm/de_closed_pm preserving type ) AS HandlingUnitIsClosed,
  cast(' ' as /scwm/de_hutyp preserving type) AS HandlingUnitType,
  cast(' ' as /scwm/de_procs preserving type ) AS ExternalStorageProcessStep,
  cast('' as /scwm/de_copst preserving type ) AS EWMHUProcessStepIsCompleted,
  cast(' ' as /scwm/de_prces preserving type ) AS StorageProcess,
  cast('' as ewm_de_hu_is_planned preserving type ) AS EWMHandlingUnitIsPlanned,
  cast('' as ewm_de_hu_is_in_stock preserving type ) AS EWMHandlingUnitIsInStock,
  cast('' as ewm_de_hu_is_unloaded preserving type ) AS EWMHandlingUnitIsUnloaded,
  cast('' as ewm_de_hu_is_loaded preserving type ) AS EWMHandlingUnitIsLoaded,
  cast('' as ewm_de_hu_is_assigned_to_tu preserving type ) AS EWMTranspUnitIsAssigned,
  cast('' as ewm_de_hu_is_cntnt_change_blck preserving type ) AS EWMHUContentChangeIsBlocked,
  cast('' as ewm_de_hu_is_movement_blocked preserving type ) AS EWMHUMovementChangeIsBlocked,
  cast('' as ewm_de_hu_is_attrbt_chng_blck preserving type ) AS EWMHUAttributeChangeIsBlocked,
  cast('' as ewm_de_hu_is_posting_chng_blck preserving type ) AS EWMHUPostingChangeIsBlocked,
  cast('' as ewm_de_hu_is_blckd_by_customs preserving type ) AS EWMHUIsBlockedByCustoms,
  cast('' as ewm_de_hu_is_packed_for_ship preserving type ) AS EWMHUIsPackedForShipping,
  cast( 0 as /scwm/de_maxl) AS HandlingUnitMaxLength,
  cast(0 as /scwm/de_maxb) AS HandlingUnitMaxWidth,
  cast(0 as /scwm/de_maxh) AS HandlingUnitMaxHeight,
  cast(' ' as /scwm/de_maxdim_uom) AS HandlingUnitMaxDimensionUnit,
  cast('ERP' as lo_hu_hu_origin preserving type) AS HandlingUnitOrigin,
  cast( ' ' as ewm_de_serialnumber preserving type ) AS EWMSrlNmbrForPackagingMaterial,
  cast( ' ' as /scwm/de_jit_upd_relevance preserving type ) AS EWMHUIsJITUpdateRelevant,
  cast( ' ' as /scwm/de_hu_dest_psa preserving type ) AS EWMHUDestinationProdnSupArea,
  cast( ' ' as /scwm/de_hu_dest_lgpla preserving type ) AS EWMHUDestinationStorageBin
FROM I_HandlingUnitHeader AS vekp
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON _WeightUnit.UnitOfMeasure = vekp.WeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitTare ON _WeightUnitTare.UnitOfMeasure = vekp.HandlingUnitTareWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON _VolumeUnit.UnitOfMeasure = vekp.VolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnitTare ON _VolumeUnitTare.UnitOfMeasure = vekp.HandlingUnitTareVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureDimension ON _UnitOfMeasureDimension.UnitOfMeasure = vekp.UnitOfMeasureDimension  -- association [0..1]
LEFT OUTER JOIN I_HandlingUnitHeader AS _HandlingUnitParentHdr ON _HandlingUnitParentHdr.HandlingUnitInternalID = vekp.HandlingUnitLowerLevelRefer  -- association [0..1]
-- UNION ALL with additional select branch(es): I_HandlingUnitHeader, I_HandlingUnitHeader
;