SAP VTBFHAZU Transaction Activity Table
Overview
VTBFHAZU is a standard SAP S/4HANA table that stores Transaction Activity data. There are total 75 fields in the VTBFHAZU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBFHAZU belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBFHAZU to other SAP tables and standard CDS views available based on VTBFHAZU table in S/4HANA 2020.
Techincal Settings of VTBFHAZU
Below are technical details of the table VTBFHAZU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBFHAZU Fields
The following table gives you an overview of the fields available in VTBFHAZU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| RFHAZU | Transaction Activity | TB_RFHAZU | NUMC | 5 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| UPUSER | Last Changed By | TB_UPUSER | CHAR | 12 | |
| DUPDAT | Changed On | TB_DUPDAT | DATS | 8 | |
| TUPTIM | Time Changed | TB_TUPTIM | TIMS | 6 | |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 |
| SFGZUSTT | Transaction Activity Category | TB_SFGZUTY | AT02 | NUMC | 2 |
| SFUNKTV | Transition Function from Directly Preceding Activity | TB_SFUNKTV | AT60 | CHAR | 4 |
| SFUNKTL | Latest function used in editing activity | TB_SFUNKTL | AT60 | CHAR | 4 |
| ROFHAZU | Previous Activity | TB_ROFHAZU | NUMC | 5 | |
| RFHAZUX | Previous activity which is supplemented by current activity | TB_RFHAZUX | NUMC | 5 | |
| SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1 | |
| SSTOGRD | Reason for Reversal | SSTOGRD | TZST | CHAR | 2 |
| RDEALER | Trader | RDEALER | TZDEA | CHAR | 12 |
| DVTRAB | Contract Conclusion Date | TB_DVTRAB | DATS | 8 | |
| TVTRAB | Time of Contract Conclusion | TB_TVTRAB | TIMS | 6 | |
| GSPPART | Contact Person | TB_GSPPART | CHAR | 19 | |
| XAKT | File Number | XAKT | CHAR | 32 | |
| NORDEXT | External Reference | TB_NORDEXT | CHAR | 16 | |
| DBLFZ | Term Start | TB_DBLFZ | DATS | 8 | |
| DELFZ | Term End | TB_DELFZ | DATS | 8 | |
| DFIX | Fixing Date | TB_DFIX | DATS | 8 | |
| FIXING_REF_ID | Fixing Reference ID | FTR_FIXING_REF_ID | FTRT_FIX_DEF | CHAR | 30 |
| SINCLE | End of Term Inclusive Indicator | TB_SINCLE | CHAR | 1 | |
| DZSTND | Last activity transition date (e.g. for rollover) | TB_DZSTND | DATS | 8 | |
| SZNSPRO | Interest Handling with Rollover | TB_SZNSPRO | NUMC | 1 | |
| DZNSSTD | Payment date for deferred interest | TB_DZNSSTD | DATS | 8 | |
| KKURS | Rate of Foreign Exchange Transaction | TB_KKURS | DEC | 13 | |
| KKASSA | Spot Rate | TB_KKASSA | DEC | 13 | |
| KSWAP | Swap Rate | TB_KSWAP | DEC | 13 | |
| WLWAERS | Leading Currency | TB_WLWAERS | TCURC | CUKY | 5 |
| WFWAERS | Following Currency | TB_WFWAERS | TCURL | CUKY | 5 |
| LIMITART | Limit Type | TB_LIMITAR | ATOR | CHAR | 2 |
| LIMITDAT | Limit Date | TB_LIMITDA | DATS | 8 | |
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | |
| LIWAERS | Reference Currency for Limit | TB_LIWAERS | TCURC | CUKY | 5 |
| KWLIQUI | Liquidity Effect for Rollover | TX_KWLIQ | DEC | 13 | |
| SCONFIRM | Confirmation Status | TB_CONF | NUMC | 1 | |
| DEXDAT | Confirmation Date | TB_DCONF | DATS | 8 | |
| UEXNAM | Confirmation Executed By (User Responsible) | TB_UCONF | CHAR | 12 | |
| SRECONFIRM | Counterconfirmation | TB_RECONF | NUMC | 1 | |
| DREDAT | Counterconfirmation Date | TB_DREDAT | DATS | 8 | |
| URENAM | Counterconfirmation Executed by (User Responsible) | TB_URENAM | CHAR | 12 | |
| DORDER | Order Date | TB_DORDER | DATS | 8 | |
| DANST | Reservation Date | TB_DANST | DATS | 8 | |
| TANST | Order Time of Day | TB_TANST | TIMS | 6 | |
| SANST | Reservation Reason | TB_SANST | TW14 | CHAR | 2 |
| SSPESEN | Expenses Key | TB_SPESEN | CHAR | 1 | |
| BUPRCLIM | Limit Price for Unit Quotation | TB_BUPRCLIM | DEC | 15 | |
| SRUNITLIM | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | |
| BPPRCLIM | Limit Price for Percentage Quotation | TB_BPPRCLIM | DEC | 15 | |
| JVERK6B | Flag for Sale from Article 6b - Position | TB_VERK6B | CHAR | 1 | |
| PEFFZINS | Effective Interest Rate | TB_PYIELD | DEC | 10 | |
| PEFFZINS_GIVEN | Given Effective Interest Rate | TB_PYIELD_GIVEN | DEC | 10 | |
| PEFFZCALL | Effective Interest Rate - Termination of Issuer | TB_PYIELDCALL | DEC | 10 | |
| SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | |
| NOTICE_DATE | OTC Notice Date | TB_NOTICE_DATE | DATS | 8 | |
| ROUNDING_RULE | Rounding Rule | TPM_ROUNDING_RULE | TRSC_ROUND_RULE | CHAR | 4 |
| BPPRC_SPOT2 | Spot Rate at Maturity in Percentage | TB_BPPRC_SPOT_MAT | DEC | 15 | |
| BPPRC_SPOT1 | Current Spot Rate in Percentage | TB_BPPRC_SPOT1 | DEC | 15 | |
| BPPRC_MARG | Margin Rate in Percentage | TB_BPPRC_MARG | DEC | 15 | |
| COC_RATE | Interest Rate for Cost of Carryforward | TB_BPPRC_COC2 | DEC | 15 | |
| FORWARD_DATE | Forward Date | FTR_FWDDATE | DATS | 8 | |
| SNOTDELIVERED | Security not delivered | FTR_NOT_DEL_FLG | CHAR | 1 | |
| PEFFZ_WORST | Yield to Worst | TB_WORST_YIELD | DEC | 10 | |
| PEFFZ_WORST_DT | Yield to Worst End Date | TB_WORST_YIELD_DT | DATS | 8 | |
| ZVTRAB | Time Zone of Contract Date and Time | TB_ZVTRAB | TTZZ | CHAR | 6 |
| NOM_UP_LIMIT | Upper limit amount in payment currency | FTR_BZBETR_UPPER | CURR | 13 | |
| NOM_LOW_LIMIT | Lower limit amount in payment currency | FTR_BZBETR_LOWER | CURR | 13 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBFHAZU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBFHAZU | BUKRS | 1: CN | T001 |
| VTBFHAZU | FIXING_REF_ID | 1: CN | FTRT_FIX_DEF |
| VTBFHAZU | LIMITART | C: CN | ATOR |
| VTBFHAZU | LIWAERS | C: CN | TCURC |
| VTBFHAZU | MANDT | 1: CN | T000 |
| VTBFHAZU | RDEALER | 1: CN | TZDEA |
| VTBFHAZU | RFHA | 1: CN | VTBFHA |
| VTBFHAZU | ROUNDING_RULE | 1: CN | TRSC_ROUND_RULE |
| VTBFHAZU | SANST | : | TW14 |
| VTBFHAZU | SFGZUSTT | 1: CN | AT02 |
| VTBFHAZU | SFHAART | 1: CN | AT10 |
| VTBFHAZU | SFUNKTL | C: CN | AT60 |
| VTBFHAZU | SFUNKTV | 1: CN | AT60 |
| VTBFHAZU | SGSART | 1: CN | TZPA |
| VTBFHAZU | SSTOGRD | 1: CN | TZST |
| VTBFHAZU | WFWAERS | 1: CN | TCURL |
| VTBFHAZU | WLWAERS | 1: CN | TCURC |
| VTBFHAZU | ZVTRAB | : | TTZZ |