SAP ABAP Table VTBFHAZU (Transaction Activity)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTBFHAZU	Table Relationship Diagram
Short Description	Transaction Activity

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in