SAP ABAP Table VTB_SFHAZU (Forwards: Financial Transaction Activity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTT (Package) R/3 application development for Treasury forward trading

Basic Data

Table Category	INTTAB	Structure
Structure	VTB_SFHAZU	Table Relationship Diagram
Short Description	Forwards: Financial Transaction Activity

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	.INCLUDE	☐				0	0	Forwards: Financial Transaction Activity Screen Fields
70	XAKTIV	☐	TM_XAKTIV	TEXT60	CHAR	60	0	Active status: description
71	XSTOGRDL	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
72	XVTRAB	☐	TM_XABSCHL	T_XDATUM	CHAR	10	0	Close Date
73	XFGZUSTT	☐	TB_XTTEXT	TEXT30	CHAR	30	0	Name of activity category
74	XFUNKTV	☐	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
75	XFUNKTL	☐	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
76	SPOT_SE_U	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
77	SRUNIT_SE	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
78	SPOT_SE_P	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
79	XBLFZ	☐	TM_XLFZBEG	T_XDATUM	CHAR	10	0	Term Start
80	XELFZ	☐	TM_XLFZEND	T_XDATUM	CHAR	10	0	End of Term
81	XZNSSTD	☐	TM_XZNSSTD	T_XDATUM	CHAR	10	0	Payment date for deferred interest
82	XZINSBMETH	☐	TM_XZINSBM	TEXT60	CHAR	60	0	Description of interest calculation method
83	XZINSKENNZ	☐	TM_XZINSKZ	TEXT60	CHAR	60	0	Short text for interest frequency indicator
84	XZNSPRO	☐	TM_XZNSPRO	TEXT60	CHAR	60	0	Interest treatment for rollover: description
85	XVWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
86	XFWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
87	XCONFIRM	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
88	XRECONFIRM	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
89	DORDERX	☐	WP_XORDER	T_XDATUM	CHAR	10	0	Order date as text field
90	DANSTX	☐	TB_DANSTX	T_XDATUM	CHAR	10	0	Reservation date as text field
91	DLIMITX	☐	TB_LIMITDAX	T_XDATUM	CHAR	10	0	Limit date
92	PYIELD_NEW	☐	TB_PYIELD	DECV3_7	DEC	10	7	Effective Interest Rate
93	BZBETR_SUM	☐	TB_BZBETR_SUM	WERTV7	CURR	13	2	Net payment amount
94	WZBETR_SUM	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*
95	UNITS_FREE	☐	VPOS_FREE_U	ASTUECK	DEC	15	5	Position excluding current business transaction
96	NOMINAL_FREE	☐	VPOS_FREE_P	WERTV8_TR	CURR	15	2	Position excluding current business transaction
97	NOM_CURR1	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
98	UNITS_FREE_CUM	☐	VPOS_FREE_U_CUM	ASTUECK	DEC	15	5	Position including current business transaction
99	NOMINAL_FREE_CUM	☐	VPOS_FREE_P_CUM	WERTV8_TR	CURR	15	2	Position including current business transaction
100	NOM_CURR2	☐	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
101	DFESTSI	☐	TB_DFESTSI	DATUM	DATS	8	0	Actual rate fixing date
102	TFESTSI	☐	TB_TFESTSI	SYTIME	TIMS	6	0	Actual time of rate fixing
103	RFEEDNAME	☐	TB_DFNAME	T_DFCHAR10	CHAR	10	0	Market Data: Data Provider	*
104	SSPOT_U	☐			CHAR	33	0
105	SSPOT_P	☐			CHAR	40	0
106	SSPOT_ORIGIN	☐			CHAR	60	0
107	JMANU	☐	TB_JMANU	XFELD	CHAR	1	0	Indicator: Manual entry
108	SPOT_SE_U_NEW	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
109	SRUNIT_SE_NEW	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
110	SPOT_SE_P_NEW	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
111	SEFFMETH_NEW	☐	SEFFMETH_NEW	SEFFMETH_NEW	NUMC	1	0	Effective Interest Method (Financial Mathematics)
112	CALL_DATE	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
113	BUPRC_MARG	☐	TB_BUPRC_MARG	VVPKTKUR	DEC	15	6	Margin Rate (Amount Without Currency Reference)
114	BUPRC_SPOT1	☐	TB_BUPRC_SPOT1	VVPKTKUR	DEC	15	6	Current Spot Rate Unit-Quoted Without Currency Reference
115	BUPRC_SPOT2	☐	TB_BUPRC_SPOT_MAT	VVPKTKUR	DEC	15	6	Spot Rate at Maturity Without Currency Reference

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	462_10