SAP ABAP Table VTVBARW_FX (Foreign Exchange: Non-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	VTVBARW_FX	Table Relationship Diagram
Short Description	Foreign Exchange: Non-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	STICHTAG	☐	VVSTDAT	VVSTDAT	DATS	8	0	Key date
29	RSTICH	☐	RSTICH	RSTICH	CHAR	1	0	Key date reference
30	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
31	WGSCHFT1	☐	FTI_WGSCH1	WAERS	CUKY	5	0	Currency borrowing/sale	TCURC
32	WGSCHFT2	☐	FTI_WGSCH2	WAERS	CUKY	5	0	Currency investment/purchase	TCURC
33	WLWAERS	☐	TB_WLWAERS	WAERS	CUKY	5	0	Leading currency	TCURC
34	WFWAERS	☐	TB_WFWAERS	WAERS	CUKY	5	0	Following Currency	TCURC
35	MKKURS	☐	MKKURS	NUMC4	NUMC	4	0	Rate of FX transaction (drill-down reporting characteristic)
36	BNOMI1	☐	FTI_BNOMI1	WERTV8	CURR	15	2	Nominal amount borrowing/sale
37	BNOMI2	☐	FTI_BNOMI2	WERTV8	CURR	15	2	Nominal amount investment/purchase
38	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
39	UNRGVHW1BETR	☐	FTI_UNRGV1	WERTV7	CURR	13	2	Unrealized gains/losses sale - Local currency
40	UNRGVHW2BETR	☐	FTI_UNRGV2	WERTV7	CURR	13	2	Unrealized gains/losses - Purchase LC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTVBARW_FX	BUKRS	T001	BUKRS		1	CN
2	VTVBARW_FX	GSART	TZPA	GSART
3	VTVBARW_FX	HKONT	SKB1	SAKNR
4	VTVBARW_FX	MANDT	T000	MANDT		1	CN
5	VTVBARW_FX	PARTNR	BUT000	PARTNER
6	VTVBARW_FX	RDEALER	TZDEA	RDEALER
7	VTVBARW_FX	RFHA	VTBFHA	RFHA
8	VTVBARW_FX	RGARANT	BUT000	PARTNER		C	CN
9	VTVBARW_FX	RMAID	VTBMA	RMAID		C	CN
10	VTVBARW_FX	RPORTB	TWPOB	RPORTB		1	CN
11	VTVBARW_FX	RREFKONT	T037S	RREFKONT		1	CN
12	VTVBARW_FX	SANLF	TZAF	SANLF		1	CN
13	VTVBARW_FX	SFGTYP	AT01	SFGTYP
14	VTVBARW_FX	SFGZUSTT	AT02	SFGZUSTT
15	VTVBARW_FX	SFHAART	AT10	SFHAART
16	VTVBARW_FX	WAERS	TCURC	WAERS
17	VTVBARW_FX	WFWAERS	TCURC	WAERS		C	CN
18	VTVBARW_FX	WGSCHFT1	TCURC	WAERS
19	VTVBARW_FX	WGSCHFT2	TCURC	WAERS
20	VTVBARW_FX	WLWAERS	TCURC	WAERS		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in