SAP ABAP Table VTVDETA_FX (Foreign Exchange: 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_FX	Table Relationship Diagram
Short Description	Foreign Exchange: 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 FX: 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	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
9	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
11	SFGTYP	☐	TB_SFGTYP	T_SFGTYP	NUMC	3	0	Transaction Category	AT01
12	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
13	SAKTIV	☐	FTI_SAKTIV	FTI_SAKTIV	CHAR	1	0	Active status of financial transaction (drilldown reporting)
14	RREFKONT	☐	TB_REFKONT	USTRU	CHAR	8	0	Acct Assignment Ref. for Operative Valn Area and Loan	T037S
15	HKONT	☐	FTI_HKONT	SAKNR	CHAR	10	0	General ledger account	SKB1
16	FINPROJ	☐	TB_TFPROJ	T_TFPROJ	CHAR	13	0	Finance Project
17	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
18	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
19	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
20	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
21	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
22	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
23	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
24	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
25	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
26	RMAID	☐	TB_RMAID	T_RMAID	CHAR	10	0	Master Agreement	VTBMA
27	RGARANT	☐	TB_RGARANT_NEW	BU_PARTNER	CHAR	10	0	Guarantor of Financial Transaction	BUT000
28	VONDAT	☐	DVONDAT	DATUM	DATS	8	0	Start Date of Evaluation
29	BISDAT	☐	DBISDAT	DATUM	DATS	8	0	Date of evaluation end
30	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
31	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
32	SBEWART	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
33	SBEWEBE	☐	TB_SBEWEBE	T_SBEWEBE	CHAR	1	0	Posting Status of Flow
34	SBFREI	☐	TB_SBFREI	XFELD	CHAR	1	0	Release Given for Flow to Be Posted?
35	DBUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
36	DGJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
37	DMONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
38	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
39	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
40	RAHABKI	☐	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	T012
41	RAHKTID	☐	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	T012K
42	RPBANK	☐	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
43	LAND1	☐	FTI_LAND1	LAND1	CHAR	3	0	Country key of company code	T005
44	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
45	SSIGN	☐	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
46	.INCLUDE	☐				0	0	Contains Invisible Calculation Fields for Drilldown Reportng
47	SZART	☐	TB_SZART	XFELD	CHAR	1	0	Payment transaction
48	SPAYRQ	☐	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
49	PRKEY	☐	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	PAYRQ
50	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
51	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
52	BZBETR	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
53	WZBETR	☐	FTI_SCWHR	WAERS	CUKY	5	0	Currency of payment amount	TCURC
54	BHWBETR	☐	TB_HWBETR	WERTV7	CURR	13	2	Payment Amount in Local Currency
55	SBWHR	☐	TB_BWHR	WAERS	CUKY	5	0	Position Currency/Transaction Currency	TCURC
56	SPLWHR	☐	SPLWHR	WAERS	CUKY	5	0	Profit/loss currency	*
57	EHBETR	☐	EHBETR	WERTV7	CURR	13	2	Profit/loss amount in local currency
58	D_ERFOLGPLW	☐	FTI_ERFOLGPLW	WERTV8_TR	CURR	15	2	Profit/loss amount in currency of profit/loss
59	GVBETR	☐	GVBETR	WERTV7	CURR	13	2	Delta provisions/unrealized gains and losses LC
60	KBBWHR	☐	KBBWHR	WERTV7	CURR	13	2	Change in nominal purchase value
61	VKBBWHR	☐	VKBBWHR	WERTV7	CURR	13	2	Change in nominal value: Sale
62	WGSCHFT1	☐	FTI_WGSCH1	WAERS	CUKY	5	0	Currency borrowing/sale	*
63	WGSCHFT2	☐	FTI_WGSCH2	WAERS	CUKY	5	0	Currency investment/purchase	*
64	D_ASTUECK	☐	D_ASTUECK	ASTUECK	DEC	15	5	Change in no. of units (for unit-quoted securities)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVDETA_FX	BUKRS	T001	BUKRS
2	VTVDETA_FX	GSART	TZPA	GSART
3	VTVDETA_FX	HKONT	SKB1	SAKNR
4	VTVDETA_FX	LAND1	T005	LAND1
5	VTVDETA_FX	MANDT	T000	MANDT
6	VTVDETA_FX	PARTNR	BUT000	PARTNER
7	VTVDETA_FX	PRKEY	PAYRQ	KEYNO		C	CN
8	VTVDETA_FX	RAHABKI	T012	HBKID
9	VTVDETA_FX	RAHKTID	T012K	HKTID
10	VTVDETA_FX	RDEALER	TZDEA	RDEALER
11	VTVDETA_FX	RFHA	VTBFHA	RFHA
12	VTVDETA_FX	RGARANT	BUT000	PARTNER		C	CN
13	VTVDETA_FX	RMAID	VTBMA	RMAID		C	CN
14	VTVDETA_FX	RPORTB	TWPOB	RPORTB
15	VTVDETA_FX	RPZAHL	BUT000	PARTNER
16	VTVDETA_FX	RREFKONT	T037S	RREFKONT
17	VTVDETA_FX	SANLF	TZAF	SANLF
18	VTVDETA_FX	SBEWART	TZB0A	SBEWART
19	VTVDETA_FX	SBWHR	TCURC	WAERS
20	VTVDETA_FX	SFGTYP	AT01	SFGTYP
21	VTVDETA_FX	SFGZUSTT	AT02	SFGZUSTT
22	VTVDETA_FX	SFHAART	AT10	SFHAART
23	VTVDETA_FX	WAERS	TCURC	WAERS
24	VTVDETA_FX	WZBETR	TCURC	WAERS
25	VTVDETA_FX	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in