SAP ABAP Table VTBFXIFDC (Structure for creating a forex transaction via interface)

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	VTBFXIFDC	Table Relationship Diagram
Short Description	Structure for creating a forex transaction via interface

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in