C_SecurityPriceQuery

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