TRDTT_VADATA_OTC SAP (Valuation-Area-Dependent Data for MM, FX, OTC Derivatives.) Table details

Dictionary Type: Table
Description: Valuation-Area-Dependent Data for MM, FX, OTC Derivatives.




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




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

TRDTT_VADATA_OTC is a standard SAP Table which is used to store Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. data and is available within R/3 SAP systems depending on the version and release level.

The TRDTT_VADATA_OTC table consists of various fields, each holding specific information or linking keys about Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. 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_OTC 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
DEAL_NUMBERFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
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
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_FX_VCForeign Currency Valuation in Valuation Currency TPM_VAL_FX_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_FX_VCValuation of Capitalized Costs, FX, in Valuation Currency TPM_VAL_CH_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
AMORT_PCAmortization in Position Currency TPM_AMORT_PCCURR21(2) TPM_AMOUNT
AMORT_VCAmortization in Valuation Currency TPM_AMORT_VCCURR21(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_FX_VC_NPLForex Valuation Not Affecting P/L in Valuation Currency TPM_VAL_FX_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_CH_FX_VC_NPLForex Costs Valuation Not Affecting P/L in Valuation Crcy TPM_VAL_CH_FX_VC_NPLCURR21(2) TPM_AMOUNT
VAL_PURCH_VCPurchase Currency Valuation in Valuation Currency TPM_VAL_PURCH_VCCURR21(2) TPM_AMOUNT
VAL_SALE_VCSale Currency Valuation in Valuation Currency TPM_VAL_SALE_VCCURR21(2) TPM_AMOUNT
VAL_MS_DEF_PCMargin/Swap Deferral in Position Currency TPM_VAL_MS_DEF_PCCURR21(2) TPM_AMOUNT
VAL_MS_DEF_VCMargin/Swap Deferral in Valuation Currency TPM_VAL_MS_DEF_VCCURR21(2) TPM_AMOUNT
VAL_SWAP_VCSwap Accrual/Deferral in Valuation Currency TPM_VAL_SWAP_VCCURR21(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
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
RESET_VALValuation with Reset TPM_TRDT_RESET_VALCHAR1CHAR1
RESET_ACCRAccrual/Deferral with Reset TPM_TRDT_RESET_ACCRCHAR1CHAR1
RESET_KEY_DATEKey Date for Reset within Legacy Data Transfer TPM_TRDT_RESET_KEYDATEDATS8DATS
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
TRANS_FLGFlag: Legacy Data Transferred TPM_TRDT_TRANS_FLGCHAR1CHAR1
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
INT_INCOME_PCInterest Income in Position Currency FTI_INT_INCOME_PCCURR21(2) TPM_AMOUNT
INT_INCOME_VCInterest Income in Valuation Currency FTI_INT_INCOME_VCCURR21(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
RESET_AMORTAmortization with Reset TPM_TRDT_RESET_AMORTCHAR1CHAR1

Key field Non-key field



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

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

SELECT SINGLE *
FROM TRDTT_VADATA_OTC
INTO CORRESPONDING FIELDS OF WA_TRDTT_VADATA_OTC
WHERE...

How to access SAP table TRDTT_VADATA_OTC

Within an ECC or HANA version of SAP you can also view further information about TRDTT_VADATA_OTC 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!