Menu

SAP Table TRDTT_VADATA_SEC

Valuation-Area-Dependent Data for Securities

The table TRDTT_VADATA_SEC (Valuation-Area-Dependent Data for Securities) is a standard table in SAP ERP. It belongs to the package FTR_DATA_TRANSFER.

Technical Information

Table TRDTT_VADATA_SEC
Short Text Valuation-Area-Dependent Data for Securities
Package FTR_DATA_TRANSFER
Table Type Transparent Table

Fields for Table TRDTT_VADATA_SEC

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 *
KEY_DATE Position Value Date TPM_POSITION_DATE DATS 8
COMPANY_CODE Company Code BUKRS CHAR 4 *
COM_VAL_CLASS General Valuation Class TPM_COM_VAL_CLASS NUMC 4 TRGC_COM_VALCL
VALUATION_AREA Valuation Area TPM_VAL_AREA CHAR 3 *
SECURITY_ID Security ID Number VVRANLW CHAR 13 *
SECURITY_ACCOUNT Securities Account RLDEPO CHAR 10 *
PORTFOLIO Portfolio RPORTB CHAR 10 *
FUND Fund FM_FUND CHAR 10 *
GRANT_NBR Grant GM_GRANT_NBR CHAR 20
POSNR Item Number Legacy Data Transfer TPM_TRDT_POSNR NUMC 8
POSITION_CURR Position Currency TPM_POSITION_CURR CUKY 5 TCURC
VALUATION_CURR Valuation Currency TPM_VALUATION_CURR CUKY 5 TCURC
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position TPM_ACTIVE_PASSIVE CHAR 1
VAL_TI_PC Security Valuation in Position Currency TPM_VAL_TI_PC CURR 21
VAL_TI_VC Security Valuation in Valuation Currency TPM_VAL_TI_VC CURR 21
VAL_TI_IDX_CLEAN Security Valuation, Index-Clean, in Position Currency TPM_VAL_TI_IDX_CLEAN CURR 21
VAL_FX_VC Foreign Currency Valuation in Valuation Currency TPM_VAL_FX_VC CURR 21
VAL_IDX_PC Index Valuation in Position Currency TPM_VAL_IDX_PC CURR 21
VAL_IDX_VC Index Valuation in Valuation Currency TPM_VAL_IDX_VC CURR 21
VAL_CH_TI_PC Valuation of Cap. Costs, Security, in Position Currency TPM_VAL_CH_TI_PC CURR 21
VAL_CH_TI_VC Valuation of Cap. Costs, Security, in Valuation Currency TPM_VAL_CH_TI_VC CURR 21
VAL_CH_TI_IDXCL Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy TPM_VAL_CH_TI_IDX_CLEAN CURR 21
VAL_CH_FX_VC Valuation of Capitalized Costs, FX, in Valuation Currency TPM_VAL_CH_FX_VC CURR 21
VAL_AAV_FX_VC FX Valuation of Amort.Acquisition Value in Valuation Crcy TPM_VAL_AAV_FX_VC CURR 21
IMPAIRMENT_PC Impairment in Position Currency TPM_IMPAIRMENT_PC CURR 21
IMPAIRMENT_VC Impairment in Valuation Currency TPM_IMPAIRMENT_VC CURR 21
IMPMT_IDX_CLEAN Impairment in Position Currency Index-Clean TPM_IMPAIRMENT_IDX_CLEAN CURR 21
IMPAIRMENT_FX_VC FX Impairment in Valuation Currency TPM_IMPAIRMENT_FX_VC CURR 21
AMORT_PC Amortization in Position Currency TPM_AMORT_PC CURR 21
AMORT_VC Amortization in Valuation Currency TPM_AMORT_VC CURR 21
AMORT_IDX_CLEAN Amortization, Index-Clean, in Position Currency TPM_AMORT_IDX_CLEAN CURR 21
AMORT_NEG_SPR_PC Amortization of Negotiation Spread in Position Currency TPM_AMORT_NEG_SPREAD_PC CURR 21
AMORT_NEG_SPR_VC Amortization of Negotiation Spread in Valuation Currency TPM_AMORT_NEG_SPREAD_VC CURR 21
AM_NEG_SPR_IDXCL Amortiz. of Negotiation Spread in Position Crcy Index-Clean TPM_AMORT_NEG_SPREAD_IDX_CLEAN CURR 21
DISAGIO_PC Discount/Premium in Position Currency TPM_DISAGIO_PC CURR 21
DISAGIO_VC Discount/Premium in Valuation Currency TPM_DISAGIO_VC CURR 21
DISAGIO_IDXCL Index-Clean Discount/Premium in Position Currency TPM_DISAGIO_IDX_CLEAN CURR 21
VAL_TI_PC_NPL Securities Valuation Not Affecting P/L in Position Currency TPM_VAL_TI_PC_NPL CURR 21
VAL_TI_VC_NPL Securities Valuation Not Affecting P/L in Valuation Currency TPM_VAL_TI_VC_NPL CURR 21
VAL_IT_IDXCL_NPL Securities Val. Not Affecting P/L in Pos. Crcy Index Clean TPM_VAL_TI_IDXCL_NPL CURR 21
VAL_FX_VC_NPL Forex Valuation Not Affecting P/L in Valuation Currency TPM_VAL_FX_VC_NPL CURR 21
VAL_IDX_PC_NPL Index Valuation Not Affecting P/L in Position Currency TPM_VAL_IDX_PC_NPL CURR 21
VAL_IDX_VC_NPL Index Valuation Not Affecting P/L in Valuation Currency TPM_VAL_IDX_VC_NPL CURR 21
VAL_CH_TI_PC_NPL Security Costs Valuation Not Affecting P/L in Position Crcy TPM_VAL_CH_TI_PC_NPL CURR 21
VAL_CH_TI_VC_NPL Security Costs Valuation Not Affecting P/L in Valuation Crcy TPM_VAL_CH_TI_VC_NPL CURR 21
VAL_CHTIIDXCLNPL Security Costs Val. Not Affecting P/L in PosCrcy Index Clean TPM_VAL_CH_TI_IDXCL_NPL CURR 21
VAL_CH_FX_VC_NPL Forex Costs Valuation Not Affecting P/L in Valuation Crcy TPM_VAL_CH_FX_VC_NPL CURR 21
ACC_INT_PC Accrued Interest in Position Currency TPM_ACC_INTEREST_PC CURR 21
ACC_INT_VC Accrued Interest in Valuation Currency TPM_ACC_INTEREST_VC CURR 21
ACC_INT_IDXCL Accrued Interest in Position Currency Index-Clean TPM_ACC_INTEREST_IDX_CLEAN CURR 21
NGSPR_PC Negotiation Spread in Position Currency TPM_NGSPR_PC CURR 21
NGSPR_VC Negotiation Spread in Valuation Currency TPM_NGSPR_VC CURR 21
NGSPR_IDXCL Negotiation Spread Index Clean TPM_NGSPR_IDXCL CURR 21
ACCR_PC Accrual/Deferral in Position Currency TPM_ACCR_PC CURR 21
ACCR_VC Accrual/Deferral in Valuation Currency TPM_ACCR_VC CURR 21
ACCR_IDX_CLEAN Accrual/Deferral (1) Index Clean in Position Currency TPM_ACCR_IDX_CLEAN CURR 21
ACCR2_PC Accrual/Deferral (2) in Position Currency TPM_ACCR2_PC CURR 21
ACCR2_VC Accrual/Deferral (2) in Valuation Currency TPM_ACCR2_VC CURR 21
ACCR2_IDX_CLEAN Accrual/Deferral (2) Index Clean in Position Currency TPM_ACCR2_IDX_CLEAN CURR 21
RESET_VAL Valuation with Reset TPM_TRDT_RESET_VAL CHAR 1
RESET_AMORT Amortization with Reset TPM_TRDT_RESET_AMORT CHAR 1
RESET_ACCR Accrual/Deferral with Reset TPM_TRDT_RESET_ACCR CHAR 1
RESET_KEY_DATE Key Date for Reset within Legacy Data Transfer TPM_TRDT_RESET_KEYDATE DATS 8
RESET_IMP Impairment with Reset TPM_TRDT_RESET_IMP CHAR 1
DEAL_NUMBER Financial Transaction TB_RFHA CHAR 13 *
BUSTRANSID Identifier of the Distributor Business Transaction TPM_BUSTRANSID RAW 16
TRANS_FLG Flag: Legacy Data Transferred TPM_TRDT_TRANS_FLG CHAR 1
HAMORT_PC Hedge Amortization in Position Currency FTI_HAMORT_PC CURR 21
HAMORT_IDXCL_PC Hedge Amortization in Position Crcy, Index-Clean FTI_HAMORT_INDX_PC CURR 21
HAMORT_VC Hedge Amortization in Valuation Currency FTI_HAMORT_VC CURR 21
HADJ_PC Hedge Adjustment in Position Currency FTI_HADJ_PC CURR 21
HADJ_IDXCL_PC Hedge Adjustment in Position Currency, Index-Clean FTI_HADJ_INDX_PC CURR 21
HADJ_VC Hedge Adjustment in Valuation Currency FTI_HADJ_VC CURR 21
EFF_PC Effective Amount in Position Currency FTI_EFFECTIVE_PC CURR 21
EFF_VC Effective Amount in Valuation Currency FTI_EFFECTIVE_VC CURR 21
EFF_IDXCL_PC Effective Amount in Position Currency, Index Clean FTI_EFFECTIVE_IDXCL_PC CURR 21
INEFF_PC Ineffective Amount in Position Currency FTI_INEFFECTIVE_PC CURR 21
INEFF_VC Ineffective Amount in Valuation Currency FTI_INEFFECTIVE_VC CURR 21
INEFF_IDXCL_PC Ineffective Amount in Position Currency, Index Clean FTI_INEFFECTIVE_IDXCL_PC CURR 21
EFFD_PC Effective Amount (Dormant) in Position Currency FTI_EFFECTIVE_DORMANT_PC CURR 21
EFFD_VC Effective Amount (Dormant) in Valuation Currency FTI_EFFECTIVE_DORMANT_VC CURR 21
EFFD_IDXCL_PC Effective Amount (Dormant) in Position Currency, Index-Clean FTI_EFFECTIVE_DORMANT_IDXCL_PC CURR 21
INEFFD_PC Ineffective Amount (Dormant) in Position Currency FTI_INEFFECTIVE_DORMANT_PC CURR 21
INEFFD_VC Ineffective Amount (Dormant) in Valuation Currency FTI_INEFFECTIVE_DORMANT_VC CURR 21
INEFFD_IDXCL_PC Ineffective Amount (Dormant) in Position Currency, Index-Cln FTI_INEFF_DORMANT_IDXCL_PC CURR 21
ORIG_VAD_PC Original Value Adjustment in Position Currency FTI_ORIG_VAD_PC CURR 21
ORIG_VAD_VC Original Value Adjustment in Valuation Currency FTI_ORIG_VAD_VC CURR 21
VAD_GAIN_PC Value Adjustment of Gains in Position Currency FTI_VAD_GAIN_PC CURR 21
VAD_GAIN_VC Value Adjustment of Gains in Valuation Currency FTI_VAD_GAIN_VC CURR 21
VAD_LOSS_PC Value Adjustment of Losses in Position Currency FTI_VAD_LOSS_PC CURR 21
VAD_LOSS_VC Value Adjustment of Losses in Valuation Currency FTI_VAD_LOSS_VC CURR 21