SAP ABAP Table VTVDETM_WP (Securities: Characteristics for Cumulative Values)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
     ⤷ FTI (Package) Application development R/3 Treasury information system

Basic Data

Table Category	INTTAB	Structure
Structure	VTVDETM_WP	Table Relationship Diagram
Short Description	Securities: Characteristics for Cumulative Values

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Treasury: Non-Cumulative Values Sec.: Charact. Trans./Act.
2	.INCLUDE	☐				0	0	Fixed characteristics in Treasury
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
6	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
7	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
8	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
10	RANL	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
11	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
12	RLDEPO	☐	VRLDEPO	RLDEPO	CHAR	10	0	Securities Account	TWD01
13	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
14	BUCHST_BSE	☐	BUCHST_BSE	BUCHST	CHAR	1	0	Posting status for position determination (securities)
15	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
16	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
17	NORDER	☐	NORDER	NUM8	NUMC	8	0	Order Number
18	LOT_ID	☐	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
19	DLOTGENERATION	☐	DLOTGENERATION	DATUM	DATS	8	0	Date On Which Lot Was Generated
20	TLOTGENERATION	☐	TLOTGENERATION	UZEIT	TIMS	6	0	Lot Generation Time
21	LOTGENERATION_USER	☐	FTI_LOTGENERATIONUSER	SYCHAR12	CHAR	12	0	Lot Entered By
22	LOTGENERATION_BUSTRANSCAT	☐	FTI_LOTGENERATION_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category Which Generated the Lot	TRDTS_BT_CAT
23	RKONTRA	☐	RKONTRA_NEW	BU_PARTNER	CHAR	10	0	Reference to Counterparty	BUT000
24	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
25	.INCLUDE	☐				0	0	Treasury: Commitment Partner
26	PARTNR	☐	FTI_LDB_RISK_COUNTERPARTY	BU_PARTNER	CHAR	10	0	Partner with Whom Commitment Exists	BUT000
27	.INCLUDE	☐				0	0	Treasury: Partner Attributes
28	TYPE	☐	BP_TYPE_NEW	BU_TYPE	CHAR	1	0	Business Partner Category
29	ISTYPE	☐	BU_ISTYPE	BU_ISTYPE	CHAR	4	0	Industry System	TB038
30	IND_SECTOR	☐	BU_IND_SECTOR	BU_INDSECTOR	CHAR	10	0	Industry	TB038A
31	CNTRY_COMP	☐	FTI_LANDBP	LAND1	CHAR	3	0	Country of Registered Office of Business Partner	T005
32	LEGAL_ENTY	☐	BP_LEG_ETY_NEW	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
33	LEGAL_ORG	☐	BU_LEGAL_ORG_NEW	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	TB032
34	NATION	☐	BP_CNTR_N	LAND1	CHAR	3	0	Nationality	T005
35	STATE	☐	BP_CNTR_ST	LAND1	CHAR	3	0	Citizenship	T005
36	GROUP_ID	☐	BU_GRP_ID_NEW	BU_GROUP	CHAR	4	0	Business Partner Grouping	TB001
37	GROUP_D	☐	BP_GROUP_D	BP_GROUP_D	CHAR	4	0	Target Group	TP13
38	STAFF_GRP	☐	BP_STAFF_G	BP_STAFF_G	CHAR	4	0	Employee Group	TP05
39	COMP_RE	☐	BP_COMP_RE	BP_COMP_RE	CHAR	1	0	Organization Relationship
40	.INCLUDE	☐				0	0	Business partner credit standing data
41	SOLVNCY	☐	BP_SOLVNCY	BP_SOLVNCY	CHAR	1	0	Credit Standing
42	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
43	SOL_INS	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
44	SOL_INF	☐	BP_SOL_INF	BP_SOL_INF	CHAR	1	0	Status of Credit Standing Information
45	SOL_I_D	☐	BP_SOL_I_D	DATUM	DATS	8	0	Date of Credit Standing Information
46	.INCLUDE	☐				0	0	TR: Class Information for Drilldown Reporting (Flow)
47	.INCLUDE	☐				0	0	Treasury: Class info for drill-down reporting
48	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
49	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
50	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
51	ALWPKL	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
52	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
53	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
54	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
55	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
56	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
57	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
58	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
59	SOL_INS_RANL	☐	FTI_SOL_INS_RANL	BP_SOL_INS	CHAR	4	0	Institut Supplying Credit Rating Information for Secur. ID	TP07
60	RATING_RANL	☐	BP_RATING_RANL	BP_RATING	CHAR	3	0	Rating for Securities ID Number/OTC Transaction	TP06
61	KBNEWE_E	☐	FTI_VVBNEWE_E	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
62	KZAHLAKT_E	☐	FTI_KZAHLAKT_E	DEC3_7	DEC	10	7	Pay-in rate
63	.INCLUDE	☐				0	0	Treasury: Cumulative Values: Characteristics Trans./Activity
64	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
65	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
66	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
67	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
68	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
69	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
70	PERIO	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
71	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
72	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
73	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
74	JFDBUC	☐	FTI_FDBUC	FTI_FDBUC	CHAR	1	0	Relevance to CM
75	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
76	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
77	BANKK_HB	☐	FTI_BANKK	BANKK	CHAR	15	0	Bank key of house bank
78	BANKN_HB	☐	FTI_BANKN	BANKN	CHAR	18	0	Bank account number of house bank
79	BANKK_BP	☐	FTI_BANKKP	BANKK	CHAR	15	0	Bank key of business partner bank
80	BANKN_BP	☐	FTI_BANKNP	BANKN	CHAR	18	0	Bank account number of business partner
81	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
82	JAHR	☐	TB_JAHR	GJAHR	NUMC	4	0	Calendar year
83	MONAT	☐	TB_MONAT	TB_MONAT	NUMC	2	0	Calendar month
84	WOCHE	☐	FTI_WOCHE	NUMC2	NUMC	2	0	Calendar Week
85	MONAT_JAHR	☐	FTI_MONTH_YEAR	MCPERIOD	NUMC	6	0	Calendar Month/Year
86	WOCHE_JAHR	☐	FTI_WEEK_YEAR	MCPERIOD	NUMC	6	0	Calendar Week/Year
87	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
88	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
89	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
90	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
91	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
92	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
93	GL_ACCOUNT_D	☐	FTI_GLACC_D	SAKNR	CHAR	10	0	Number of G/L Account: Debit	*
94	GL_ACCOUNT_C	☐	FTI_GLACC_C	SAKNR	CHAR	10	0	Number of G/L Account: Credit	*
95	DBESTAND	☐	DBESTAND	DATUM	DATS	8	0	Position value date
96	DORDER	☐	DORDER	DATUM	DATS	8	0	Order day
97	DDISPO	☐	DDISPO	DATUM	DATS	8	0	Payment Date
98	DSCHLUSS	☐	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
99	BUCHST	☐	BUCHST_CFM	BUCHST_CFM	CHAR	1	0	Posting Status of Flow for CFM (Operative Only)
100	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
101	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
102	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
103	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
104	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
105	PAYIND	☐	TB_SPAYIND	T_SPAYIND	CHAR	1	0	Payment Status of Flows
106	GSVGANG	☐	GSVGANG	GSVGANG	NUMC	3	0	TR transaction activity for securities
107	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
108	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
109	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
110	KMNR	☐	KMNR	VKMNR	CHAR	13	0	Corporate Action Number	VWKMKO

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETM_WP	ALWPKL	TW22	ALWPKL
2	VTVDETM_WP	BUKRS	T001	BUKRS
3	VTVDETM_WP	CNTRY_COMP	T005	LAND1
4	VTVDETM_WP	GROUP_D	TP13	GROUP_D
5	VTVDETM_WP	GROUP_ID	TB001	BU_GROUP
6	VTVDETM_WP	GSART	TZPA	GSART
7	VTVDETM_WP	HKONT	SKB1	SAKNR
8	VTVDETM_WP	IND_SECTOR	TB038A	IND_SECTOR
9	VTVDETM_WP	ISTYPE	TB038	ISTYPE
10	VTVDETM_WP	KMNR	VWKMKO	KMNR
11	VTVDETM_WP	LAND1	T005	LAND1
12	VTVDETM_WP	LEGAL_ENTY	TB019	LEGAL_ENTY
13	VTVDETM_WP	LEGAL_ORG	TB032	LEGAL_ORG
14	VTVDETM_WP	LOTGENERATION_BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT
15	VTVDETM_WP	MANDT	T000	MANDT		C	CN
16	VTVDETM_WP	NATION	T005	LAND1
17	VTVDETM_WP	PARTNR	BUT000	PARTNER
18	VTVDETM_WP	PRKEY	PAYRQ	KEYNO		C	CN
19	VTVDETM_WP	RAHABKI	T012	HBKID
20	VTVDETM_WP	RAHKTID	T012K	HKTID
21	VTVDETM_WP	RANL	VWPANLA	RANL
22	VTVDETM_WP	RATING	TP06	RATING
23	VTVDETM_WP	RATING_RANL	TP06	RATING
24	VTVDETM_WP	RDEALER	TZDEA	RDEALER
25	VTVDETM_WP	RFHA	VTBFHA	RFHA
26	VTVDETM_WP	RHANDPL	TWH01	RHANDPL
27	VTVDETM_WP	RKONTRA	BUT000	PARTNER
28	VTVDETM_WP	RLDEPO	TWD01	RLDEPO
29	VTVDETM_WP	RPORTB	TWPOB	RPORTB		1	CN
30	VTVDETM_WP	RPZAHL	BUT000	PARTNER
31	VTVDETM_WP	RREFKONT	T037S	RREFKONT		1	CN
32	VTVDETM_WP	SANLF	TZAF	SANLF
33	VTVDETM_WP	SARTBET	TW02	SARTBET
34	VTVDETM_WP	SBEWART	TZB0A	SBEWART
35	VTVDETM_WP	SBILK	TW11	SBILK
36	VTVDETM_WP	SFHAART	AT10	SFHAART
37	VTVDETM_WP	SFOTY	TW21	SFOTY
38	VTVDETM_WP	SOL_INS	TP07	SOL_INS
39	VTVDETM_WP	SOL_INS_RANL	TP07	SOL_INS
40	VTVDETM_WP	STAFF_GRP	TP05	STAFF_GRP
41	VTVDETM_WP	STATE	T005	LAND1
42	VTVDETM_WP	SWERTTYP	TW20	SWERTTYP
43	VTVDETM_WP	SWPKLASS	TW01	SWPKLASS
44	VTVDETM_WP	WAERS	TCURC	WAERS
45	VTVDETM_WP	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20110901
SAP Release Created in