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
⤷ 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 |