R_HandlingUnitTP

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 R_HandlingUnitTP.
-- 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 R_HandlingUnitTP AS
SELECT
  HandlingUnitExternalID,
  Warehouse,
  cast(HandlingUnitCharUUID as char32) AS HandlingUnitCharUUID,
  HandlingUnitExternalIdType,
  cast( '' as lohum_hu_extid_check_disabled preserving type ) AS HndlgUnitExtIDCheckIsDisabled,
  Plant,
  StorageLocation,
  ShippingPoint,
  HandlingUnitInternalID,
  HandlingUnitLowerLevelRefer,
  ParentHandlingUnitNumber,
  HighestLevelHandlingUnitNumber,
  PackagingMaterial,
  PackagingMaterialType,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  WeightUnitISOCode,
  WeightUnitSAPCode,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  HndlgUnitTareWeightUnitISOCode,
  HndlgUnitTareWeightUnitSAPCode,
  GrossVolume,
  HandlingUnitNetVolume,
  HandlingUnitMaxVolume,
  VolumeUnit,
  VolumeUnitISOCode,
  VolumeUnitSAPCode,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HndlgUnitTareVolumeUnitISOCode,
  HndlgUnitTareVolumeUnitSAPCode,
  cast( HandlingUnitLength as laeng ) AS HandlingUnitLength,
  cast( HandlingUnitWidth as breit ) AS HandlingUnitWidth,
  cast (HandlingUnitHeight as hoehe ) AS HandlingUnitHeight,
  UnitOfMeasureDimension,
  UnitOfMeasureDimensionISOCode,
  UnitOfMeasureDimensionSAPCode,
  HandlingUnitPackingObjectType,
  ltrim( HandlingUnitReferenceDocument, '0' ) AS HandlingUnitReferenceDocument,
  HandlingUnitHasCrossRefDoc,
  CreatedByUser,
  cast( CreationDateTime as tzntstmps) AS CreationDateTime,
  LastChangedByUser,
  cast( LastChangeDateTime as tzntstmps) AS LastChangeDateTime,
  HandlingUnitInternalStatus,
  HandlingUnitProcessStatus,
  SourceHandlingUnitUUID,
  PackingInstruction,
  HandlingUnitSecondExternalId,
  HandlingUnitSlotNumber,
  HandlingUnitWeightVolumeIsFix,
  HndlgUnitRlvnceForJIT,
  StorageType,
  StorageSection,
  StorageBin,
  EWMResource,
  EWMConsolidationGroup,
  HandlingUnitIsClosed,
  ExternalStorageProcessStep,
  StorageProcess,
  EWMHUProcessStepIsCompleted,
  EWMHandlingUnitIsPlanned,
  EWMHandlingUnitIsInStock,
  EWMHandlingUnitIsUnloaded,
  EWMHandlingUnitIsLoaded,
  EWMTranspUnitIsAssigned,
  EWMHUContentChangeIsBlocked,
  EWMHUMovementChangeIsBlocked,
  EWMHUAttributeChangeIsBlocked,
  EWMHUPostingChangeIsBlocked,
  EWMHUIsBlockedByCustoms,
  EWMHUIsPackedForShipping,
  HandlingUnitType AS EWMHandlingUnitType,
  EWMSrlNmbrForPackagingMaterial,
  HandlingUnitMaxLength,
  HandlingUnitMaxWidth,
  HandlingUnitMaxHeight,
  HandlingUnitMaxDimensionUnit,
  EWMHUIsJITUpdateRelevant,
  EWMHUDestinationProdnSupArea,
  EWMHUDestinationStorageBin
FROM I_HandlingUnitHeaderCombined
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitExternalID = _Extension.HandlingUnitExternalID  -- association [0..1]
LEFT OUTER JOIN R_HandlingUnitItemTP AS _HandlingUnitItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_HandlingUnitReferenceDocTP AS _HandlingUnitReferenceDoc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_HandlingUnitAlternativeIdTP AS _HandlingUnitAlternativeID ON /* condition not available in parsed metadata */  -- association [0..*]
;