SAP ABAP Table TRDTT_DATA_SEC (Valuation-Area-Independent Data for Securities)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_DATA_TRANSFER (Package) Legacy Data Transfer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TRDTT_DATA_SEC	Table Relationship Diagram
Short Description	Valuation-Area-Independent Data for Securities

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	KEY_DATE	☑	TPM_POSITION_DATE	TPM_POSITION_DATE	DATS	8	0	Position Value Date
3	COMPANY_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
4	COM_VAL_CLASS	☑	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
5	SECURITY_ID	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
6	SECURITY_ACCOUNT	☑	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
7	PORTFOLIO	☑	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
8	POSNR	☑	TPM_TRDT_POSNR	NUMC08	NUMC	8	0	Item Number Legacy Data Transfer
9	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	TCURC
10	LOCAL_CURR	☐	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency	TCURC
11	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
12	UNITS	☐	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
13	NOMINAL_AMT	☐	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
14	NOMINAL_ORG_AMT	☐	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
15	NOMINAL_CURR	☐	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency	TCURC
16	PURCH_PC	☐	TPM_PURCH_PC	TPM_AMOUNT	CURR	21	2	Purchase Value in Position Currency
17	PURCH_LC	☐	TPM_PURCH_LC	TPM_AMOUNT	CURR	21	2	Purchase Value in Local Currency
18	PURCH_IDX_CLEAN	☐	TPM_PURCH_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Purchase Value, Index-Clean, in Position Currency
19	CHARGE_PC	☐	TPM_CHARGE_PC	TPM_AMOUNT	CURR	21	2	Costs in Position Currency
20	CHARGE_LC	☐	TPM_CHARGE_LC	TPM_AMOUNT	CURR	21	2	Costs in Local Currency
21	CHARGE_IDX_CLEAN	☐	TPM_CHARGE_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Costs, Index-Clean, in Position Currency
22	REPAYMENT_PC	☐	TPM_REPAYMENT_PC	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Position Currency
23	REPAYMENT_LC	☐	TPM_REPAYMENT_LC	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Local Currency
24	REPAYMENT_IDX_CL	☐	TPM_REPAYMENT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Cumulative Repayment in Position Currency Index-Clean
25	COMP1_PC	☐	TPM_COMP1_PC	TPM_AMOUNT	CURR	21	2	Component 1 in Position Currency
26	COMP1_LC	☐	TPM_COMP1_LC	TPM_AMOUNT	CURR	21	2	Component 1 in Local Currency
27	COMP1_IDX_CLEAN	☐	TPM_COMP1_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Component 1 in Position Currency Index Clean
28	COMP2_PC	☐	TPM_COMP2_PC	TPM_AMOUNT	CURR	21	2	Component 2 in Position Currency
29	COMP2_LC	☐	TPM_COMP2_LC	TPM_AMOUNT	CURR	21	2	Component 2 in Local Currency
30	COMP2_IDX_CLEAN	☐	TPM_COMP2_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Component 2 in Position Currency Index Clean
31	COMP3_PC	☐	TPM_COMP3_PC	TPM_AMOUNT	CURR	21	2	Component 3 in Position Currency
32	COMP3_LC	☐	TPM_COMP3_LC	TPM_AMOUNT	CURR	21	2	Component 3 in Local Currency
33	COMP3_IDX_CLEAN	☐	TPM_COMP3_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Component 3 in Position Currency Index Clean
34	COMP4_PC	☐	TPM_COMP4_PC	TPM_AMOUNT	CURR	21	2	Component 4 in Position Currency
35	COMP4_LC	☐	TPM_COMP4_LC	TPM_AMOUNT	CURR	21	2	Component 4 in Local Currency
36	COMP4_IDX_CLEAN	☐	TPM_COMP4_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Component 4 in Position Currency Index Clean
37	COMP5_PC	☐	TPM_COMP5_PC	TPM_AMOUNT	CURR	21	2	Component 5 in Position Currency
38	COMP5_LC	☐	TPM_COMP5_LC	TPM_AMOUNT	CURR	21	2	Component 5 in Local Currency
39	COMP5_IDX_CLEAN	☐	TPM_COMP5_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Component 5 in Position Currency Index Clean
40	CALCULATION_DATE	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
41	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
42	TRANS_FLG	☐	TPM_TRDT_TRANS_FLG	CHAR1	CHAR	1	0	Flag: Legacy Data Transferred
43	COUPON_SIGN	☐	TPM_COUPON_SIGN	VVSCOUPON	CHAR	1	0	Coupon ID for Interest and Accrued Interest Calculation
44	ORIGIN_DATE	☐	TPM_ORIGIN_DATE	TPM_ORIGIN_DATE	DATS	8	0	Original Position Acquisition Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRDTT_DATA_SEC	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
2	TRDTT_DATA_SEC	LOCAL_CURR	TCURC	WAERS
3	TRDTT_DATA_SEC	NOMINAL_CURR	TCURC	WAERS
4	TRDTT_DATA_SEC	POSITION_CURR	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	500