C_MktDataFXRateQuery

Market Data FX Rate - Query | view: CMKTFXQUERY | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: TCURVTCURXTCURFTCURRTCURFTCURRTCURFTCURR
Column Name Description
ExchangeRateType Exchange Rate Type
CurrencyPair Currency Pair
CalendarDate Calendar Date
Column Name Description
Column Name Description
Column Name Description
CalendarDate Calendar Date
Column Name Description
Column Name Description Domain name
NumberOfSourceCurrencyUnits Ratio for the "from" currency units DEC9
NumberOfTargetCurrencyUnits Ratio for the "to" currency units DEC9
ExchangeRate Exchange Rate FTR_MDM_UKURS
Master Data Relations Join Conditions
From currency
  • Client
  • From currency
  • C_MKTDATAFXRATEQUERY.MANDT == TCURC.MANDT
  • C_MKTDATAFXRATEQUERY.SOURCECURRENCY == TCURC.WAERS
To-currency
  • Client
  • To-currency
  • C_MKTDATAFXRATEQUERY.MANDT == TCURC.MANDT
  • C_MKTDATAFXRATEQUERY.TARGETCURRENCY == TCURC.WAERS