TRDTT_VADATA_SEC

Valuation-Area-Dependent Data for Securities | #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
SECURITY_ID Security Class ID Number
SECURITY_ACCOUNT Securities Account
PORTFOLIO Portfolio
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_TI_IDX_CLEAN Security Valuation, Index-Clean, in Position Currency
VAL_IDX_PC Index Valuation in Position Currency
VAL_CH_TI_PC Valuation of Cap. Costs, Security, in Position Currency
VAL_CH_TI_IDXCL Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
IMPAIRMENT_PC Impairment in Position Currency
IMPMT_IDX_CLEAN Impairment in Position Currency Index-Clean
AMORT_PC Amortization in Position Currency
AMORT_IDX_CLEAN Amortization, Index-Clean, in Position Currency
AMORT_NEG_SPR_PC Amortization of Negotiation Spread in Position Currency
AM_NEG_SPR_IDXCL Amortiz. of Negotiation Spread in Position Crcy Index-Clean
DISAGIO_PC Discount/Premium in Position Currency
DISAGIO_IDXCL Index-Clean Discount/Premium in Position Currency
VAL_TI_PC_NPL Securities Valuation Not Affecting P/L in Position Currency
VAL_IT_IDXCL_NPL Securities Val. Not Affecting P/L in Pos. Crcy Index Clean
VAL_IDX_PC_NPL Index Valuation Not Affecting P/L in Position Currency
VAL_CH_TI_PC_NPL Security Costs Valuation Not Affecting P/L in Position Crcy
VAL_CHTIIDXCLNPL Security Costs Val. Not Affecting P/L in PosCrcy Index Clean
ACC_INT_PC Accrued Interest in Position Currency
ACC_INT_IDXCL Accrued Interest in Position Currency Index-Clean
NGSPR_PC Negotiation Spread in Position Currency
NGSPR_IDXCL Negotiation Spread Index Clean
ACCR_PC Accrual/Deferral in Position Currency
ACCR_IDX_CLEAN Accrual/Deferral (1) Index Clean in Position Currency
ACCR2_PC Accrual/Deferral (2) in Position Currency
ACCR2_IDX_CLEAN Accrual/Deferral (2) Index Clean in Position Currency
HAMORT_PC Hedge Amortization in Position Currency
HAMORT_IDXCL_PC Hedge Amortization in Position Crcy, Index-Clean
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
ORIG_VAD_PC Original Value Adjustment in Position Currency
VAD_GAIN_PC Value Adjustment of Gains in Position Currency
VAD_LOSS_PC Value Adjustment of Losses 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
AM_ADJ_LOSS_ALLOW_PC Amortization Adjustment Loss Allowance in Pos. Crcy.
AM_ADJ_LOSS_ALLOW_INDX_PC Amortization Adjust. Loss Al. in Pos. Crcy.: Idx.-Clean
💲 Valuation Currency (VALUATION_CURR):
VAL_TI_VC Security Valuation in Valuation Currency
VAL_FX_VC Foreign Currency Valuation in Valuation Currency
VAL_IDX_VC Index 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
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
IMPAIRMENT_VC Impairment in Valuation Currency
IMPAIRMENT_FX_VC FX Impairment in Valuation Currency
AMORT_VC Amortization in Valuation Currency
AMORT_NEG_SPR_VC Amortization of Negotiation Spread in Valuation Currency
DISAGIO_VC Discount/Premium 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_IDX_VC_NPL Index 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
ACC_INT_VC Accrued Interest in Valuation Currency
NGSPR_VC Negotiation Spread in Valuation Currency
ACCR_VC Accrual/Deferral in Valuation Currency
ACCR2_VC Accrual/Deferral (2) in Valuation Currency
HAMORT_VC Hedge Amortization 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
ORIG_VAD_VC Original Value Adjustment in Valuation Currency
VAD_GAIN_VC Value Adjustment of Gains in Valuation Currency
VAD_LOSS_VC Value Adjustment of Losses in Valuation Currency
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
AM_ADJ_LOSS_ALLOW_VC Amortization Adjustment Loss Allowance in Valuation Crcy.
AM_ADJ_LOSS_ALLOW_FX_VC Amortization Adjustment Loss Allowance FX in Valuation Crcy.
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
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position Show values
Column Name Description Domain name
RESET_VAL Valuation with Reset CHAR1
RESET_AMORT Amortization with Reset CHAR1
RESET_ACCR Accrual/Deferral with Reset CHAR1
RESET_IMP Impairment with Reset CHAR1
DEAL_NUMBER Financial Transaction T_RFHA
BUSTRANSID Identifier of the Distributor Business Transaction SYSUUID
TRANS_FLG Flag: Legacy Data Transferred CHAR1
Master Data Relations Join Conditions
General Valuation Class
  • General Valuation Class
  • Client
Position Currency
  • TRDTT_VADATA_SEC.MANDT == TCURC.MANDT
  • TRDTT_VADATA_SEC.POSITION_CURR == TCURC.WAERS
Valuation Currency
  • TRDTT_VADATA_SEC.MANDT == TCURC.MANDT
  • TRDTT_VADATA_SEC.VALUATION_CURR == TCURC.WAERS