TRDTT_DATA_SEC

Valuation-Area-Independent Data for Securities | #masterdata | Component: Transaction Manager
Column Name Description
MANDT Client
KEY_DATE Position Value Date
COMPANY_CODE Company Code
COM_VAL_CLASS FK General Valuation Class
SECURITY_ID Security Class ID Number
SECURITY_ACCOUNT Securities Account
PORTFOLIO Portfolio
FUND Fund
GRANT_NBR Grant
POSNR Item Number Legacy Data Transfer
Column Name Description
💲 Nominal Currency (NOMINAL_CURR):
NOMINAL_AMT Nominal Amount
NOMINAL_ORG_AMT Original Nominal Amount in Position Currency
💲 Position Currency (POSITION_CURR):
PURCH_PC Purchase Value in Position Currency
PURCH_IDX_CLEAN Purchase Value, Index-Clean, in Position Currency
CHARGE_PC Costs in Position Currency
CHARGE_IDX_CLEAN Costs, Index-Clean, in Position Currency
REPAYMENT_PC Cumulative Repayment in Position Currency
REPAYMENT_IDX_CL Cumulative Repayment in Position Currency Index-Clean
COMP1_PC Component 1 in Position Currency
COMP1_IDX_CLEAN Component 1 in Position Currency Index Clean
COMP2_PC Component 2 in Position Currency
COMP2_IDX_CLEAN Component 2 in Position Currency Index Clean
COMP3_PC Component 3 in Position Currency
COMP3_IDX_CLEAN Component 3 in Position Currency Index Clean
COMP4_PC Component 4 in Position Currency
COMP4_IDX_CLEAN Component 4 in Position Currency Index Clean
COMP5_PC Component 5 in Position Currency
COMP5_IDX_CLEAN Component 5 in Position Currency Index Clean
💲 Local Currency (LOCAL_CURR):
PURCH_LC Purchase Value in Local Currency
CHARGE_LC Costs in Local Currency
REPAYMENT_LC Cumulative Repayment in Local Currency
COMP1_LC Component 1 in Local Currency
COMP2_LC Component 2 in Local Currency
COMP3_LC Component 3 in Local Currency
COMP4_LC Component 4 in Local Currency
COMP5_LC Component 5 in Local Currency
Column Name Description
Column Name Description
KEY_DATE Position Value Date
CALCULATION_DATE Calculation Date
ORIGIN_DATE Original Position Acquisition Date
Column Name Description
ACTIVE_PASSIVE Indicator: Assets/Liabilities Position Show values
COUPON_SIGN Coupon ID for Interest and Accrued Interest Calculation Show values
Column Name Description Domain name
UNITS Units TPM_UNITS
BUSTRANSID Identifier of the Distributor Business Transaction SYSUUID
TRANS_FLG Flag: Legacy Data Transferred CHAR1
Master Data Relations Join Conditions
General Valuation Class
  • General Valuation Class
  • Client
Local Currency
  • TRDTT_DATA_SEC.MANDT == TCURC.MANDT
  • TRDTT_DATA_SEC.LOCAL_CURR == TCURC.WAERS
Nominal Currency
  • TRDTT_DATA_SEC.MANDT == TCURC.MANDT
  • TRDTT_DATA_SEC.NOMINAL_CURR == TCURC.WAERS
Position Currency
  • TRDTT_DATA_SEC.MANDT == TCURC.MANDT
  • TRDTT_DATA_SEC.POSITION_CURR == TCURC.WAERS