Menu

SAP Table TRDTT_VADATA_SEC

Valuation-Area-Dependent Data for Securities

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

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