TRDTT_VADATA_OTC

Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | #masterdata | Component: Transaction Manager
Column Name Description
MANDT Client
KEY_DATE Position Value Date
COMPANY_CODE Company Code
COM_VAL_CLASS FK General Valuation Class
VALUATION_AREA Treasury Valuation Area
DEAL_NUMBER Financial Transaction
FUND Fund
GRANT_NBR Grant
POSNR Item Number Legacy Data Transfer
Column Name Description
💲 Position Currency (POSITION_CURR):
VAL_TI_PC Security Valuation in Position Currency
VAL_CH_TI_PC Valuation of Cap. Costs, Security, in Position Currency
IMPAIRMENT_PC Impairment in Position Currency
AMORT_PC Amortization in Position Currency
VAL_TI_PC_NPL Securities Valuation Not Affecting P/L in Position Currency
VAL_CH_TI_PC_NPL Security Costs Valuation Not Affecting P/L in Position Crcy
VAL_MS_DEF_PC Margin/Swap Deferral in Position Currency
ACCR_PC Accrual/Deferral in Position Currency
ACCR2_PC Accrual/Deferral (2) in Position Currency
HADJ_PC Hedge Adjustment in Position Currency
HADJ_IDXCL_PC Hedge Adjustment in Position Currency, Index-Clean
EFF_PC Effective Amount in Position Currency
EFF_IDXCL_PC Effective Amount in Position Currency, Index Clean
INEFF_PC Ineffective Amount in Position Currency
INEFF_IDXCL_PC Ineffective Amount in Position Currency, Index Clean
EFFD_PC Effective Amount (Dormant) in Position Currency
EFFD_IDXCL_PC Effective Amount (Dormant) in Position Currency, Index-Clean
INEFFD_PC Ineffective Amount (Dormant) in Position Currency
INEFFD_IDXCL_PC Ineffective Amount (Dormant) in Position Currency, Index-Cln
INT_INCOME_PC Interest Income in Position Currency
DISAGIO_PC Discount/Premium in Position Currency
LOSS_ALLOW_PC Loss Allowance in Position Currency
LOSS_ALLOW_CL Loss Allowance in Position Currency: Index-Clean
CON_MODIF_PC Value for Profit/Loss Calc. after Contract Modific. in PC
💲 Valuation Currency (VALUATION_CURR):
VAL_TI_VC Security Valuation in Valuation Currency
VAL_FX_VC Foreign Currency Valuation in Valuation Currency
VAL_CH_TI_VC Valuation of Cap. Costs, Security, in Valuation Currency
VAL_CH_FX_VC Valuation of Capitalized Costs, FX, in Valuation Currency
IMPAIRMENT_VC Impairment in Valuation Currency
AMORT_VC Amortization in Valuation Currency
VAL_TI_VC_NPL Securities Valuation Not Affecting P/L in Valuation Currency
VAL_FX_VC_NPL Forex Valuation Not Affecting P/L in Valuation Currency
VAL_CH_TI_VC_NPL Security Costs Valuation Not Affecting P/L in Valuation Crcy
VAL_CH_FX_VC_NPL Forex Costs Valuation Not Affecting P/L in Valuation Crcy
VAL_PURCH_VC Purchase Currency Valuation in Valuation Currency
VAL_SALE_VC Sale Currency Valuation in Valuation Currency
VAL_MS_DEF_VC Margin/Swap Deferral in Valuation Currency
VAL_SWAP_VC Swap Accrual/Deferral in Valuation Currency
ACCR_VC Accrual/Deferral in Valuation Currency
ACCR2_VC Accrual/Deferral (2) in Valuation Currency
HADJ_VC Hedge Adjustment in Valuation Currency
EFF_VC Effective Amount in Valuation Currency
INEFF_VC Ineffective Amount in Valuation Currency
EFFD_VC Effective Amount (Dormant) in Valuation Currency
INEFFD_VC Ineffective Amount (Dormant) in Valuation Currency
INT_INCOME_VC Interest Income in Valuation Currency
DISAGIO_VC Discount/Premium in Valuation Currency
VAL_AAV_FX_VC FX Valuation of Amort.Acquisition Value in Valuation Crcy
VAL_AV_FX_VC FX Valuation of Acquisition Value in Valuation Crcy
LOSS_ALLOW_VC Loss Allowance in Valuation Currency
LOSS_ALLOW_FX_VC Loss Allowance FX in Valuation Currency
CON_MODIF_VC Value for Profit/Loss Calc. after Contract Modific. in VC
CON_MODIF_FX_VC Value for Profit/Loss Calc. after Contract Modific. in FX VC
Column Name Description
Column Name Description
KEY_DATE Position Value Date
RESET_KEY_DATE Key Date for Reset within Legacy Data Transfer
Column Name Description
Column Name Description Domain name
RESET_VAL Valuation with Reset CHAR1
RESET_ACCR Accrual/Deferral with Reset CHAR1
BUSTRANSID Identifier of the Distributor Business Transaction SYSUUID
TRANS_FLG Flag: Legacy Data Transferred CHAR1
RESET_AMORT Amortization with Reset CHAR1
Master Data Relations Join Conditions
General Valuation Class
  • General Valuation Class
  • Client
Position Currency
  • TRDTT_VADATA_OTC.MANDT == TCURC.MANDT
  • TRDTT_VADATA_OTC.POSITION_CURR == TCURC.WAERS
Valuation Currency
  • TRDTT_VADATA_OTC.MANDT == TCURC.MANDT
  • TRDTT_VADATA_OTC.VALUATION_CURR == TCURC.WAERS