What is C_MktDataFXRateQuery in SAP S/4HANA?

C_MktDataFXRateQuery is a consumption CDS view in SAP S/4HANA. Market Data FX Rate - Query It contains 8 fields.

Which tables does C_MktDataFXRateQuery read from?

C_MktDataFXRateQuery reads data from: I_MktDataFXRateCube.

What VDM layer is C_MktDataFXRateQuery?

C_MktDataFXRateQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MktDataFXRateQuery

DDL: C_MKTDATAFXRATEQUERY SQL: CMKTFXQUERY Type: view CONSUMPTION Package: FTR_MDM_CORE

8 Fields 1 Data Sources

Market Data FX Rate - Query

C_MktDataFXRateQuery (Consumption)

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

Financial Operations

C_MktDataFXRateQuery is a Consumption CDS View that provides data about "Market Data FX Rate - Query" in SAP S/4HANA. It reads from 1 data source (I_MktDataFXRateCube) and exposes 8 fields with key fields ExchangeRateType, CurrencyPair, CalendarDate. Part of development package FTR_MDM_CORE.

SAP Help Documentation

Category	CDS Views for Market Data
Data Category	Query
Status	Released
Corresponding DataSource	2CCMKTFXQUERY

Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the historic foreign exchange (FX) rates within a predefined period of time? What are the currency pairs for the FX rates? What are exchange rate types for the FX rates?

Structure
Object types This view is built on the market data of foreign exchange rate. Main CDS parameters and filters The main filters are: Exchange Rate Type Currency Pair Calendar Date Measures and attributes Some important measures and attributes are: Exchange Rate Exchange Rate Type Calendar Date Currency Pair Source Currency Target Currency

Example of the Consumption of this Query View
This query view is consumed in the Treasury Executive Dashboard story, which is predefined in the Manage KPI and Reports app and executed in the Treasury Executive Dashboard app. This query view is consumed in the Treasury Executive Dashboard story, which is predefined as example content in the SAP Analytics Cloud solution.

View on SAP Help Portal →

SAP API Hub

Category	Consumption
State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-TRM-2CL
Capabilities	Analytical Query
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Financial Operations for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What are the historic foreign exchange (FX) rates within a predefined period of time?</p> </li> <li> <p>What are the currency pairs for the FX rates?</p> </li> <li> <p>What are exchange rate types for the FX rates?</p> </li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_MktDataFXRateCube	I_MktDataFXRateCube	from

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CMKTFXQUERY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
OData.publish	true	view
Metadata.allowExtensions	true	view
Analytics.query	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Market Data FX Rate - Query	view

Fields (8)

Key	Field	Source Table	Source Field	Description
KEY	ExchangeRateType		ExchangeRateType	Exchange Rate Type
KEY	CurrencyPair	FXRate	CurrencyPair	Currency Pair
KEY	CalendarDate		CalendarDate	Calendar Date
	SourceCurrency	FXRate	SourceCurrency	From-Currency
	TargetCurrency	FXRate	TargetCurrency	To-Currency
	NumberOfSourceCurrencyUnits		NumberOfSourceCurrencyUnits	Ratio for the "from" currency units
	NumberOfTargetCurrencyUnits		NumberOfTargetCurrencyUnits	Ratio for the "to" currency units
	ExchangeRate	FXRate	ExchangeRate	Exchange rate

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 C_MktDataFXRateQuery.
-- 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: CMKTFXQUERY

CREATE VIEW C_MktDataFXRateQuery AS
SELECT
  ExchangeRateType,
  FXRate.CurrencyPair AS CurrencyPair,
  CalendarDate,
  FXRate.SourceCurrency AS SourceCurrency,
  FXRate.TargetCurrency AS TargetCurrency,
  NumberOfSourceCurrencyUnits,
  NumberOfTargetCurrencyUnits,
  FXRate.ExchangeRate AS ExchangeRate
FROM I_MktDataFXRateCube
;

Depth:

C_MktDataFXRateQuery view

I_MktDataFXRateCube view