TRDTS_DATA SAP (Legacy Data Transfer Data) Structure details

Dictionary Type: Structure
Description: Legacy Data Transfer Data




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




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

TRDTS_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Legacy Data Transfer Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TRDTS_DATA TYPE TRDTS_DATA.

The TRDTS_DATA table consists of various fields, each holding specific information or linking keys about Legacy Data Transfer Data data available in SAP. These include DATA_EXEC (Processing Status of Legacy Data Transfer), BUSTRANSID (Identifier of the Distributor Business Transaction), RESET_BUSTRANSID (Identifier of the Distributor Business Transaction), TRANS_FLG (Flag: Legacy Data Transferred).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP TRDTS_DATA structure 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
DATA_SOURCELegacy Data Transfer Data Source TPM_TRDT_DATA_SOURCECHAR1TPM_TRDT_DATA_SOURCE
DATA_EXECProcessing Status of Legacy Data Transfer TPM_TRDT_DATA_EXECCHAR1TPM_TRDT_DATA_EXEC
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
RESET_BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
TRANS_FLGFlag: Legacy Data Transferred TPM_TRDT_TRANS_FLGCHAR1CHAR1
PRODUCT_TYPEProduct Type VVSARTCHAR3Assigned to domainVVSARTSANVVSART_APPL_BAS
PRODUCT_CATEGORYProduct Category SANLFNUMC3Assigned to domainVVSANLF
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
KEY_DATEPosition Value Date TPM_POSITION_DATEDATS8TPM_POSITION_DATE
COMPANY_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
COM_VAL_CLASSGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4Assigned to domainTPM_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
DEAL_NUMBERFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
FUNDFund FM_FUNDCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
POSITION_ACCOUNTFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10Assigned to domainTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
FLAG_LONG_SHORTIndicator: Long or Short Position TPM_FLAG_LONG_SHORTCHAR1TPM_FLAG_LONG_SHORT
POSNRItem Number Legacy Data Transfer TPM_TRDT_POSNRNUMC8NUMC08
DEAL_NUMBER_LOTFinancial Transaction TB_RFHACHAR13Assigned to domainALPHAT_RFHAFANVTBA
POSITION_CURRPosition Currency TPM_POSITION_CURRCUKY5Assigned to domainWAERS
LOCAL_CURRLocal Currency TPM_LOCAL_CURRCUKY5Assigned to domainWAERS
VALUATION_CURRValuation Currency TPM_VALUATION_CURRCUKY5Assigned to domainWAERS
ACTIVE_PASSIVEIndicator: Assets/Liabilities Position TPM_ACTIVE_PASSIVECHAR1TPM_ACTIVE_PASSIVE
UNITSUnits TPM_UNITSDEC22(6) TPM_UNITS
NOMINAL_AMTNominal Amount TPM_NOMINAL_AMTCURR21(2) TPM_AMOUNT
NOMINAL_ORG_AMTOriginal Nominal Amount in Position Currency TPM_NOMINAL_ORG_AMTCURR21(2) TPM_AMOUNT
NOMINAL_CURRNominal Currency TPM_NOMINAL_CURRCUKY5Assigned to domainWAERS
ASSG_UNITSUnits TPM_UNITSDEC22(6) TPM_UNITS
ASSG_NOM_AMTNominal Amount TPM_NOMINAL_AMTCURR21(2) TPM_AMOUNT
ASSG_NOM_ORG_AMTOriginal Nominal Amount in Position Currency TPM_NOMINAL_ORG_AMTCURR21(2) TPM_AMOUNT
PURCH_PCPurchase Value in Position Currency TPM_PURCH_PCCURR21(2) TPM_AMOUNT
PURCH_LCPurchase Value in Local Currency TPM_PURCH_LCCURR21(2) TPM_AMOUNT
PURCH_IDX_CLEANPurchase Value, Index-Clean, in Position Currency TPM_PURCH_IDX_CLEANCURR21(2) TPM_AMOUNT
CHARGE_PCCosts in Position Currency TPM_CHARGE_PCCURR21(2) TPM_AMOUNT
CHARGE_LCCosts in Local Currency TPM_CHARGE_LCCURR21(2) TPM_AMOUNT
CHARGE_IDX_CLEANCosts, Index-Clean, in Position Currency TPM_CHARGE_IDX_CLEANCURR21(2) TPM_AMOUNT
REPAYMENT_PCCumulative Repayment in Position Currency TPM_REPAYMENT_PCCURR21(2) TPM_AMOUNT
REPAYMENT_LCCumulative Repayment in Local Currency TPM_REPAYMENT_LCCURR21(2) TPM_AMOUNT
REPAYMENT_IDX_CLEANCumulative Repayment in Position Currency Index-Clean TPM_REPAYMENT_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP1_PCComponent 1 in Position Currency TPM_COMP1_PCCURR21(2) TPM_AMOUNT
COMP1_LCComponent 1 in Local Currency TPM_COMP1_LCCURR21(2) TPM_AMOUNT
COMP1_IDX_CLEANComponent 1 in Position Currency Index Clean TPM_COMP1_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP2_PCComponent 2 in Position Currency TPM_COMP2_PCCURR21(2) TPM_AMOUNT
COMP2_LCComponent 2 in Local Currency TPM_COMP2_LCCURR21(2) TPM_AMOUNT
COMP2_IDX_CLEANComponent 2 in Position Currency Index Clean TPM_COMP2_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP3_PCComponent 3 in Position Currency TPM_COMP3_PCCURR21(2) TPM_AMOUNT
COMP3_LCComponent 3 in Local Currency TPM_COMP3_LCCURR21(2) TPM_AMOUNT
COMP3_IDX_CLEANComponent 3 in Position Currency Index Clean TPM_COMP3_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP4_PCComponent 4 in Position Currency TPM_COMP4_PCCURR21(2) TPM_AMOUNT
COMP4_LCComponent 4 in Local Currency TPM_COMP4_LCCURR21(2) TPM_AMOUNT
COMP4_IDX_CLEANComponent 4 in Position Currency Index Clean TPM_COMP4_IDX_CLEANCURR21(2) TPM_AMOUNT
COMP5_PCComponent 5 in Position Currency TPM_COMP5_PCCURR21(2) TPM_AMOUNT
COMP5_LCComponent 5 in Local Currency TPM_COMP5_LCCURR21(2) TPM_AMOUNT
COMP5_IDX_CLEANComponent 5 in Position Currency Index Clean TPM_COMP5_IDX_CLEANCURR21(2) TPM_AMOUNT
CALCULATION_DATECalculation Date DVALUTDATS8DATUM
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
IMPAIRMENT_PCImpairment in Position Currency TPM_IMPAIRMENT_PCCURR21(2) TPM_AMOUNT
IMPAIRMENT_VCImpairment in Valuation Currency TPM_IMPAIRMENT_VCCURR21(2) TPM_AMOUNT
IMPAIRMENT_FX_VCFX Impairment in Valuation Currency TPM_IMPAIRMENT_FX_VCCURR21(2) TPM_AMOUNT
IMPMT_IDX_CLEANImpairment in Position Currency Index-Clean TPM_IMPAIRMENT_IDX_CLEANCURR21(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
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
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
IGT_DATA 0
VAL_AAV_FX_VCFX Valuation of Amort.Acquisition Value in Valuation Crcy TPM_VAL_AAV_FX_VCCURR21(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
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
HITEM_NUMBERHedged Item Number TPM_HITEM_NUMBERCHAR10ALPHATPM_HITEM_NUMBER
HINST_NUMBERHedging Instrument Number TPM_HINST_NUMBERCHAR10ALPHATPM_HINST_NUMBER
FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PURCH_VCPurchase Value in Valuation Currency TPM_PURCH_VCCURR21(2) TPM_AMOUNT
CHARGE_VCCosts in Valuation Currency TPM_CHARGE_VCCURR21(2) TPM_AMOUNT
REPAYMENT_VCCumulative Repayment in Valuation Currency TPM_REPAYMENT_VCCURR21(2) TPM_AMOUNT
HREL_NUMBERHedging Relationship Number (External/Internal) TPM_HREL_NUMBERCHAR10ALPHATPM_HREL_NUMBER
HREL_FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
HREL_RISK_CURRRisk Currency TPM_RISK_CURRENCYCUKY5Assigned to domainWAERS
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
COUPON_SIGNCoupon ID for Interest and Accrued Interest Calculation TPM_COUPON_SIGNCHAR1VVSCOUPON
ORIGIN_DATEOriginal Position Acquisition Date TPM_ORIGIN_DATEDATS8TPM_ORIGIN_DATE
VTRQ_DATA 0

Key field Non-key field



How do I retrieve data from SAP structure TRDTS_DATA using ABAP code?

As TRDTS_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TRDTS_DATA as there is no data to select.

How to access SAP table TRDTS_DATA

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