I_MktDataFXRateCube

DDL: I_MKTDATAFXRATECUBE SQL: IMKTFXRATECUBE Type: view COMPOSITE
12 Fields 1 Data Sources 5 Associations

Market Data FX Rate - Cube

I_MktDataFXRateCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_MktDataFXRateCube is a Composite CDS View (Cube) that provides data about "Market Data FX Rate - Cube" in SAP S/4HANA. It reads from 1 data source (I_ExchangeRate) and exposes 12 fields with key fields CurrencyPair, CalendarDate, ExchangeRateType. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Market Data
Data CategoryCube
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the foreign exchange rates for a period of time? What are the currency pairs for the foreign exchange rates? What are exchange rate types for foreign exchange rates?

Structure
Main CDS parameters and filters The main filters are: Exchange Rate Type Currency Pair Source Currency Target Currency Exchange Rate Calendar Date Range Measures and attributes Some important measures and attributes are: Exchange Rate Currency Pair

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM
CapabilitiesData Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the foreign exchange rates for a period of time?</p></li> <li><p>What are the currency pairs for the foreign exchange rates?</p></li> <li><p>What are exchange rate types for foreign exchange rates?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ExchangeRate FXRate from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_MktDataCurrencyPair _CurrencyPair $projection.CurrencyPair = _CurrencyPair.CurrencyPair
[0..1] I_CalendarDate _CalendarDate $projection.CalendarDate = _CalendarDate.CalendarDate
[0..1] I_Currency _SourceCurrency $projection.SourceCurrency = _SourceCurrency.Currency
[0..1] I_Currency _TargetCurrency $projection.TargetCurrency = _TargetCurrency.Currency
[0..1] I_ExchangeRateType _ExchangeType $projection.ExchangeRateType = _ExchangeType.ExchangeRateType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMKTFXRATECUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey CurrencyPair view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Market Data FX Rate - Cube view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CurrencyPair Currency Pair
KEY CalendarDate Calendar Date
KEY ExchangeRateType I_ExchangeRate ExchangeRateType Exchange Rate Type
SourceCurrency I_ExchangeRate SourceCurrency From currency
TargetCurrency I_ExchangeRate TargetCurrency Trans. Currency
NumberOfSourceCurrencyUnits Ratio for the "from" currency units
NumberOfTargetCurrencyUnits Ratio for the "to" currency units
_CurrencyPair _CurrencyPair
_CalendarDate _CalendarDate
_SourceCurrency _SourceCurrency
_TargetCurrency _TargetCurrency
_ExchangeType _ExchangeType

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_MktDataFXRateCube.
-- 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: IMKTFXRATECUBE

CREATE VIEW I_MktDataFXRateCube AS
SELECT
  cast( CONCAT(CONCAT(FXRate.SourceCurrency,'/'),FXRate.TargetCurrency ) as ftr_curr_pair) AS CurrencyPair,
  cast( FXRate.ExchangeRateEffectiveDate as calendardate) AS CalendarDate,
  FXRate.ExchangeRateType AS ExchangeRateType,
  FXRate.SourceCurrency AS SourceCurrency,
  FXRate.TargetCurrency AS TargetCurrency,
  cast( FXRate.NumberOfSourceCurrencyUnits as ffact_curr ) AS NumberOfSourceCurrencyUnits,
  cast( FXRate.NumberOfTargetCurrencyUnits as tfact_curr ) AS NumberOfTargetCurrencyUnits
FROM I_ExchangeRate AS FXRate
LEFT OUTER JOIN I_MktDataCurrencyPair AS _CurrencyPair ON CurrencyPair = _CurrencyPair.CurrencyPair  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON CalendarDate = _CalendarDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SourceCurrency ON SourceCurrency = _SourceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TargetCurrency ON TargetCurrency = _TargetCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeType ON ExchangeRateType = _ExchangeType.ExchangeRateType  -- association [0..1]
;

Learn More