I_TrsyMktRskKeyFigureSet

DDL: I_TRSYMKTRSKKEYFIGURESET Type: view BASIC Package: FTR_MARKET_RISK_ANALYZER_CORE

Treasury Market Risk Key Figure Set

I_TrsyMktRskKeyFigureSet (Basic)

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

Financial Operations

I_TrsyMktRskKeyFigureSet is a Basic CDS View that provides data about "Treasury Market Risk Key Figure Set" in SAP S/4HANA. It reads from 1 data source (afwgo_mrakfset) and exposes 6 fields with key field MarketRiskKeyFigureSet. It has 1 association to related views. Part of development package FTR_MARKET_RISK_ANALYZER_CORE.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
Purpose
With this CDS view you get the details defined for market risk key figure sets. This CDS view provides the prerequisites for answering the following business questions: Which market risk key figure sets are defined? Which evaluation currency is defined in a market risk key figure set? Which scenario and market data shift are assigned to the market risk key figure set?

Structure
Main CDS parameters and filters The main filters are: Market risk key figure set Measures and attributes Some important measures and attributes are: Market risk key figure set Evaluation currency Evaluation type Scenario Market data shift rule

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-MR-2CL
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>With this CDS view you get the details defined for market risk key figure sets.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which market risk key figure sets are defined?</p></li> <li><p>Which evaluation currency is defined in a market risk key figure set?</p></li> <li><p>Which scenario and market data shift are assigned to the market risk key figure set?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
afwgo_mrakfset KeyFigureSet from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TrsyMktRskKeyFigureSetText _KeyFigureSetText _KeyFigureSetText.MarketRiskKeyFigureSet = $projection.MarketRiskKeyFigureSet

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ITRSYMRAKFSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey MarketRiskKeyFigureSet view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
VDM.viewType #BASIC view
EndUserText.label Treasury Market Risk Key Figure Set view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MarketRiskKeyFigureSet afwgo_mrakfset mra_kf_set Market Risk Key Figure Set
EvaluationCurrency afwgo_mrakfset currency Evaluation Currency
TreasuryEvaluationType afwgo_mrakfset eval_type Evaluation Type
MarketDataScenario afwgo_mrakfset md_scenario Scenario
MarketDataShift afwgo_mrakfset md_shift_id Market Data Shift Rule
_KeyFigureSetText _KeyFigureSetText

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_TrsyMktRskKeyFigureSet.
-- 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.

CREATE VIEW I_TrsyMktRskKeyFigureSet AS
SELECT
  KeyFigureSet.mra_kf_set AS MarketRiskKeyFigureSet,
  KeyFigureSet.currency AS EvaluationCurrency,
  KeyFigureSet.eval_type AS TreasuryEvaluationType,
  KeyFigureSet.md_scenario AS MarketDataScenario,
  KeyFigureSet.md_shift_id AS MarketDataShift
FROM afwgo_mrakfset AS KeyFigureSet
LEFT OUTER JOIN I_TrsyMktRskKeyFigureSetText AS _KeyFigureSetText ON _KeyFigureSetText.MarketRiskKeyFigureSet = MarketRiskKeyFigureSet  -- association [0..*]
;