SAP ABAP Table VTXIZU (Forex Transaction Status Table)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTD (Package) R/3 Application development for Treasury foreign exchange

Basic Data

Table Category	INTTAB	Structure
Structure	VTXIZU	Table Relationship Diagram
Short Description	Forex Transaction Status Table

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	Transaction Activity
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	RFHA	☐	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction	VTBFHA
5	RFHAZU	☐	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
6	CRUSER	☐	TB_CRUSER	SYCHAR12	CHAR	12	0	Entered by
7	DCRDAT	☐	TB_DCRDAT	DATUM	DATS	8	0	Entered On
8	TCRTIM	☐	TB_TCRTIM	UZEIT	TIMS	6	0	Entry Time
9	UPUSER	☐	TB_UPUSER	SYCHAR12	CHAR	12	0	Last Changed by
10	DUPDAT	☐	TB_DUPDAT	DATUM	DATS	8	0	Changed on
11	TUPTIM	☐	TB_TUPTIM	UZEIT	TIMS	6	0	Time changed
12	SGSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
13	SFHAART	☐	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
14	SFGZUSTT	☐	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category	AT02
15	SFUNKTV	☐	TB_SFUNKTV	T_FUNKTION	CHAR	4	0	Transition Function from Directly Preceding Activity	AT60
16	SFUNKTL	☐	TB_SFUNKTL	T_FUNKTION	CHAR	4	0	Latest function used in editing activity	AT60
17	ROFHAZU	☐	TB_ROFHAZU	T_RFHAZU	NUMC	5	0	Previous Activity
18	RFHAZUX	☐	TB_RFHAZUX	T_RFHAZU	NUMC	5	0	Previous activity, which is supplemented by current activity
19	SAKTIV	☐	TB_SAKTIV	T_SAKTIV	NUMC	1	0	Active Status of Transaction or Activity
20	SSTOGRD	☐	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
21	RDEALER	☐	RDEALER	RDEALER	CHAR	12	0	Trader	TZDEA
22	DVTRAB	☐	TB_DVTRAB	DATUM	DATS	8	0	Contract Conclusion Date
23	TVTRAB	☐	TB_TVTRAB	UZEIT	TIMS	6	0	Time of contract conclusion
24	GSPPART	☐	TB_GSPPART	TEXT19	CHAR	19	0	Contact Person
25	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
26	NORDEXT	☐	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
27	DBLFZ	☐	TB_DBLFZ	DATUM	DATS	8	0	Term Start
28	DELFZ	☐	TB_DELFZ	DATUM	DATS	8	0	Term End
29	DFIX	☐	TB_DFIX	DATUM	DATS	8	0	Fixing date
30	SINCLE	☐	TB_SINCLE	XFELD	CHAR	1	0	End of Term Inclusive Indicator
31	DZSTND	☐	TB_DZSTND	DATUM	DATS	8	0	Last activity transition date (e.g. for rollover)
32	SZNSPRO	☐	TB_SZNSPRO	T_SZNSPRO	NUMC	1	0	Interest Handling with Rollover
33	DZNSSTD	☐	TB_DZNSSTD	DATUM	DATS	8	0	Payment date for deferred interest
34	KKURS	☐	TB_KKURS	TB_KKURS	DEC	13	9	Rate of Forex Transaction
35	KKASSA	☐	TB_KKASSA	TB_KKURS	DEC	13	9	Spot Rate
36	KSWAP	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
37	WLWAERS	☐	TB_WLWAERS	WAERS	CUKY	5	0	Leading currency	TCURC
38	WFWAERS	☐	TB_WFWAERS	WAERS	CUKY	5	0	Following Currency	TCURL
39	LIMITART	☐	TB_LIMITAR	T_LIMITAR	CHAR	2	0	Limit type	ATOR
40	LIMITDAT	☐	TB_LIMITDA	DATUM	DATS	8	0	Limit date
41	RKONDGR	☐	TB_RKONDGR	T_RKONDGR	NUMC	1	0	Direction of Transaction
42	LIWAERS	☐	TB_LIWAERS	WAERS	CUKY	5	0	Reference currency for limit	TCURC
43	KWLIQUI	☐	TX_KWLIQ	T_SWKURS	DEC	13	9	Liquidity effect for rollover
44	SCONFIRM	☐	TB_CONF	TB_CONF	NUMC	1	0	Confirmation Status
45	DEXDAT	☐	TB_DCONF	DATUM	DATS	8	0	Confirmation Date
46	UEXNAM	☐	TB_UCONF	USNAM	CHAR	12	0	Confirmation Executed By (User Responsible)
47	SRECONFIRM	☐	TB_RECONF	TB_RECONF	NUMC	1	0	Counterconfirmation
48	DREDAT	☐	TB_DREDAT	DATUM	DATS	8	0	Counterconfirmation Date
49	URENAM	☐	TB_URENAM	USNAM	CHAR	12	0	Counterconfirmation Executed by (User Responsible)
50	DORDER	☐	TB_DORDER	DATUM	DATS	8	0	Order date
51	DANST	☐	TB_DANST	DATUM	DATS	8	0	Reservation date
52	TANST	☐	TB_TANST	TIMES	TIMS	6	0	Order time of day
53	SANST	☐	TB_SANST	SANST	CHAR	2	0	Reservation Reason	TW14
54	SSPESEN	☐	TB_SPESEN	T_SPESEN	CHAR	1	0	Expenses key
55	BUPRCLIM	☐	TB_BUPRCLIM	VVPKTKUR	DEC	15	6	Limit Price for Unit Quotation
56	SRUNITLIM	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
57	BPPRCLIM	☐	TB_BPPRCLIM	VVPKTKUR	DEC	15	6	Limit Price for Percentage Quotation
58	JVERK6B	☐	TB_VERK6B	CHAR1	CHAR	1	0	Flag for sale from §6b - position
59	PEFFZINS	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
60	PEFFZINS_GIVEN	☐	TB_PYIELD_GIVEN	DECV3_7	DEC	10	7	Given Effective Interest Rate
61	PEFFZCALL	☐	TB_PYIELDCALL	DECV3_7	DEC	10	7	Effective interest rate - termination of issuer
62	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
63	NOTICE_DATE	☐	TB_NOTICE_DATE	DATUM	DATS	8	0	OTC Notice Date
64	ROUNDING_RULE	☐	TPM_ROUNDING_RULE	TPM_ROUNDING_RULE	CHAR	4	0	Rounding Rule	TRSC_ROUND_RULE
65	BPPRC_SPOT2	☐	TB_BPPRC_SPOT_MAT	VVPKTKUR	DEC	15	6	Spot Rate at Maturity in Percentage
66	BPPRC_SPOT1	☐	TB_BPPRC_SPOT1	VVPKTKUR	DEC	15	6	Current Spot Rate in Percentage
67	BPPRC_MARG	☐	TB_BPPRC_MARG	DEC15_5DB4	DEC	15	5	Margin Rate in Percentage
68	COC_RATE	☐	TB_BPPRC_COC2	TPM_TRR_AMOUNT	DEC	15	6	Interest Rate for Cost of Carryforward
69	DVALUTA	☐	TB_DVALUTA	DATUM	DATS	8	0	Value date of forex transaction
70	XDVALUTA	☐	TX_DVALUTA	T_XDATUM	CHAR	10	0	Value Date
71	XDFIX	☐	TX_DFIX	T_XDATUM	CHAR	10	0	Fixing date as text field
72	XWDARST	☐	TX_XWDARST	XFELD	CHAR	1	0	Invert 'Leading currency'/'Following currency'
73	XCURRPAIR	☐	CHAR11	CHAR11	CHAR	11	0	Character Length 11
74	VALRATETIM	☐	TB_ACTRATETIM	UZEIT	TIMS	6	0	Time of current rate
75	VALRATE1	☐	TB_ACTKURS	TB_KKURS	DEC	13	9	Current market rate
76	XVALRATE1PAIR	☐	CHAR11	CHAR11	CHAR	11	0	Character Length 11
77	VALSWAP1	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
78	VALRATE2	☐	TB_ACTKURS	TB_KKURS	DEC	13	9	Current market rate
79	VALSWAP2	☐	TB_KSWAP	T_SWKURS	DEC	13	9	Swap Rate
80	XVALRATE2PAIR	☐	CHAR11	CHAR11	CHAR	11	0	Character Length 11

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTXIZU	BUKRS	T001	BUKRS	KEY	1	CN
2	VTXIZU	LIMITART	ATOR	LIMITART	REF	C	CN
3	VTXIZU	LIWAERS	TCURC	WAERS	REF	C	CN
4	VTXIZU	MANDT	T000	MANDT	KEY	1	CN
5	VTXIZU	RDEALER	TZDEA	RDEALER	KEY	1	CN
6	VTXIZU	RFHA	VTBFHA	RFHA	KEY	1	CN
7	VTXIZU	ROUNDING_RULE	TRSC_ROUND_RULE	ROUNDING_RULE	KEY	1	CN
8	VTXIZU	SANST	TW14	SANST
9	VTXIZU	SFGZUSTT	AT02	SFGZUSTT	KEY	1	CN
10	VTXIZU	SFHAART	AT10	SFHAART	KEY	1	CN
11	VTXIZU	SFUNKTL	AT60	SFUNKTION	REF	C	CN
12	VTXIZU	SFUNKTV	AT60	SFUNKTION	KEY	1	CN
13	VTXIZU	SGSART	TZPA	GSART	KEY	1	CN
14	VTXIZU	SSTOGRD	TZST	SSTOGRD	KEY	1	CN
15	VTXIZU	WFWAERS	TCURL	FWAERS	KEY	1	CN
16	VTXIZU	WLWAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in