P_Difsdiff

CDS view for Treasury: Structure DIFS_DIFF_VALUES | view: PDIFSDIFF | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: DIFT_POS_IDENT
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
flag_long_short Indicates whether it is a long or a short position Show values
Column Name Description Domain name
trac_oid Object Identity in Database Format TPM_DB_OS_GUID
trl_oid Object Identity in Database Format TPM_DB_OS_GUID
lot_id Identifier of the Lot SYSUUID
fund Fund BP_GEBER
grant_nbr Grant GM_GRANT_NBR
external_account External Account TPM_EXT_ACCOUNT
exposure_item_id Exposure Item ID TOE_EXPOSURE_ITEM_ID
exposure_subitem_id Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Company Code
  • Client
  • P_DIFSDIFF.COMPANY_CODE == T001.BUKRS
  • P_DIFSDIFF.MANDT == T001.MANDT
General Valuation Class
  • General Valuation Class
  • Client
Transaction Number
  • Company Code
  • Financial Transaction
  • Client
  • P_DIFSDIFF.COMPANY_CODE == VTBFHA.BUKRS
  • P_DIFSDIFF.DEAL_NUMBER == VTBFHA.RFHA
  • P_DIFSDIFF.MANDT == VTBFHA.MANDT
Currency as Differentiation Term
  • Currency as Differentiation Term
  • Client
  • P_DIFSDIFF.DIFF_CURRENCY == TCURC.WAERS
  • P_DIFSDIFF.MANDT == TCURC.MANDT
Contract Number
  • ?
  • Company Code
  • Contract Number
  • Client
  • P_DIFSDIFF.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • P_DIFSDIFF.COMPANY_CODE == VDARL.BUKRS
  • P_DIFSDIFF.LOANS_CONTRACT == VDARL.RANL
  • P_DIFSDIFF.MANDT == VDARL.MANDT
Portfolio as Differentiation Characteristic
  • Portfolio as Differentiation Characteristic
  • Company Code
  • Client
  • P_DIFSDIFF.PORTFOLIO == TWPOB.RPORTB
  • P_DIFSDIFF.COMPANY_CODE == TWPOB.BUKRS
  • P_DIFSDIFF.MANDT == TWPOB.MANDT
Foreign Key Futures Account
  • Futures Account for Listed Options and Futures
  • Company Code
  • Client
Product Type
  • Client
  • Product Type
  • P_DIFSDIFF.MANDT == TZPA.MANDT
  • P_DIFSDIFF.PRODUCT_TYPE == TZPA.GSART
Securities Account
  • Company Code
  • Client
  • Securities Account
  • P_DIFSDIFF.COMPANY_CODE == TWD01.BUKRS
  • P_DIFSDIFF.MANDT == TWD01.MANDT
  • P_DIFSDIFF.SECURITY_ACCOUNT == TWD01.RLDEPO
Security Class ID Number
  • Client
  • Security Class ID Number
  • P_DIFSDIFF.MANDT == VWPANLA.MANDT
  • P_DIFSDIFF.SECURITY_ID == VWPANLA.RANL
Valuation Class
  • Treasury Valuation Area
  • Client
  • Valuation Class
Other Relations | to Master Data Relations ↑ Join Conditions
Accounting Code
  • Accounting Code
  • Client
Securities Account Group
  • Securities Account Group
  • Company Code
  • Client
Trader
  • Company Code
  • Trader
  • Client
  • P_DIFSDIFF.COMPANY_CODE == TZDEA.BUKRS
  • P_DIFSDIFF.TRADER == TZDEA.RDEALER
  • P_DIFSDIFF.MANDT == TZDEA.MANDT
Treasury Valuation Area
  • Treasury Valuation Area
  • Client