SAP ABAP Table VBFHAZU (Updating Table for 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	INTTAB	Structure
Structure	VBFHAZU	Table Relationship Diagram
Short Description	Updating Table for 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	Structures for generating change document update programs
70	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in