TRDTT_VADATA_SEC SAP (Valuation-Area-Dependent Data for Securities) Table details

Dictionary Type: Table
Description: Valuation-Area-Dependent Data for Securities




ABAP Code to SELECT data from TRDTT_VADATA_SEC
Related tables to TRDTT_VADATA_SEC
Access table TRDTT_VADATA_SEC




Table field list including key, data, relationships and ABAP select examples

TRDTT_VADATA_SEC is a standard SAP Table which is used to store Valuation-Area-Dependent Data for Securities data and is available within R/3 SAP systems depending on the version and release level.

The TRDTT_VADATA_SEC table consists of various fields, each holding specific information or linking keys about Valuation-Area-Dependent Data for Securities data available in SAP. These include KEY_DATE (Position Value Date), COMPANY_CODE (Company Code), COM_VAL_CLASS (General Valuation Class), VALUATION_AREA (Valuation Area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP TRDTT_VADATA_SEC table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
KEY_DATEPosition Value Date TPM_POSITION_DATEDATS8TPM_POSITION_DATE
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
COM_VAL_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3Assigned to domainTPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
SECURITY_IDSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
SECURITY_ACCOUNTSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
PORTFOLIOPortfolio RPORTBCHAR10Assigned to domainRPORTBT50H_RPORTB_CORE
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
POSNRItem Number Legacy Data Transfer TPM_TRDT_POSNRNUMC8NUMC08
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5TCURCWAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5TCURCWAERS
ACTIVE_PASSIVEIndicator: Assets/Liabilities Position TPM_ACTIVE_PASSIVECHAR1TPM_ACTIVE_PASSIVE
VAL_TI_PCSecurity Valuation in Position Currency TPM_VAL_TI_PCCURR21(2) TPM_AMOUNT
VAL_TI_VCSecurity Valuation in Valuation Currency TPM_VAL_TI_VCCURR21(2) TPM_AMOUNT
VAL_TI_IDX_CLEANSecurity Valuation, Index-Clean, in Position Currency TPM_VAL_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_FX_VCForeign Currency Valuation in Valuation Currency TPM_VAL_FX_VCCURR21(2) TPM_AMOUNT
VAL_IDX_PCIndex Valuation in Position Currency TPM_VAL_IDX_PCCURR21(2) TPM_AMOUNT
VAL_IDX_VCIndex Valuation in Valuation Currency TPM_VAL_IDX_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_PCValuation of Cap. Costs, Security, in Position Currency TPM_VAL_CH_TI_PCCURR21(2) TPM_AMOUNT
VAL_CH_TI_VCValuation of Cap. Costs, Security, in Valuation Currency TPM_VAL_CH_TI_VCCURR21(2) TPM_AMOUNT
VAL_CH_TI_IDXCLValuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy TPM_VAL_CH_TI_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_CH_FX_VCValuation of Capitalized Costs, FX, in Valuation Currency TPM_VAL_CH_FX_VCCURR21(2) TPM_AMOUNT
VAL_AAV_FX_VCFX Valuation of Amort.Acquisition Value in Valuation Crcy TPM_VAL_AAV_FX_VCCURR21(2) TPM_AMOUNT
IMPAIRMENT_PCImpairment in Position Currency TPM_IMPAIRMENT_PCCURR21(2) TPM_AMOUNT
IMPAIRMENT_VCImpairment in Valuation Currency TPM_IMPAIRMENT_VCCURR21(2) TPM_AMOUNT
IMPMT_IDX_CLEANImpairment in Position Currency Index-Clean TPM_IMPAIRMENT_IDX_CLEANCURR21(2) TPM_AMOUNT
IMPAIRMENT_FX_VCFX Impairment in Valuation Currency TPM_IMPAIRMENT_FX_VCCURR21(2) TPM_AMOUNT
AMORT_PCAmortization in Position Currency TPM_AMORT_PCCURR21(2) TPM_AMOUNT
AMORT_VCAmortization in Valuation Currency TPM_AMORT_VCCURR21(2) TPM_AMOUNT
AMORT_IDX_CLEANAmortization, Index-Clean, in Position Currency TPM_AMORT_IDX_CLEANCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_PCAmortization of Negotiation Spread in Position Currency TPM_AMORT_NEG_SPREAD_PCCURR21(2) TPM_AMOUNT
AMORT_NEG_SPR_VCAmortization of Negotiation Spread in Valuation Currency TPM_AMORT_NEG_SPREAD_VCCURR21(2) TPM_AMOUNT
AM_NEG_SPR_IDXCLAmortiz. of Negotiation Spread in Position Crcy Index-Clean TPM_AMORT_NEG_SPREAD_IDX_CLEANCURR21(2) TPM_AMOUNT
DISAGIO_PCDiscount/Premium in Position Currency TPM_DISAGIO_PCCURR21(2) TPM_AMOUNT
DISAGIO_VCDiscount/Premium in Valuation Currency TPM_DISAGIO_VCCURR21(2) TPM_AMOUNT
DISAGIO_IDXCLIndex-Clean Discount/Premium in Position Currency TPM_DISAGIO_IDX_CLEANCURR21(2) TPM_AMOUNT
VAL_TI_PC_NPLSecurities Valuation Not Affecting P/L in Position Currency TPM_VAL_TI_PC_NPLCURR21(2) TPM_AMOUNT
VAL_TI_VC_NPLSecurities Valuation Not Affecting P/L in Valuation Currency TPM_VAL_TI_VC_NPLCURR21(2) TPM_AMOUNT
VAL_IT_IDXCL_NPLSecurities Val. Not Affecting P/L in Pos. Crcy Index Clean TPM_VAL_TI_IDXCL_NPLCURR21(2) TPM_AMOUNT
VAL_FX_VC_NPLForex Valuation Not Affecting P/L in Valuation Currency TPM_VAL_FX_VC_NPLCURR21(2) TPM_AMOUNT
VAL_IDX_PC_NPLIndex Valuation Not Affecting P/L in Position Currency TPM_VAL_IDX_PC_NPLCURR21(2) TPM_AMOUNT
VAL_IDX_VC_NPLIndex Valuation Not Affecting P/L in Valuation Currency TPM_VAL_IDX_VC_NPLCURR21(2) TPM_AMOUNT
VAL_CH_TI_PC_NPLSecurity Costs Valuation Not Affecting P/L in Position Crcy TPM_VAL_CH_TI_PC_NPLCURR21(2) TPM_AMOUNT
VAL_CH_TI_VC_NPLSecurity Costs Valuation Not Affecting P/L in Valuation Crcy TPM_VAL_CH_TI_VC_NPLCURR21(2) TPM_AMOUNT
VAL_CHTIIDXCLNPLSecurity Costs Val. Not Affecting P/L in PosCrcy Index Clean TPM_VAL_CH_TI_IDXCL_NPLCURR21(2) TPM_AMOUNT
VAL_CH_FX_VC_NPLForex Costs Valuation Not Affecting P/L in Valuation Crcy TPM_VAL_CH_FX_VC_NPLCURR21(2) TPM_AMOUNT
ACC_INT_PCAccrued Interest in Position Currency TPM_ACC_INTEREST_PCCURR21(2) TPM_AMOUNT
ACC_INT_VCAccrued Interest in Valuation Currency TPM_ACC_INTEREST_VCCURR21(2) TPM_AMOUNT
ACC_INT_IDXCLAccrued Interest in Position Currency Index-Clean TPM_ACC_INTEREST_IDX_CLEANCURR21(2) TPM_AMOUNT
NGSPR_PCNegotiation Spread in Position Currency TPM_NGSPR_PCCURR21(2) TPM_AMOUNT
NGSPR_VCNegotiation Spread in Valuation Currency TPM_NGSPR_VCCURR21(2) TPM_AMOUNT
NGSPR_IDXCLNegotiation Spread Index Clean TPM_NGSPR_IDXCLCURR21(2) TPM_AMOUNT
ACCR_PCAccrual/Deferral in Position Currency TPM_ACCR_PCCURR21(2) TPM_AMOUNT
ACCR_VCAccrual/Deferral in Valuation Currency TPM_ACCR_VCCURR21(2) TPM_AMOUNT
ACCR_IDX_CLEANAccrual/Deferral (1) Index Clean in Position Currency TPM_ACCR_IDX_CLEANCURR21(2) TPM_AMOUNT
ACCR2_PCAccrual/Deferral (2) in Position Currency TPM_ACCR2_PCCURR21(2) TPM_AMOUNT
ACCR2_VCAccrual/Deferral (2) in Valuation Currency TPM_ACCR2_VCCURR21(2) TPM_AMOUNT
ACCR2_IDX_CLEANAccrual/Deferral (2) Index Clean in Position Currency TPM_ACCR2_IDX_CLEANCURR21(2) TPM_AMOUNT
RESET_VALValuation with Reset TPM_TRDT_RESET_VALCHAR1CHAR1
RESET_AMORTAmortization with Reset TPM_TRDT_RESET_AMORTCHAR1CHAR1
RESET_ACCRAccrual/Deferral with Reset TPM_TRDT_RESET_ACCRCHAR1CHAR1
RESET_KEY_DATEKey Date for Reset within Legacy Data Transfer TPM_TRDT_RESET_KEYDATEDATS8DATS
RESET_IMPImpairment with Reset TPM_TRDT_RESET_IMPCHAR1CHAR1
DEAL_NUMBERFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
TRANS_FLGFlag: Legacy Data Transferred TPM_TRDT_TRANS_FLGCHAR1CHAR1
HAMORT_PCHedge Amortization in Position Currency FTI_HAMORT_PCCURR21(2) TPM_AMOUNT
HAMORT_IDXCL_PCHedge Amortization in Position Crcy, Index-Clean FTI_HAMORT_INDX_PCCURR21(2) TPM_AMOUNT
HAMORT_VCHedge Amortization in Valuation Currency FTI_HAMORT_VCCURR21(2) TPM_AMOUNT
HADJ_PCHedge Adjustment in Position Currency FTI_HADJ_PCCURR21(2) TPM_AMOUNT
HADJ_IDXCL_PCHedge Adjustment in Position Currency, Index-Clean FTI_HADJ_INDX_PCCURR21(2) TPM_AMOUNT
HADJ_VCHedge Adjustment in Valuation Currency FTI_HADJ_VCCURR21(2) TPM_AMOUNT
EFF_PCEffective Amount in Position Currency FTI_EFFECTIVE_PCCURR21(2) TPM_AMOUNT
EFF_VCEffective Amount in Valuation Currency FTI_EFFECTIVE_VCCURR21(2) TPM_AMOUNT
EFF_IDXCL_PCEffective Amount in Position Currency, Index Clean FTI_EFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFF_PCIneffective Amount in Position Currency FTI_INEFFECTIVE_PCCURR21(2) TPM_AMOUNT
INEFF_VCIneffective Amount in Valuation Currency FTI_INEFFECTIVE_VCCURR21(2) TPM_AMOUNT
INEFF_IDXCL_PCIneffective Amount in Position Currency, Index Clean FTI_INEFFECTIVE_IDXCL_PCCURR21(2) TPM_AMOUNT
EFFD_PCEffective Amount (Dormant) in Position Currency FTI_EFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
EFFD_VCEffective Amount (Dormant) in Valuation Currency FTI_EFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
EFFD_IDXCL_PCEffective Amount (Dormant) in Position Currency, Index-Clean FTI_EFFECTIVE_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT
INEFFD_PCIneffective Amount (Dormant) in Position Currency FTI_INEFFECTIVE_DORMANT_PCCURR21(2) TPM_AMOUNT
INEFFD_VCIneffective Amount (Dormant) in Valuation Currency FTI_INEFFECTIVE_DORMANT_VCCURR21(2) TPM_AMOUNT
INEFFD_IDXCL_PCIneffective Amount (Dormant) in Position Currency, Index-Cln FTI_INEFF_DORMANT_IDXCL_PCCURR21(2) TPM_AMOUNT
ORIG_VAD_PCOriginal Value Adjustment in Position Currency FTI_ORIG_VAD_PCCURR21(2) TPM_AMOUNT
ORIG_VAD_VCOriginal Value Adjustment in Valuation Currency FTI_ORIG_VAD_VCCURR21(2) TPM_AMOUNT
VAD_GAIN_PCValue Adjustment of Gains in Position Currency FTI_VAD_GAIN_PCCURR21(2) TPM_AMOUNT
VAD_GAIN_VCValue Adjustment of Gains in Valuation Currency FTI_VAD_GAIN_VCCURR21(2) TPM_AMOUNT
VAD_LOSS_PCValue Adjustment of Losses in Position Currency FTI_VAD_LOSS_PCCURR21(2) TPM_AMOUNT
VAD_LOSS_VCValue Adjustment of Losses in Valuation Currency FTI_VAD_LOSS_VCCURR21(2) TPM_AMOUNT

Key field Non-key field



How do I retrieve data from SAP table TRDTT_VADATA_SEC using ABAP code

The following ABAP code Example will allow you to do a basic selection on TRDTT_VADATA_SEC to SELECT all data from the table
DATA: WA_TRDTT_VADATA_SEC TYPE TRDTT_VADATA_SEC.

SELECT SINGLE *
FROM TRDTT_VADATA_SEC
INTO CORRESPONDING FIELDS OF WA_TRDTT_VADATA_SEC
WHERE...

How to access SAP table TRDTT_VADATA_SEC

Within an ECC or HANA version of SAP you can also view further information about TRDTT_VADATA_SEC and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!