I_UnitOfMeasure

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_UnitOfMeasure.
-- 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: IUNITOFMEASURE

CREATE VIEW I_UnitOfMeasure AS
SELECT
  cast ( msehi as msehiunit preserving type ) AS UnitOfMeasure,
  cast ( msehi as meinsint ) AS UnitOfMeasureSAPCode,
  isocode AS UnitOfMeasureISOCode,
  primary AS IsPrimaryUnitForISOCode,
  andec AS UnitOfMeasureNumberOfDecimals,
  kzkeh AS UnitOfMeasureIsCommercial,
  dimid AS UnitOfMeasureDimension,
  zaehl AS SIUnitCnvrsnRateNumerator,
  nennr AS SIUnitCnvrsnRateDenominator,
  exp10 AS SIUnitCnvrsnRateExponent,
  addko AS SIUnitCnvrsnAdditiveValue,
  expon AS UnitOfMeasureDspExponent,
  decan AS UnitOfMeasureDspNmbrOfDcmls,
  temp_value AS UnitOfMeasureTemperature,
  temp_unit AS UnitOfMeasureTemperatureUnit,
  press_val AS UnitOfMeasurePressure,
  press_unit AS UnitOfMeasurePressureUnit,
  _Text[ 1: Language = $session.system_language ].UnitOfMeasure_E AS UnitOfMeasure_E
FROM t006
LEFT OUTER JOIN I_UnitOfMeasureText AS _Text ON UnitOfMeasure = _Text.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureDimension AS _Dimension ON UnitOfMeasureDimension = _Dimension.UnitOfMeasureDimension  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureDimensionText AS _DimensionText ON UnitOfMeasureDimension = _DimensionText.UnitOfMeasureDimension  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureISOCode AS _ISOCode ON UnitOfMeasureISOCode = _ISOCode.UnitOfMeasureISOCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureISOCodeText AS _ISOCodeText ON UnitOfMeasureISOCode = _ISOCodeText.UnitOfMeasureISOCode  -- association [0..*]
;