I_TrsyValueAtRiskPnLCharcs

DDL: I_TRSYVALUEATRISKPNLCHARCS Type: view COMPOSITE
34 Fields 1 Data Sources

Value at Risk Profit and Loss with Analysis Characteristics

I_TrsyValueAtRiskPnLCharcs is a Composite CDS View that provides data about "Value at Risk Profit and Loss with Analysis Characteristics" in SAP S/4HANA. It reads from 1 data source (I_TrsyValueAtRiskProfitAndLoss) and exposes 34 fields with key fields ValidityDate, ValueAtRiskSimulationRun, TreasuryFinancialObject, MarketRiskKeyFigureSet.

Data Sources (1)

SourceAliasJoin Type
I_TrsyValueAtRiskProfitAndLoss I_TrsyValueAtRiskProfitAndLoss from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ITRVARPLCHAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #SWITCHED_OFF view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #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 #COMPOSITE view
EndUserText.label Value at Risk Profit and Loss with Analysis Characteristics view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ValidityDate ValidityDate Valid On
KEY ValueAtRiskSimulationRun ValueAtRiskSimulationRun Simulatn Index
KEY TreasuryFinancialObject TreasuryFinancialObject Val. Obj. No.
KEY MarketRiskKeyFigureSet MarketRiskKeyFigureSet MR Key Figure Set
ValueAtRiskPnLAmtInEvalCrcy
ValueAtRiskProfitAndLossValue ValueAtRiskProfitAndLossValue Profit/Loss
EvaluationCurrency EvaluationCurrency Evaluation Currency
CompanyCode _FinancialObject CompanyCode Receiver Company Code
TrsyFinObjValidityStartDate _FinancialObject TrsyFinObjValidityStartDate
TrsyFinObjValidityEndDate _FinancialObject TrsyFinObjValidityEndDate
TreasuryContractType _FinancialObject TreasuryContractType Treasury Contract Type
FinancialInstrProductCategory _FinancialObject FinancialInstrProductCategory
FinancialInstrumentProductType _FinancialObject FinancialInstrumentProductType
Portfolio _FinancialObject Portfolio Portfolio
FinancialTransaction _FinancialObject FinancialTransaction Transaction
SecurityClass _FinancialObject SecurityClass
SecurityAccount _FinancialObject SecurityAccount
TreasuryPositionAccount _FinancialObject TreasuryPositionAccount
FinancialExposurePosition _FinancialObject FinancialExposurePosition
LoanContract _FinancialObject LoanContract
BusinessPartner _FinancialObject BusinessPartner Issuing Authority
MktRiskCharacteristicCurrency _FinancialObject MktRiskCharacteristicCurrency
Country _FinancialObject Country Venue: Ctry/Reg
FinancialInstrCharacteristic _FinancialObject FinancialInstrCharacteristic Characteristics
_CompanyCode _FinancialObject _CompanyCode
_ProductCategory _FinancialObject _ProductCategory
_Portfolio _FinancialObject _Portfolio
_ContractType _FinancialObject _ContractType
_ProductType _FinancialObject _ProductType
_SecurityClass _FinancialObject _SecurityClass
_SecurityAccount _FinancialObject _SecurityAccount
_BusinessPartner _FinancialObject _BusinessPartner
_CharacteristicCurrency _FinancialObject _CharacteristicCurrency
_Country _FinancialObject _Country

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_TrsyValueAtRiskPnLCharcs.
-- 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_TrsyValueAtRiskPnLCharcs AS
SELECT
  ValidityDate,
  ValueAtRiskSimulationRun,
  TreasuryFinancialObject,
  MarketRiskKeyFigureSet,
  cast( round( fltp_to_dec( ValueAtRiskProfitAndLossValue as abap.dec( 24 , 3 ) ), 2) as ftr_mra_var_pl_in_evalcrcy ) AS ValueAtRiskPnLAmtInEvalCrcy,
  ValueAtRiskProfitAndLossValue,
  EvaluationCurrency,
  _FinancialObject.CompanyCode AS CompanyCode,
  _FinancialObject.TrsyFinObjValidityStartDate AS TrsyFinObjValidityStartDate,
  _FinancialObject.TrsyFinObjValidityEndDate AS TrsyFinObjValidityEndDate,
  _FinancialObject.TreasuryContractType AS TreasuryContractType,
  _FinancialObject.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _FinancialObject.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  _FinancialObject.Portfolio AS Portfolio,
  _FinancialObject.FinancialTransaction AS FinancialTransaction,
  _FinancialObject.SecurityClass AS SecurityClass,
  _FinancialObject.SecurityAccount AS SecurityAccount,
  _FinancialObject.TreasuryPositionAccount AS TreasuryPositionAccount,
  _FinancialObject.FinancialExposurePosition AS FinancialExposurePosition,
  _FinancialObject.LoanContract AS LoanContract,
  _FinancialObject.BusinessPartner AS BusinessPartner,
  _FinancialObject.MktRiskCharacteristicCurrency AS MktRiskCharacteristicCurrency,
  _FinancialObject.Country AS Country,
  _FinancialObject.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  _FinancialObject._CompanyCode AS _CompanyCode,
  _FinancialObject._ProductCategory AS _ProductCategory,
  _FinancialObject._Portfolio AS _Portfolio,
  _FinancialObject._ContractType AS _ContractType,
  _FinancialObject._ProductType AS _ProductType,
  _FinancialObject._SecurityClass AS _SecurityClass,
  _FinancialObject._SecurityAccount AS _SecurityAccount,
  _FinancialObject._BusinessPartner AS _BusinessPartner,
  _FinancialObject._CharacteristicCurrency AS _CharacteristicCurrency,
  _FinancialObject._Country AS _Country
FROM I_TrsyValueAtRiskProfitAndLoss
;

Learn More