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

History

Last changed by/on	SAP	20130529
SAP Release Created in