I_CurrencyExchangeRateTP

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_CurrencyExchangeRateTP.
-- 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: ICRCYEXCHRATETP

CREATE VIEW I_CurrencyExchangeRateTP AS
SELECT
  ExchangeRateType,
  cast(SourceCurrency as fac_sourcecurrency) AS SourceCurrency,
  cast(TargetCurrency as fac_targetcurrency) AS TargetCurrency,
  cast(ExchangeRateEffectiveDate as abap.char(8)) AS ExchangeRateEffectiveDate,
  ExchangeRateType AS ExchangeRateTypeForEdit,
  cast(SourceCurrency as fac_sourcecurrency) AS SourceCurrencyForEdit,
  cast(TargetCurrency as fac_targetcurrency) AS TargetCurrencyForEdit,
  cast(ExchangeRateEffectiveDate as exchangerateeffectivedate) AS ExchangeRateEffectiveDateFoEd,
  CrcyExchangeRateValidOnDate,
  ExchangeRate,
  NumberOfSourceCurrencyUnits,
  NumberOfTargetCurrencyUnits,
  ExchRateIsIndirectQuotation,
  AbsoluteExchangeRate,
  EffectiveExchangeRate,
  DirectQuotedEffectiveExchRate,
  IndirectQuotedEffctvExchRate,
  StatisticsExchangeRate,
  CurrencyPair,
  CurrencyPairText,
  cast(0 as abap.int1) AS NumberOfIncompleteFields,
  cast(0 as abap.int1) AS Status,
  cast( concat( ExchRateIsIndirectQuotation, concat( cast( NumberOfSourceCurrencyUnits as abap.char( 11 ) ), concat( cast( NumberOfTargetCurrencyUnits as abap.char( 11 ) ), cast( AbsoluteExchangeRate as abap.char( 11 ) ) ) ) ) as hash160 ) as ChangeStateID AS char11ashash160asChangeStateID
FROM R_CurrencyExchangeRate
;