SAP ABAP Table VWSFHAZU (Transaction Activity from Securities View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

Table Category	INTTAB	Structure
Structure	VWSFHAZU	Table Relationship Diagram
Short Description	Transaction Activity from Securities View

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	TZUNI
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	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	XBLFZ	☐	TM_XLFZBEG	T_XDATUM	CHAR	10	0	Term Start
73	XELFZ	☐	TM_XLFZEND	T_XDATUM	CHAR	10	0	End of Term
74	XVTRAB	☐	TM_XABSCHL	T_XDATUM	CHAR	10	0	Close Date
75	XZNSSTD	☐	TM_XZNSSTD	T_XDATUM	CHAR	10	0	Payment date for deferred interest
76	XZINSBMETH	☐	TM_XZINSBM	TEXT60	CHAR	60	0	Description of interest calculation method
77	XZINSKENNZ	☐	TM_XZINSKZ	TEXT60	CHAR	60	0	Short text for interest frequency indicator
78	XZNSPRO	☐	TM_XZNSPRO	TEXT60	CHAR	60	0	Interest treatment for rollover: description
79	XVWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
80	XFWERK	☐	TM_XGSCHTG	TEXT60	CHAR	60	0	Description of working day method
81	XFGZUSTT	☐	TB_XTTEXT	TEXT30	CHAR	30	0	Name of activity category
82	XFUNKTV	☐	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
83	XFUNKTL	☐	TB_XFUNKT	TEXT30	CHAR	30	0	Name of Treasury function
84	XCONFIRM	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
85	XRECONFIRM	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
86	.INCLUDE	☐				0	0	Transaction: Other Screen Fields from Securities View
87	XORDER	☐	TX_XORDER	CHAR1	CHAR	1	0	Flag to create the transaction as an order/fixing
88	XVERTRAG	☐	TX_XVERTR	CHAR1	CHAR	1	0	Flag to create the transaction as a contract
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	DFESTSI	☐	TB_DFESTSI	DATUM	DATS	8	0	Actual rate fixing date
96	TFESTSI	☐	TB_TFESTSI	SYTIME	TIMS	6	0	Actual time of rate fixing
97	SPOT_SE_U	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
98	SRUNIT_SE	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	*
99	SPOT_SE_P	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
100	RFEEDNAME	☐	TB_DFNAME	T_DFCHAR10	CHAR	10	0	Market Data: Data Provider	*
101	SSPOT_U	☐			CHAR	33	0
102	SSPOT_P	☐			CHAR	40	0
103	SSPOT_ORIGIN	☐			CHAR	60	0
104	JMANU	☐	TB_JMANU	XFELD	CHAR	1	0	Indicator: Manual entry
105	SPOT_SE_U_NEW	☐	TB_BUPRC	VVPKTKUR	DEC	15	6	Security Price Without Currency Ref. with Unit Quotation
106	SRUNIT_SE_NEW	☐	TB_RUNIT	VVSRUNIT	CHAR	5	0	Currency unit of rate	TZUNI
107	SPOT_SE_P_NEW	☐	TB_BPPRC	VVPKTKUR	DEC	15	6	Security Price for Percentage Quotation
108	SEFFMETH_NEW	☐	SEFFMETH_NEW	SEFFMETH_NEW	NUMC	1	0	Effective Interest Method (Financial Mathematics)
109	CALL_DATE	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
110	BZBETR_ACCINT	☐	TB_BZBETR	WERTV7	CURR	13	2	Payment amount in payment currency
111	WZBETR_ACCINT	☐	TB_WZBETR	WAERS	CUKY	5	0	Payment Currency	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in