TRDTT_VAD_SECSUB - Valuation Area-Dependent Data for Securities w. Subpositions

Valuation Area-Dependent Data for Securities w. Subpositions information is stored in SAP table TRDTT_VAD_SECSUB.
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_VAD_SECSUB

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6*
COMPANY_CODECompany CodeXBUKRSCHAR8*
HITEM_NUMBERHedged Item NumberXTPM_HITEM_NUMBERCHAR20
HINST_NUMBERHedging Instrument NumberXTPM_HINST_NUMBERCHAR20
FISCAL_YEARFiscal YearXGJAHRNUMC8
ASSG_UNITSUnitsTPM_UNITSDEC12
ASSG_NOM_AMTNominal AmountTPM_NOMINAL_AMTCURR11
ASSG_NOM_ORG_AMTOriginal Nominal Amount in Position CurrencyTPM_NOMINAL_ORG_AMTCURR11
NOMINAL_CURRNominal CurrencyTPM_NOMINAL_CURRCUKY10*
POSITION_CURRPosition CurrencyTPM_POSITION_CURRCUKY10*
VALUATION_CURRValuation CurrencyTPM_VALUATION_CURRCUKY10*
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
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
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
PURCH_PCPurchase Value in Position CurrencyTPM_PURCH_PCCURR11
PURCH_VCPurchase Value in Valuation CurrencyTPM_PURCH_VCCURR11
PURCH_IDX_CLEANPurchase Value, Index-Clean, in Position CurrencyTPM_PURCH_IDX_CLEANCURR11
CHARGE_PCCosts in Position CurrencyTPM_CHARGE_PCCURR11
CHARGE_VCCosts in Valuation CurrencyTPM_CHARGE_VCCURR11
CHARGE_IDX_CLEANCosts, Index-Clean, in Position CurrencyTPM_CHARGE_IDX_CLEANCURR11
REPAYMENT_PCCumulative Repayment in Position CurrencyTPM_REPAYMENT_PCCURR11
REPAYMENT_VCCumulative Repayment in Valuation CurrencyTPM_REPAYMENT_VCCURR11
REPAYMENT_IDXCLCumulative Repayment in Position Currency Index-CleanTPM_REPAYMENT_IDX_CLEANCURR11
Privacy Policy