SAP ABAP Table VTVDETA_DE (Derivatives: 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	VTVDETA_DE	Table Relationship Diagram
Short Description	Derivatives: 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
4	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
5	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
6	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
7	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	*
8	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
10	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	*
11	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	*
12	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
13	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	*
14	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
15	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
16	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
17	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	*
18	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	*
19	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
20	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
21	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
22	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
23	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
24	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
25	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
26	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
27	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
28	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
30	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
31	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
32	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
33	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
34	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
35	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
36	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
37	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
38	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	*
39	SUWHR	☐	SUWHR	WAERS	CUKY	5	0	Underlying currency	*
40	WGSCHFT1	☐	TB_WGSCHF1	WAERS	CUKY	5	0	Currency of Outgoing Side	*
41	WGSCHFT2	☐	TB_WGSCHF2	WAERS	CUKY	5	0	Currency of Incoming Side	*
42	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
43	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
44	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
45	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
46	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
47	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
48	D_ZBETR	☐	D_CASHCW	WERTV8_TR	CURR	15	2	Payment amount in payment currency
49	D_ZBETRHW	☐	D_CASHHW	WERTV8_TR	CURR	15	2	Payment amount in local currency
50	D_WZBETR	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
51	D_EBETR	☐	D_ERFOLGBW	WERTV8_TR	CURR	15	2	-->Profit/loss amount in position currency
52	D_EBETRHW	☐	D_ERFOLGHW	WERTV8_TR	CURR	15	2	Profit/Loss Amount in Local Currency
53	D_BNOMBW	☐	D_BNOMBW	WERTV8_TR	CURR	15	2	Change in nominal value in position currency
54	D_BNOMBW1	☐	D_BNOMBW	WERTV8_TR	CURR	15	2	Change in nominal value in position currency
55	D_BNOMBW2	☐	D_BNOMBW	WERTV8_TR	CURR	15	2	Change in nominal value in position currency
56	D_AKTBWBW	☐	D_AKTBWBW	WERTV8_TR	CURR	15	2	Asset: Change in book value in position/transaction curr.
57	D_AKTBWHW	☐	D_AKTBWHW	WERTV8_TR	CURR	15	2	Asset: Change in book value in local currency
58	D_PASBWBW	☐	D_PASBWBW	WERTV8_TR	CURR	15	2	Liability: Change in book value in position/trans. curr.
59	D_PASBWHW	☐	D_PASBWHW	WERTV8_TR	CURR	15	2	Liability: Change in book value in local currency
60	D_BEW_PAS_OPR	☐	FTI_D_BEW_PAS_OPR	WERTV8_TR	CURR	15	2	Liability: Delta Eval. Option Premium (Borrow/Sale) in PC/TC
61	D_BEW_PAS_OPR_HW	☐	FTI_D_BEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Liability: Delta Eval. Option Premium (Borrowing/Sale) in LC
62	D_FXBEW_PAS_OPR_HW	☐	FTI_D_FXBEW_PAS_OPR_HW	WERTV8_TR	CURR	15	2	Delta Evaluation Forex Liability Option Premium in LC
63	D_BEW_AKT_OPR	☐	FTI_D_BEW_AKT_OPR	WERTV8_TR	CURR	15	2	Asset: Delta Eval. Option Premium (Borrowing/Sale in PC/TC
64	D_BEW_AKT_OPR_HW	☐	FTI_D_BEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Asset: Delta Eval. Option Premium (Borrowing/Sale) in LC
65	D_FXBEW_AKT_OPR_HW	☐	FTI_D_FXBEW_AKT_OPR_HW	WERTV8_TR	CURR	15	2	Delta Evaluation Forex Capitalized Option Premium in LC
66	PABGERFBW	☐	PABGERFBW	WERTV8_TR	CURR	15	2	Revenue accrued/deferred in position currency (PC)
67	PABGERFHW	☐	PABGERFHW	WERTV8_TR	CURR	15	2	Revenue Accrued/Deferred in Local Currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETA_DE	LAND1	T005	LAND1
2	VTVDETA_DE	PARTNR	BUT000	PARTNER
3	VTVDETA_DE	PRKEY	PAYRQ	KEYNO		C	CN
4	VTVDETA_DE	RAHABKI	T012	HBKID
5	VTVDETA_DE	RAHKTID	T012K	HKTID
6	VTVDETA_DE	RPZAHL	BUT000	PARTNER
7	VTVDETA_DE	SBEWART	TZB0A	SBEWART
8	VTVDETA_DE	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in