I_OilPhysParamUoMVH

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_OilPhysParamUoMVH.
-- 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: IPHYPARUOMVH

CREATE VIEW I_OilPhysParamUoMVH AS
SELECT
  _oib07help.par_name AS OilPhysParamName,
  _oib07help.dimid AS UnitOfMeasureDimension,
  _LanguageUnit.msehi AS UnitOfMeasure,
  _LanguageUnit.mseh3 AS UnitOfMeasure_E,
  _LanguageUnit.msehl AS UnitOfMeasureLongName,
  case when _ExternalUnit.cmsehi is null then _LanguageUnit.mseh3 else _ExternalUnit.cmsehi end as OilUnitOfMeasureExt AS cmsehiendasOilUnitOfMeasureExt,
  case when _ExternalUnittext.cmsehl is null then _LanguageUnit.msehl else _ExternalUnittext.cmsehl end as OilUoMExtLongName AS cmsehlendasOilUoMExtLongName
FROM t006 AS _InternalUnit
INNER JOIN oib07_help AS _oib07help ON /* join condition not captured in parsed metadata */
INNER JOIN t006d AS _DimidHelp ON /* join condition not captured in parsed metadata */
INNER JOIN t006a AS _LanguageUnit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oib_map_uom AS _ExternalUnit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oib_map_uomt AS _ExternalUnittext ON /* join condition not captured in parsed metadata */
;