SAP Table TRDTT_VADATA_SEC - Valuation-Area-Dependent Data for Securities

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
KEY_DATE X TPM_POSITION_DATE DATS 3 8 0 Position Value Date
COMPANY_CODE X BUKRS CHAR 11 4 0 T001 Company Code
COM_VAL_CLASS X TPM_COM_VAL_CLASS NUMC 15 4 0 General Valuation Class
VALUATION_AREA X TPM_VAL_AREA CHAR 19 3 0 TRGC_VAL_AREA Valuation Area
SECURITY_ID X VVRANLW CHAR 22 13 0 Security ID Number
SECURITY_ACCOUNT X RLDEPO CHAR 35 10 0 Securities Account
PORTFOLIO X RPORTB CHAR 45 10 0 Portfolio
POSNR X TPM_TRDT_POSNR NUMC 55 8 0 Item Number Legacy Data Transfer
POSITION_CURR TPM_POSITION_CURR CUKY 63 5 0 TCURC Position Currency
VALUATION_CURR TPM_VALUATION_CURR CUKY 68 5 0 TCURC Valuation Currency
ACTIVE_PASSIVE TPM_ACTIVE_PASSIVE CHAR 73 1 0 Indicator: Assets/Liabilities Position
VAL_TI_PC TPM_VAL_TI_PC CURR 74 21 2 Security Valuation in Position Currency
VAL_TI_VC TPM_VAL_TI_VC CURR 85 21 2 Security Valuation in Valuation Currency
VAL_TI_IDX_CLEAN TPM_VAL_TI_IDX_CLEAN CURR 96 21 2 Security Valuation, Index-Clean, in Position Currency
VAL_FX_VC TPM_VAL_FX_VC CURR 107 21 2 Foreign Currency Valuation in Valuation Currency
VAL_IDX_PC TPM_VAL_IDX_PC CURR 118 21 2 Index Valuation in Position Currency
VAL_IDX_VC TPM_VAL_IDX_VC CURR 129 21 2 Index Valuation in Valuation Currency
VAL_CH_TI_PC TPM_VAL_CH_TI_PC CURR 140 21 2 Valuation of Cap. Costs, Security, in Position Currency
VAL_CH_TI_VC TPM_VAL_CH_TI_VC CURR 151 21 2 Valuation of Cap. Costs, Security, in Valuation Currency
VAL_CH_TI_IDXCL TPM_VAL_CH_TI_IDX_CLEAN CURR 162 21 2 Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
VAL_CH_FX_VC TPM_VAL_CH_FX_VC CURR 173 21 2 Valuation of Capitalized Costs, FX, in Valuation Currency
IMPAIRMENT_PC TPM_IMPAIRMENT_PC CURR 184 21 2 Impairment in Position Currency
IMPAIRMENT_VC TPM_IMPAIRMENT_VC CURR 195 21 2 Impairment in Valuation Currency
IMPMT_IDX_CLEAN TPM_IMPAIRMENT_IDX_CLEAN CURR 206 21 2 Impairment in Position Currency Index-Clean
AMORT_PC TPM_AMORT_PC CURR 217 21 2 Amortization in Position Currency
AMORT_VC TPM_AMORT_VC CURR 228 21 2 Amortization in Valuation Currency
AMORT_IDX_CLEAN TPM_AMORT_IDX_CLEAN CURR 239 21 2 Amortization, Index-Clean, in Position Currency
AMORT_NEG_SPR_PC TPM_AMORT_NEG_SPREAD_PC CURR 250 21 2 Amortization of Negotiation Spread in Position Currency
AMORT_NEG_SPR_VC TPM_AMORT_NEG_SPREAD_VC CURR 261 21 2 Amortization of Negotiation Spread in Valuation Currency
AM_NEG_SPR_IDXCL TPM_AMORT_NEG_SPREAD_IDX_CLEAN CURR 272 21 2 Amortiz. of Negotiation Spread in Position Crcy Index-Clean
DISAGIO_PC TPM_DISAGIO_PC CURR 283 21 2 Discount/Premium in Position Currency
DISAGIO_VC TPM_DISAGIO_VC CURR 294 21 2 Discount/Premium in Valuation Currency
DISAGIO_IDXCL TPM_DISAGIO_IDX_CLEAN CURR 305 21 2 Index-Clean Discount/Premium in Position Currency
VAL_TI_PC_NPL TPM_VAL_TI_PC_NPL CURR 316 21 2 Securities Valuation Not Affecting P/L in Position Currency
VAL_TI_VC_NPL TPM_VAL_TI_VC_NPL CURR 327 21 2 Securities Valuation Not Affecting P/L in Valuation Currency
VAL_IT_IDXCL_NPL TPM_VAL_TI_IDXCL_NPL CURR 338 21 2 Securities Val. Not Affecting P/L in Pos. Crcy Index Clean
VAL_FX_VC_NPL TPM_VAL_FX_VC_NPL CURR 349 21 2 Forex Valuation Not Affecting P/L in Valuation Currency
VAL_IDX_PC_NPL TPM_VAL_IDX_PC_NPL CURR 360 21 2 Index Valuation Not Affecting P/L in Position Currency
VAL_IDX_VC_NPL TPM_VAL_IDX_VC_NPL CURR 371 21 2 Index Valuation Not Affecting P/L in Valuation Currency
VAL_CH_TI_PC_NPL TPM_VAL_CH_TI_PC_NPL CURR 382 21 2 Security Costs Valuation Not Affecting P/L in Position Crcy
VAL_CH_TI_VC_NPL TPM_VAL_CH_TI_VC_NPL CURR 393 21 2 Security Costs Valuation Not Affecting P/L in Valuation Crcy
VAL_CHTIIDXCLNPL TPM_VAL_CH_TI_IDXCL_NPL CURR 404 21 2 Security Costs Val. Not Affecting P/L in PosCrcy Index Clean
VAL_CH_FX_VC_NPL TPM_VAL_CH_FX_VC_NPL CURR 415 21 2 Forex Costs Valuation Not Affecting P/L in Valuation Crcy
ACC_INT_PC TPM_ACC_INTEREST_PC CURR 426 21 2 Accrued Interest in Position Currency
ACC_INT_VC TPM_ACC_INTEREST_VC CURR 437 21 2 Accrued Interest in Valuation Currency
ACC_INT_IDXCL TPM_ACC_INTEREST_IDX_CLEAN CURR 448 21 2 Accrued Interest in Position Currency Index-Clean
NGSPR_PC TPM_NGSPR_PC CURR 459 21 2 Negotiation Spread in Position Currency
NGSPR_VC TPM_NGSPR_VC CURR 470 21 2 Negotiation Spread in Valuation Currency
NGSPR_IDXCL TPM_NGSPR_IDXCL CURR 481 21 2 Negotiation Spread Index Clean
ACCR_PC TPM_ACCR_PC CURR 492 21 2 Accrual/Deferral in Position Currency
ACCR_VC TPM_ACCR_VC CURR 503 21 2 Accrual/Deferral in Valuation Currency
ACCR_IDX_CLEAN TPM_ACCR_IDX_CLEAN CURR 514 21 2 Accrual/Deferral (1) Index Clean in Position Currency
RESET_VAL TPM_TRDT_RESET_VAL CHAR 525 1 0 Valuation with Reset
RESET_AMORT TPM_TRDT_RESET_AMORT CHAR 526 1 0 Amortization with Reset
RESET_ACCR TPM_TRDT_RESET_ACCR CHAR 527 1 0 Accrual/Deferral with Reset
RESET_KEY_DATE TPM_TRDT_RESET_KEYDATE DATS 528 8 0 Key Date for Reset within Legacy Data Transfer
DEAL_NUMBER TB_RFHA CHAR 536 13 0 Financial Transaction
BUSTRANSID TPM_BUSTRANSID RAW 549 16 0 Identifier of the Distributor Business Transaction
TRANS_FLG TPM_TRDT_TRANS_FLG CHAR 565 1 0 Flag: Legacy Data Transferred