I_TranspRateTableDimension

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_TranspRateTableDimension.
-- 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_TranspRateTableDimension AS
SELECT
  TranspRateDimensionUUID,
  TranspRateValidityUUID,
  TransportationRateUUID,
  TranspRateDimnScaleItem01UUID,
  TranspRateDimnScaleItem02UUID,
  TranspRateDimnScaleItem03UUID,
  TranspRateDimnScaleItem04UUID,
  TranspRateDimnScaleItem05UUID,
  TranspRateDimnScaleItem06UUID,
  TranspRateDimnScaleItem07UUID,
  TranspRateDimnScaleItem08UUID,
  TranspRateDimnScaleItem09UUID,
  TranspRateDimnScaleItem10UUID,
  TranspRateDimnScaleItem11UUID,
  TranspRateDimnScaleItem12UUID,
  TranspRateDimnScaleItem13UUID,
  TranspRateDimnScaleItem14UUID,
  TransportationRateCurrency,
  TranspRateAmountInRateCrcy
FROM P_TranspRateDimension AS RateTableDim
LEFT OUTER JOIN I_TranspRateValidity AS _TransportationRateValidity ON TranspRateValidityUUID = _TransportationRateValidity.TranspRateValidityUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationRate AS _TransportationRate ON TransportationRateUUID = _TransportationRate.TransportationRateUUID  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransportationRateCurrency ON TransportationRateCurrency = _TransportationRateCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem01 ON TranspRateDimnScaleItem01UUID = _TransportationScaleItem01.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem02 ON TranspRateDimnScaleItem02UUID = _TransportationScaleItem02.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem03 ON TranspRateDimnScaleItem03UUID = _TransportationScaleItem03.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem04 ON TranspRateDimnScaleItem04UUID = _TransportationScaleItem04.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem05 ON TranspRateDimnScaleItem05UUID = _TransportationScaleItem05.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem06 ON TranspRateDimnScaleItem06UUID = _TransportationScaleItem06.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem07 ON TranspRateDimnScaleItem07UUID = _TransportationScaleItem07.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem08 ON TranspRateDimnScaleItem08UUID = _TransportationScaleItem08.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem09 ON TranspRateDimnScaleItem09UUID = _TransportationScaleItem09.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem10 ON TranspRateDimnScaleItem10UUID = _TransportationScaleItem10.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem11 ON TranspRateDimnScaleItem11UUID = _TransportationScaleItem11.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem12 ON TranspRateDimnScaleItem12UUID = _TransportationScaleItem12.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem13 ON TranspRateDimnScaleItem13UUID = _TransportationScaleItem13.TransportationScaleItemUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspRateScaleItemValue AS _TransportationScaleItem14 ON TranspRateDimnScaleItem14UUID = _TransportationScaleItem14.TransportationScaleItemUUID  -- association [0..1]
;