TRDTT_VADATA_SEC - Valuation-Area-Dependent Data for Securities

Valuation-Area-Dependent Data for Securities information is stored in SAP table TRDTT_VADATA_SEC.
 It is part of development package FTR_DATA_TRANSFER in software component FIN-FSCM-TRM-TM. This development package consists of objects that can be grouped under "Legacy Data Transfer".

Fields for table TRDTT_VADATA_SEC

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
KEY_DATEPosition Value DateXTPM_POSITION_DATEDATS16
COMPANY_CODECompany CodeXBUKRSCHAR8
COM_VAL_CLASSGeneral Valuation ClassXTPM_COM_VAL_CLASSNUMC8TRGC_COM_VALCL
VALUATION_AREATreasury Valuation AreaXTPM_VAL_AREACHAR6
SECURITY_IDSecurity Class ID NumberXVVRANLWCHAR26
SECURITY_ACCOUNTSecurities AccountXRLDEPOCHAR20
PORTFOLIOPortfolioXRPORTBCHAR20
FUNDFundXFM_FUNDCHAR20
GRANT_NBRGrantXGM_GRANT_NBRCHAR40
POSNRItem Number Legacy Data TransferXTPM_TRDT_POSNRNUMC16
POSITION_CURRPosition CurrencyTPM_POSITION_CURRCUKY10TCURC
VALUATION_CURRValuation CurrencyTPM_VALUATION_CURRCUKY10TCURC
ACTIVE_PASSIVEIndicator: Assets/Liabilities PositionTPM_ACTIVE_PASSIVECHAR2
VAL_TI_PCSecurity Valuation in Position CurrencyTPM_VAL_TI_PCCURR11
VAL_TI_VCSecurity Valuation in Valuation CurrencyTPM_VAL_TI_VCCURR11
VAL_TI_IDX_CLEANSecurity Valuation, Index-Clean, in Position CurrencyTPM_VAL_TI_IDX_CLEANCURR11
VAL_FX_VCForeign Currency Valuation in Valuation CurrencyTPM_VAL_FX_VCCURR11
VAL_IDX_PCIndex Valuation in Position CurrencyTPM_VAL_IDX_PCCURR11
VAL_IDX_VCIndex Valuation in Valuation CurrencyTPM_VAL_IDX_VCCURR11
VAL_CH_TI_PCValuation of Cap. Costs, Security, in Position CurrencyTPM_VAL_CH_TI_PCCURR11
VAL_CH_TI_VCValuation of Cap. Costs, Security, in Valuation CurrencyTPM_VAL_CH_TI_VCCURR11
VAL_CH_TI_IDXCLValuation of Cap. Costs, Security, Index-Clean, in Pos. CrcyTPM_VAL_CH_TI_IDX_CLEANCURR11
VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Valuation CurrencyTPM_VAL_CH_FX_VCCURR11
VAL_AAV_FX_VCFX Valuation of Amort.Acquisition Value in Valuation CrcyTPM_VAL_AAV_FX_VCCURR11
VAL_AV_FX_VCFX Valuation of Acquisition Value in Valuation CrcyTPM_VAL_AV_FX_VCCURR11
IMPAIRMENT_PCImpairment in Position CurrencyTPM_IMPAIRMENT_PCCURR11
IMPAIRMENT_VCImpairment in Valuation CurrencyTPM_IMPAIRMENT_VCCURR11
IMPMT_IDX_CLEANImpairment in Position Currency Index-CleanTPM_IMPAIRMENT_IDX_CLEANCURR11
IMPAIRMENT_FX_VCFX Impairment in Valuation CurrencyTPM_IMPAIRMENT_FX_VCCURR11
AMORT_PCAmortization in Position CurrencyTPM_AMORT_PCCURR11
AMORT_VCAmortization in Valuation CurrencyTPM_AMORT_VCCURR11
AMORT_IDX_CLEANAmortization, Index-Clean, in Position CurrencyTPM_AMORT_IDX_CLEANCURR11
AMORT_NEG_SPR_PCAmortization of Negotiation Spread in Position CurrencyTPM_AMORT_NEG_SPREAD_PCCURR11
AMORT_NEG_SPR_VCAmortization of Negotiation Spread in Valuation CurrencyTPM_AMORT_NEG_SPREAD_VCCURR11
AM_NEG_SPR_IDXCLAmortiz. of Negotiation Spread in Position Crcy Index-CleanTPM_AMORT_NEG_SPREAD_IDX_CLEANCURR11
DISAGIO_PCDiscount/Premium in Position CurrencyTPM_DISAGIO_PCCURR11
DISAGIO_VCDiscount/Premium in Valuation CurrencyTPM_DISAGIO_VCCURR11
DISAGIO_IDXCLIndex-Clean Discount/Premium in Position CurrencyTPM_DISAGIO_IDX_CLEANCURR11
VAL_TI_PC_NPLSecurities Valuation Not Affecting P/L in Position CurrencyTPM_VAL_TI_PC_NPLCURR11
VAL_TI_VC_NPLSecurities Valuation Not Affecting P/L in Valuation CurrencyTPM_VAL_TI_VC_NPLCURR11
VAL_IT_IDXCL_NPLSecurities Val. Not Affecting P/L in Pos. Crcy Index CleanTPM_VAL_TI_IDXCL_NPLCURR11
VAL_FX_VC_NPLForex Valuation Not Affecting P/L in Valuation CurrencyTPM_VAL_FX_VC_NPLCURR11
VAL_IDX_PC_NPLIndex Valuation Not Affecting P/L in Position CurrencyTPM_VAL_IDX_PC_NPLCURR11
VAL_IDX_VC_NPLIndex Valuation Not Affecting P/L in Valuation CurrencyTPM_VAL_IDX_VC_NPLCURR11
VAL_CH_TI_PC_NPLSecurity Costs Valuation Not Affecting P/L in Position CrcyTPM_VAL_CH_TI_PC_NPLCURR11
VAL_CH_TI_VC_NPLSecurity Costs Valuation Not Affecting P/L in Valuation CrcyTPM_VAL_CH_TI_VC_NPLCURR11
VAL_CHTIIDXCLNPLSecurity Costs Val. Not Affecting P/L in PosCrcy Index CleanTPM_VAL_CH_TI_IDXCL_NPLCURR11
VAL_CH_FX_VC_NPLForex Costs Valuation Not Affecting P/L in Valuation CrcyTPM_VAL_CH_FX_VC_NPLCURR11
ACC_INT_PCAccrued Interest in Position CurrencyTPM_ACC_INTEREST_PCCURR11
ACC_INT_VCAccrued Interest in Valuation CurrencyTPM_ACC_INTEREST_VCCURR11
ACC_INT_IDXCLAccrued Interest in Position Currency Index-CleanTPM_ACC_INTEREST_IDX_CLEANCURR11
NGSPR_PCNegotiation Spread in Position CurrencyTPM_NGSPR_PCCURR11
NGSPR_VCNegotiation Spread in Valuation CurrencyTPM_NGSPR_VCCURR11
NGSPR_IDXCLNegotiation Spread Index CleanTPM_NGSPR_IDXCLCURR11
ACCR_PCAccrual/Deferral in Position CurrencyTPM_ACCR_PCCURR11
ACCR_VCAccrual/Deferral in Valuation CurrencyTPM_ACCR_VCCURR11
ACCR_IDX_CLEANAccrual/Deferral (1) Index Clean in Position CurrencyTPM_ACCR_IDX_CLEANCURR11
ACCR2_PCAccrual/Deferral (2) in Position CurrencyTPM_ACCR2_PCCURR11
ACCR2_VCAccrual/Deferral (2) in Valuation CurrencyTPM_ACCR2_VCCURR11
ACCR2_IDX_CLEANAccrual/Deferral (2) Index Clean in Position CurrencyTPM_ACCR2_IDX_CLEANCURR11
RESET_VALValuation with ResetTPM_TRDT_RESET_VALCHAR2
RESET_AMORTAmortization with ResetTPM_TRDT_RESET_AMORTCHAR2
RESET_ACCRAccrual/Deferral with ResetTPM_TRDT_RESET_ACCRCHAR2
RESET_KEY_DATEKey Date for Reset within Legacy Data TransferTPM_TRDT_RESET_KEYDATEDATS16
RESET_IMPImpairment with ResetTPM_TRDT_RESET_IMPCHAR2
DEAL_NUMBERFinancial TransactionTB_RFHACHAR26
BUSTRANSIDIdentifier of the Distributor Business TransactionTPM_BUSTRANSIDRAW16
TRANS_FLGFlag: Legacy Data TransferredTPM_TRDT_TRANS_FLGCHAR2
HAMORT_PCHedge Amortization in Position CurrencyFTI_HAMORT_PCCURR11
HAMORT_IDXCL_PCHedge Amortization in Position Crcy, Index-CleanFTI_HAMORT_INDX_PCCURR11
HAMORT_VCHedge Amortization in Valuation CurrencyFTI_HAMORT_VCCURR11
HADJ_PCHedge Adjustment in Position CurrencyFTI_HADJ_PCCURR11
HADJ_IDXCL_PCHedge Adjustment in Position Currency, Index-CleanFTI_HADJ_INDX_PCCURR11
HADJ_VCHedge Adjustment in Valuation CurrencyFTI_HADJ_VCCURR11
EFF_PCEffective Amount in Position CurrencyFTI_EFFECTIVE_PCCURR11
EFF_VCEffective Amount in Valuation CurrencyFTI_EFFECTIVE_VCCURR11
EFF_IDXCL_PCEffective Amount in Position Currency, Index CleanFTI_EFFECTIVE_IDXCL_PCCURR11
INEFF_PCIneffective Amount in Position CurrencyFTI_INEFFECTIVE_PCCURR11
INEFF_VCIneffective Amount in Valuation CurrencyFTI_INEFFECTIVE_VCCURR11
INEFF_IDXCL_PCIneffective Amount in Position Currency, Index CleanFTI_INEFFECTIVE_IDXCL_PCCURR11
EFFD_PCEffective Amount (Dormant) in Position CurrencyFTI_EFFECTIVE_DORMANT_PCCURR11
EFFD_VCEffective Amount (Dormant) in Valuation CurrencyFTI_EFFECTIVE_DORMANT_VCCURR11
EFFD_IDXCL_PCEffective Amount (Dormant) in Position Currency, Index-CleanFTI_EFFECTIVE_DORMANT_IDXCL_PCCURR11
INEFFD_PCIneffective Amount (Dormant) in Position CurrencyFTI_INEFFECTIVE_DORMANT_PCCURR11
INEFFD_VCIneffective Amount (Dormant) in Valuation CurrencyFTI_INEFFECTIVE_DORMANT_VCCURR11
INEFFD_IDXCL_PCIneffective Amount (Dormant) in Position Currency, Index-ClnFTI_INEFF_DORMANT_IDXCL_PCCURR11
ORIG_VAD_PCOriginal Value Adjustment in Position CurrencyFTI_ORIG_VAD_PCCURR11
ORIG_VAD_VCOriginal Value Adjustment in Valuation CurrencyFTI_ORIG_VAD_VCCURR11
VAD_GAIN_PCValue Adjustment of Gains in Position CurrencyFTI_VAD_GAIN_PCCURR11
VAD_GAIN_VCValue Adjustment of Gains in Valuation CurrencyFTI_VAD_GAIN_VCCURR11
VAD_LOSS_PCValue Adjustment of Losses in Position CurrencyFTI_VAD_LOSS_PCCURR11
VAD_LOSS_VCValue Adjustment of Losses in Valuation CurrencyFTI_VAD_LOSS_VCCURR11
LOSS_ALLOW_PCLoss Allowance in Position CurrencyTPM_LOSS_ALLOW_PCCURR11
LOSS_ALLOW_CLLoss Allowance in Position Currency: Index-CleanTPM_LOSS_ALLOW_INDX_PCCURR11
LOSS_ALLOW_VCLoss Allowance in Valuation CurrencyTPM_LOSS_ALLOW_VCCURR11
LOSS_ALLOW_FX_VCLoss Allowance FX in Valuation CurrencyTPM_LOSS_ALLOW_FX_VCCURR11
CON_MODIF_PCValue for Profit/Loss Calc. after Contract Modific. in PCTPM_CONTRACT_MODIF_DELTA_PCCURR11
CON_MODIF_VCValue for Profit/Loss Calc. after Contract Modific. in VCTPM_CONTRACT_MODIF_DELTA_VCCURR11
CON_MODIF_FX_VCValue for Profit/Loss Calc. after Contract Modific. in FX VCTPM_CONTRACT_MODIF_DELTA_FX_VCCURR11
AM_ADJ_LOSS_ALLOW_PCAmortization Adjustment Loss Allowance in Pos. Crcy.TPM_AMO_ADJ_LOSS_ALLOW_PCCURR11
AM_ADJ_LOSS_ALLOW_INDX_PCAmortization Adjust. Loss Al. in Pos. Crcy.: Idx.-CleanTPM_AMO_ADJ_LOSS_ALLOW_INDX_PCCURR11
AM_ADJ_LOSS_ALLOW_VCAmortization Adjustment Loss Allowance in Valuation Crcy.TPM_AMO_ADJ_LOSS_ALLOW_VCCURR11
AM_ADJ_LOSS_ALLOW_FX_VCAmortization Adjustment Loss Allowance FX in Valuation Crcy.TPM_AMO_ADJ_LOSS_ALLOW_FX_VCCURR11
Privacy Policy