C_TrsyMktRskKeyFigValueQry

Treasury Market Risk Key Figure Value Query | view: CTRSYMRKFVALQ | Extraction: Not supported | Component: Market Risk Analyzer
Column Name Description
MarketRiskKeyFigureSet Market Risk Key Figure Set
ValidityDate Key Date in Results Databases
TreasuryFinancialObject Object Number for Financial Transactions
Column Name Description
💲 Display Currency (DisplayCurrency):
NetPresentValueInDisplayCrcy Net Present Value in Display Currency
CleanPriceAmountInDisplayCrcy Clean Price in Display Currency
BasePointValueAmountInDspCrcy Basis Point Value in Display Currency
💲 Evaluation Currency (EvaluationCurrency):
NetPresentValueInEvalCrcy Net Present Value in Evaluation Currency
CleanPriceAmountInEvalCrcy Clean Price in Evaluation Currency
BasePointValueAmountInEvalCrcy Basis Point Value in Evaluation Currency
Column Name Description
Column Name Description
ValidityDate Key Date in Results Databases
Column Name Description
TreasuryContractType Contract Type Show values
NetPresentValueSign Sign of Net Present Value Show values
Column Name Description Domain name
FinancialTransaction Financial Transaction T_RFHA
FinancialInstrumentProductType Product Type VVSART
Portfolio Portfolio RPORTB
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
MktRskKeyFigMacaulayDuration Macaulay Duration
MktRskKeyFigModifiedDuration Modified Duration
MktRskKeyFigFisherWeilDuration Fisher-Weil Duration Value
NetPresentValueConvexityValue Convexity
OptionDeltaValue Option Delta
YieldToMaturityRate Yield to Maturity
Master Data Relations Join Conditions
Business Partner Number
  • Business Partner Number
  • Client
  • C_TRSYMKTRSKKEYFIGVALUEQRY.BUSINESSPARTNER == BUT000.PARTNER
  • C_TRSYMKTRSKKEYFIGVALUEQRY.MANDT == BUT000.CLIENT
Company Code
  • Company Code
  • Client
  • C_TRSYMKTRSKKEYFIGVALUEQRY.COMPANYCODE == T001.BUKRS
  • C_TRSYMKTRSKKEYFIGVALUEQRY.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • C_TRSYMKTRSKKEYFIGVALUEQRY.MANDT == T005.MANDT
  • C_TRSYMKTRSKKEYFIGVALUEQRY.COUNTRY == T005.LAND1
Product Category C_TRSYMKTRSKKEYFIGVALUEQRY.FINANCIALINSTRPRODUCTCATEGORY == TZAF.SANLF
Analytic Characteristic Currency
  • Client
  • Analytic Characteristic Currency
  • C_TRSYMKTRSKKEYFIGVALUEQRY.MANDT == TCURC.MANDT
  • C_TRSYMKTRSKKEYFIGVALUEQRY.MKTRISKCHARACTERISTICCURRENCY == TCURC.WAERS