P_SECURITYPRICEKEYDATE

Security Price on Key Date | view: PSECPRICEKEYD | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: SCAL_TT_DATEATRASVWPBONO
Column Name Description
SecurityClass Security Class ID Number
SecurityExchange FK Exchange
SecurityClassPriceType FK Market Data: Security Price Type
KeyDate Calendar Date
Column Name Description
Column Name Description
Column Name Description
KeyDate Calendar Date
TreasuryPriceDate null
Column Name Description
Column Name Description Domain name
SecurityClassValueInQtanUnit Price of Unit- or Percentage-Quoted Security VVPKTKUR
Master Data Relations Join Conditions
Rate/price types
  • Market Data: Security Price Type
  • Client
  • P_SECURITYPRICEKEYDATE.SECURITYCLASSPRICETYPE == TW56.SKURSART
  • P_SECURITYPRICEKEYDATE.MANDT == TW56.MANDT
Currencies
  • Quotation currency (which prices are in)
  • Client
  • P_SECURITYPRICEKEYDATE.SECURITYCLASSSTOCKPRICECRCY == TCURC.WAERS
  • P_SECURITYPRICEKEYDATE.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Exchanges
  • Exchange
  • Client
  • P_SECURITYPRICEKEYDATE.SECURITYEXCHANGE == TWH01.RHANDPL
  • P_SECURITYPRICEKEYDATE.MANDT == TWH01.MANDT