SAP ABAP Table TRDTT_VADATA_SEC (Valuation-Area-Dependent 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_VADATA_SEC	Table Relationship Diagram
Short Description	Valuation-Area-Dependent 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	VALUATION_AREA	☑	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	*
6	SECURITY_ID	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
7	SECURITY_ACCOUNT	☑	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
8	PORTFOLIO	☑	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
9	POSNR	☑	TPM_TRDT_POSNR	NUMC08	NUMC	8	0	Item Number Legacy Data Transfer
10	POSITION_CURR	☐	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency	TCURC
11	VALUATION_CURR	☐	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency	TCURC
12	ACTIVE_PASSIVE	☐	TPM_ACTIVE_PASSIVE	TPM_ACTIVE_PASSIVE	CHAR	1	0	Indicator: Assets/Liabilities Position
13	VAL_TI_PC	☐	TPM_VAL_TI_PC	TPM_AMOUNT	CURR	21	2	Security Valuation in Position Currency
14	VAL_TI_VC	☐	TPM_VAL_TI_VC	TPM_AMOUNT	CURR	21	2	Security Valuation in Valuation Currency
15	VAL_TI_IDX_CLEAN	☐	TPM_VAL_TI_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Security Valuation, Index-Clean, in Position Currency
16	VAL_FX_VC	☐	TPM_VAL_FX_VC	TPM_AMOUNT	CURR	21	2	Foreign Currency Valuation in Valuation Currency
17	VAL_IDX_PC	☐	TPM_VAL_IDX_PC	TPM_AMOUNT	CURR	21	2	Index Valuation in Position Currency
18	VAL_IDX_VC	☐	TPM_VAL_IDX_VC	TPM_AMOUNT	CURR	21	2	Index Valuation in Valuation Currency
19	VAL_CH_TI_PC	☐	TPM_VAL_CH_TI_PC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Position Currency
20	VAL_CH_TI_VC	☐	TPM_VAL_CH_TI_VC	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, in Valuation Currency
21	VAL_CH_TI_IDXCL	☐	TPM_VAL_CH_TI_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
22	VAL_CH_FX_VC	☐	TPM_VAL_CH_FX_VC	TPM_AMOUNT	CURR	21	2	Valuation of Capitalized Costs, FX, in Valuation Currency
23	IMPAIRMENT_PC	☐	TPM_IMPAIRMENT_PC	TPM_AMOUNT	CURR	21	2	Impairment in Position Currency
24	IMPAIRMENT_VC	☐	TPM_IMPAIRMENT_VC	TPM_AMOUNT	CURR	21	2	Impairment in Valuation Currency
25	IMPMT_IDX_CLEAN	☐	TPM_IMPAIRMENT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Impairment in Position Currency Index-Clean
26	AMORT_PC	☐	TPM_AMORT_PC	TPM_AMOUNT	CURR	21	2	Amortization in Position Currency
27	AMORT_VC	☐	TPM_AMORT_VC	TPM_AMOUNT	CURR	21	2	Amortization in Valuation Currency
28	AMORT_IDX_CLEAN	☐	TPM_AMORT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amortization, Index-Clean, in Position Currency
29	AMORT_NEG_SPR_PC	☐	TPM_AMORT_NEG_SPREAD_PC	TPM_AMOUNT	CURR	21	2	Amortization of Negotiation Spread in Position Currency
30	AMORT_NEG_SPR_VC	☐	TPM_AMORT_NEG_SPREAD_VC	TPM_AMOUNT	CURR	21	2	Amortization of Negotiation Spread in Valuation Currency
31	AM_NEG_SPR_IDXCL	☐	TPM_AMORT_NEG_SPREAD_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amortiz. of Negotiation Spread in Position Crcy Index-Clean
32	DISAGIO_PC	☐	TPM_DISAGIO_PC	TPM_AMOUNT	CURR	21	2	Discount/Premium in Position Currency
33	DISAGIO_VC	☐	TPM_DISAGIO_VC	TPM_AMOUNT	CURR	21	2	Discount/Premium in Valuation Currency
34	DISAGIO_IDXCL	☐	TPM_DISAGIO_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Index-Clean Discount/Premium in Position Currency
35	VAL_TI_PC_NPL	☐	TPM_VAL_TI_PC_NPL	TPM_AMOUNT	CURR	21	2	Securities Valuation Not Affecting P/L in Position Currency
36	VAL_TI_VC_NPL	☐	TPM_VAL_TI_VC_NPL	TPM_AMOUNT	CURR	21	2	Securities Valuation Not Affecting P/L in Valuation Currency
37	VAL_IT_IDXCL_NPL	☐	TPM_VAL_TI_IDXCL_NPL	TPM_AMOUNT	CURR	21	2	Securities Val. Not Affecting P/L in Pos. Crcy Index Clean
38	VAL_FX_VC_NPL	☐	TPM_VAL_FX_VC_NPL	TPM_AMOUNT	CURR	21	2	Forex Valuation Not Affecting P/L in Valuation Currency
39	VAL_IDX_PC_NPL	☐	TPM_VAL_IDX_PC_NPL	TPM_AMOUNT	CURR	21	2	Index Valuation Not Affecting P/L in Position Currency
40	VAL_IDX_VC_NPL	☐	TPM_VAL_IDX_VC_NPL	TPM_AMOUNT	CURR	21	2	Index Valuation Not Affecting P/L in Valuation Currency
41	VAL_CH_TI_PC_NPL	☐	TPM_VAL_CH_TI_PC_NPL	TPM_AMOUNT	CURR	21	2	Security Costs Valuation Not Affecting P/L in Position Crcy
42	VAL_CH_TI_VC_NPL	☐	TPM_VAL_CH_TI_VC_NPL	TPM_AMOUNT	CURR	21	2	Security Costs Valuation Not Affecting P/L in Valuation Crcy
43	VAL_CHTIIDXCLNPL	☐	TPM_VAL_CH_TI_IDXCL_NPL	TPM_AMOUNT	CURR	21	2	Security Costs Val. Not Affecting P/L in PosCrcy Index Clean
44	VAL_CH_FX_VC_NPL	☐	TPM_VAL_CH_FX_VC_NPL	TPM_AMOUNT	CURR	21	2	Forex Costs Valuation Not Affecting P/L in Valuation Crcy
45	ACC_INT_PC	☐	TPM_ACC_INTEREST_PC	TPM_AMOUNT	CURR	21	2	Accrued Interest in Position Currency
46	ACC_INT_VC	☐	TPM_ACC_INTEREST_VC	TPM_AMOUNT	CURR	21	2	Accrued Interest in Valuation Currency
47	ACC_INT_IDXCL	☐	TPM_ACC_INTEREST_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Accrued Interest in Position Currency Index-Clean
48	NGSPR_PC	☐	TPM_NGSPR_PC	TPM_AMOUNT	CURR	21	2	Negotiation Spread in Position Currency
49	NGSPR_VC	☐	TPM_NGSPR_VC	TPM_AMOUNT	CURR	21	2	Negotiation Spread in Valuation Currency
50	NGSPR_IDXCL	☐	TPM_NGSPR_IDXCL	TPM_AMOUNT	CURR	21	2	Negotiation Spread Index Clean
51	ACCR_PC	☐	TPM_ACCR_PC	TPM_AMOUNT	CURR	21	2	Accrual/Deferral in Position Currency
52	ACCR_VC	☐	TPM_ACCR_VC	TPM_AMOUNT	CURR	21	2	Accrual/Deferral in Valuation Currency
53	ACCR_IDX_CLEAN	☐	TPM_ACCR_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Accrual/Deferral (1) Index Clean in Position Currency
54	RESET_VAL	☐	TPM_TRDT_RESET_VAL	CHAR1	CHAR	1	0	Valuation with Reset
55	RESET_AMORT	☐	TPM_TRDT_RESET_AMORT	CHAR1	CHAR	1	0	Amortization with Reset
56	RESET_ACCR	☐	TPM_TRDT_RESET_ACCR	CHAR1	CHAR	1	0	Accrual/Deferral with Reset
57	RESET_KEY_DATE	☐	TPM_TRDT_RESET_KEYDATE	DATS	DATS	8	0	Key Date for Reset within Legacy Data Transfer
58	DEAL_NUMBER	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
59	BUSTRANSID	☐	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
60	TRANS_FLG	☐	TPM_TRDT_TRANS_FLG	CHAR1	CHAR	1	0	Flag: Legacy Data Transferred

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TRDTT_VADATA_SEC	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS
2	TRDTT_VADATA_SEC	POSITION_CURR	TCURC	WAERS
3	TRDTT_VADATA_SEC	VALUATION_CURR	TCURC	WAERS

History

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