I_ExchangeRate

Exchange Rate | view: IFIEXCHRATE | ATTR | Extraction: Full only | Component: Information System
Tables used: TCURVTCURXTCURFTCURRTCURFTCURRTCURFTCURR
Column Name Description
ExchangeRateType Exchange Rate Type
SourceCurrency FK From currency
TargetCurrency FK To-currency
ExchangeRateEffectiveDate null
Column Name Description
Column Name Description
Column Name Description
ExchangeRateEffectiveDate null
AltvExchangeRateTypeValdtyDate Date from which the alternative exchange rate type is valid
Column Name Description
InvertedExchangeRateIsAllowed Indicator: Calculation allowed with inverted exchange rate ? Show values
FixedExchangeRateIsUsed Indicator: Exchange rate type uses fixed exchange rates Show values
SpecialConversionIsUsed Indicator: Exchange rate type uses special translation model Show values
ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation Show values
Column Name Description Domain name
ExchangeRate Exchange Rate FIS_UKURS
NumberOfSourceCurrencyUnits Ratio for the "from" currency units DEC9
NumberOfTargetCurrencyUnits Ratio for the "to" currency units DEC9
SourceCurrencyDecimals Number of decimal places CURRDEC
TargetCurrencyDecimals Number of decimal places CURRDEC
AbsoluteExchangeRate Absolute Exchange Rate FIS_UKURS
EffectiveExchangeRate Effective Exchange Rate
DirectQuotedEffectiveExchRate Direct Quoted Effective Exchange Rate FIS_UKURS
IndirectQuotedEffctvExchRate Indirect Quoted Effective Exchange Rate FIS_UKURS
Master Data Relations Join Conditions
Check against entry in table TCURV
  • Alternative Exchange Rate Type
  • Client
  • I_EXCHANGERATE.ALTERNATIVEEXCHANGERATETYPE == TCURV.KURST
  • I_EXCHANGERATE.MANDT == TCURV.MANDT
Exch. rate type of av. rate used to determine buying rate
  • Exch. rate type of av. rate used to determine buying rate
  • Client
  • I_EXCHANGERATE.BUYINGRATEAVGEXCHANGERATETYPE == TCURV.KURST
  • I_EXCHANGERATE.MANDT == TCURV.MANDT
Reference currency for currency translation
  • Reference currency for currency translation
  • Client
  • I_EXCHANGERATE.REFERENCECURRENCY == TCURC.WAERS
  • I_EXCHANGERATE.MANDT == TCURC.MANDT
Exch.rate type of av. rate used to determine selling rate
  • Client
  • Exch.rate type of av. rate used to determine selling rate
  • I_EXCHANGERATE.MANDT == TCURV.MANDT
  • I_EXCHANGERATE.SELLINGRATEAVGEXCHANGERATETYPE == TCURV.KURST
From currency
  • From currency
  • Client
  • I_EXCHANGERATE.SOURCECURRENCY == TCURC.WAERS
  • I_EXCHANGERATE.MANDT == TCURC.MANDT
To-currency
  • Client
  • To-currency
  • I_EXCHANGERATE.MANDT == TCURC.MANDT
  • I_EXCHANGERATE.TARGETCURRENCY == TCURC.WAERS