C_TrsyValueAtRiskQuery

Treasury Value At Risk Query | view: CTRVARQ | Extraction: Not supported | Component: Market Risk Analyzer
Column Name Description
ValidityDate Key Date in Results Databases
TreasuryFinancialObject Object Number for Financial Transactions
MarketRiskKeyFigureSet Market Risk Key Figure Set
Column Name Description
💲 Display Currency (DisplayCurrency):
ValueAtRiskInDisplayCurrency Value at Risk in Display Currency
MeanExcessLossAmtInDisplayCrcy Mean Excess Loss in Display Currency
💲 Evaluation Currency (EvaluationCurrency):
ValueAtRiskInEvaluationCrcy Value at Risk in Evaluation Currency
MeanExcessLossAmtInEvalCrcy Mean Excess Loss in Evaluation Currency
Column Name Description
Column Name Description
ValidityDate Key Date in Results Databases
Column Name Description
TreasuryContractType Contract Type Show values
Column Name Description Domain name
FinancialInstrumentProductType Product Type VVSART
Portfolio Portfolio RPORTB
FinancialTransaction Financial Transaction T_RFHA
SecurityClass Security Class ID Number WP_RANL
SecurityAccount Securities Account RLDEPO
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
FinancialExposurePosition Exposure Position ID FTR_POSITION_ID
LoanContract Contract Number RANL
FinancialInstrCharacteristic Characteristics CHAR25
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_TRSYVALUEATRISKQUERY.BUSINESSPARTNER == BUT000.PARTNER
  • C_TRSYVALUEATRISKQUERY.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_TRSYVALUEATRISKQUERY.COMPANYCODE == T001.BUKRS
  • C_TRSYVALUEATRISKQUERY.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_TRSYVALUEATRISKQUERY.COUNTRY == T005.LAND1
  • C_TRSYVALUEATRISKQUERY.MANDT == T005.MANDT
Product Category C_TRSYVALUEATRISKQUERY.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Analytic Characteristic Currency
  • Analytic Characteristic Currency
  • Client
  • C_TRSYVALUEATRISKQUERY.MKTRISKCHARACTERISTICCURRENCY == TCURC.WAERS
  • C_TRSYVALUEATRISKQUERY.MANDT == TCURC.MANDT