I_OIL_ModesOfTransportVH

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_OIL_ModesOfTransportVH.
-- 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_OIL_ModesOfTransportVH AS
SELECT
  vktra AS ModeOfTransport,
  vktrt AS DangerousGdsTranspModeCat,
  trmodcat AS TransportationModeCategory,
  main_carriage AS ModeOfTransportIsMainCarriage,
  dist_emission_factor AS MOTSustainabilityCategoryValue,
  default_mtr AS TranspMeansOfTransport,
  oijmti AS IndicatorModeOfTransport
FROM tvtr
LEFT OUTER JOIN I_TransportationModeText AS _Text ON _Text.TransportationMode = ModeOfTransport  -- association [0..*]
LEFT OUTER JOIN I_TransportationModeCategory AS _TransportationModeCategory ON TransportationModeCategory = _TransportationModeCategory.TransportationModeCategory  -- association [0..1]
LEFT OUTER JOIN I_OIL_MoOfTrCatVH AS _MoOfTrCatVH ON _MoOfTrCatVH.DangerousGdsTranspModeCat = DangerousGdsTranspModeCat  -- association [0..1]
LEFT OUTER JOIN I_MeansOfTransport AS _MeansOfTransport ON _MeansOfTransport.MeansOfTransport = TranspMeansOfTransport  -- association [0..1]
LEFT OUTER JOIN I_OIL_TSWModeOfTransportVH AS _TSWModeOfTransportVH ON _TSWModeOfTransportVH.IndicatorModeOfTransport = IndicatorModeOfTransport  -- association [0..1]
;