I_SecurityPriceDeviation

Security Price Deviation | view: ISECPRICEDEV | TRAN | 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
Column Name Description
Column Name Description Domain name
SecurityClassValueInQtanUnit Price of Unit- or Percentage-Quoted Security VVPKTKUR
SecurityPriceDvtnInPct null
ScrtyPrcAbsDvtnAmtInPriceCrcy null
Master Data Relations Join Conditions
Rate/price types
  • Client
  • Market Data: Security Price Type
  • I_SECURITYPRICEDEVIATION.MANDT == TW56.MANDT
  • I_SECURITYPRICEDEVIATION.SECURITYCLASSPRICETYPE == TW56.SKURSART
Currencies
  • Client
  • Quotation currency (which prices are in)
  • I_SECURITYPRICEDEVIATION.MANDT == TCURC.MANDT
  • I_SECURITYPRICEDEVIATION.SECURITYCLASSSTOCKPRICECRCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Exchanges
  • Client
  • Exchange
  • I_SECURITYPRICEDEVIATION.MANDT == TWH01.MANDT
  • I_SECURITYPRICEDEVIATION.SECURITYEXCHANGE == TWH01.RHANDPL