I_HandlingUnitValueHelp

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_HandlingUnitValueHelp.
-- 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_HandlingUnitValueHelp AS
SELECT
  ERPHeader.HandlingUnitExternalID AS HandlingUnitExternalID,
  cast(' ' as /scwm/lgnum) AS Warehouse,
  Plant,
  cast(' ' as vstel) AS ShippingPoint
FROM I_HandlingUnitHeader AS ERPHeader
LEFT OUTER JOIN I_HandlingUnitHeader AS _HandlingUnitParentHdr ON _HandlingUnitParentHdr.HandlingUnitInternalID = vekp_decwhs.HandlingUnitLowerLevelRefer  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON _WeightUnit.UnitOfMeasure = vekp_ewm.WeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnitTare ON _WeightUnitTare.UnitOfMeasure = vekp_ewm.HandlingUnitTareWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON _VolumeUnit.UnitOfMeasure = vekp_ewm.VolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnitTare ON _VolumeUnitTare.UnitOfMeasure = vekp_ewm.HandlingUnitTareVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureDimension ON _UnitOfMeasureDimension.UnitOfMeasure = vekp_ewm.UnitOfMeasureDimension  -- association [0..1]
-- UNION ALL with additional select branch(es): I_HandlingUnitHeader, I_HandlingUnitHeader, P_EWM_HandlingUnitHeader02
;