I_ExchangeRateRawData

Exchange Rate Raw Data | view: IEXCHRATESPREAD | Extraction: Full only | Component: Currency Conversion/Expiring Currency
Tables used: TCURR
Column Name Description
ExchangeRateType FK Exchange Rate Type
SourceCurrency FK From currency
TargetCurrency FK To-currency
ValidityStartDate null
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate null
Column Name Description
Column Name Description Domain name
ExchangeRate Exchange Rate UKURS
NumberOfSourceCurrencyUnits Ratio for the "from" currency units DEC9
NumberOfTargetCurrencyUnits Ratio for the "to" currency units DEC9
Master Data Relations Join Conditions
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_EXCHANGERATERAWDATA.MANDT == TCURV.MANDT
  • I_EXCHANGERATERAWDATA.EXCHANGERATETYPE == TCURV.KURST
From currency
  • From currency
  • Client
  • I_EXCHANGERATERAWDATA.SOURCECURRENCY == TCURC.WAERS
  • I_EXCHANGERATERAWDATA.MANDT == TCURC.MANDT
To-currency
  • Client
  • To-currency
  • I_EXCHANGERATERAWDATA.MANDT == TCURC.MANDT
  • I_EXCHANGERATERAWDATA.TARGETCURRENCY == TCURC.WAERS