I_TrsyValueAtRiskProfitAndLoss

DDL: I_TRSYVALUEATRISKPROFITANDLOSS Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Treasury Value at Risk Profit and Loss

I_TrsyValueAtRiskProfitAndLoss is a Basic CDS View that provides data about "Treasury Value at Risk Profit and Loss" in SAP S/4HANA. It reads from 1 data source (rdbra_rec_var_pl) and exposes 8 fields with key fields ValidityDate, MarketRiskHierarchyNode, ValueAtRiskSimulationRun, TreasuryFinancialObject, MarketRiskKeyFigureSet. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
rdbra_rec_var_pl rdbra_rec_var_pl from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_TrsyFinancialObject _FinancialObject $projection.TreasuryFinancialObject = _FinancialObject.TreasuryFinancialObject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ITRSYVARPL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #SWITCHED_OFF view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #BASIC view
EndUserText.label Treasury Value at Risk Profit and Loss view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ValidityDate keydate Maturity Key Date
KEY MarketRiskHierarchyNode rknoten Risk Hier. Node
KEY ValueAtRiskSimulationRun simidx Simulatn Index
KEY TreasuryFinancialObject objnr Val. Obj. No.
KEY MarketRiskKeyFigureSet mra_kf_set MR Key Figure Set
ValueAtRiskProfitAndLossValue profitandloss Profit/Loss
EvaluationCurrency evaluation_currency Evaluation Currency
_FinancialObject _FinancialObject

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_TrsyValueAtRiskProfitAndLoss.
-- 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_TrsyValueAtRiskProfitAndLoss AS
SELECT
  keydate AS ValidityDate,
  rknoten AS MarketRiskHierarchyNode,
  simidx AS ValueAtRiskSimulationRun,
  objnr AS TreasuryFinancialObject,
  mra_kf_set AS MarketRiskKeyFigureSet,
  profitandloss AS ValueAtRiskProfitAndLossValue,
  evaluation_currency AS EvaluationCurrency
FROM rdbra_rec_var_pl
LEFT OUTER JOIN I_TrsyFinancialObject AS _FinancialObject ON TreasuryFinancialObject = _FinancialObject.TreasuryFinancialObject  -- association [1..1]
;

Learn More