SAP VTBFHA Transaction Table
Overview
VTBFHA is a standard SAP S/4HANA table that stores Transaction data. There are total 87 fields in the VTBFHA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBFHA 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 VTBFHA to other SAP tables and standard CDS views available based on VTBFHA table in S/4HANA 2020.
Techincal Settings of VTBFHA
Below are technical details of the table VTBFHA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBFHA Fields
The following table gives you an overview of the fields available in VTBFHA
| 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 | CHAR | 13 | |
| 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 | |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| SANLF | Product Category | SANLF | TZAF | NUMC | 3 |
| SFGTYP | Transaction Category | TB_SFGTYP | AT01 | NUMC | 3 |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 |
| RGATT | Class | TI_RGATT | CHAR | 13 | |
| RMAID | Master Agreement | TB_RMAID | VTBMA | CHAR | 10 |
| RFHAZUNR | Number Status of Activity | TB_RFHAZUN | NUMC | 5 | |
| RFHAZUL | Last Active Transaction Activity | TB_RFHAZUL | NUMC | 5 | |
| SAKTIV | Active Status of Transaction or Activity | TB_SAKTIV | NUMC | 1 | |
| KONTRH | Business Partner Number | TB_KUNNR_NEW | CHAR | 10 | |
| SROLEXT | 3-Byte field | CHAR3 | CHAR | 3 | |
| RGARANT | Guarantor of Financial Transaction | TB_RGARANT_NEW | CHAR | 10 | |
| RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | T037S | CHAR | 8 |
| RREFKONT2 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | T037S | CHAR | 8 |
| RPORTB | Portfolio | RPORTB | TWPOB | CHAR | 10 |
| WGSCHFT | Transaction Currency | TB_WGSCHFT | TCURC | CUKY | 5 |
| WGSCHFT1 | Currency of Outgoing Side | TB_WGSCHF1 | CUKY | 5 | |
| WGSCHFT2 | Currency of Incoming Side | TB_WGSCHF2 | CUKY | 5 | |
| AMTINPUT | Indicator Field for Traded Amount in FX Transactions | TB_AMTIN | CHAR | 1 | |
| DBLFZ | Term Start | TB_DBLFZ | DATS | 8 | |
| SKALID | Factory calendar | SKALID | TFACD | CHAR | 2 |
| SKALID2 | Factory calendar | SKALID | TFACD | CHAR | 2 |
| JLIMIT | Limit Indicator | TB_JLIMIT | CHAR | 1 | |
| AKUEND | Period of Notice | TB_AKUEND | NUMC | 3 | |
| SKUEND | Unit of Period of Notice | TB_SKUEND | NUMC | 1 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| RLDEPO | Securities Account | VRLDEPO | TWD01 | CHAR | 10 |
| ZUONR | Finance Project | TB_TFPROJ | CHAR | 13 | |
| DELFZ | Term End | TB_DELFZ | DATS | 8 | |
| ABWTYP | Processing Category | TB_ABWTYP | AT05 | CHAR | 5 |
| TBEGRU | Authorization Group | TBEGRU | TRBRG | CHAR | 4 |
| VRFHA | Reference Transaction (Rollover/Premature Settlement) | TB_VORFHA | CHAR | 13 | |
| SINCLBE | Calculation Period: Start Inclusive vs. End Inclusive | TB_SINCLBE | CHAR | 1 | |
| SNPVCAL | NPV Calculation | TB_SNPVCAL | CHAR | 1 | |
| SRNDNG | Rounding of Amount from Generated Flows | TB_SRNDNG | CHAR | 1 | |
| ZUOND | Assignment | TB_ZUOND | CHAR | 18 | |
| REFER | Internal Reference | TB_REFER | CHAR | 16 | |
| MERKM | Characteristics | TB_MERKM | CHAR | 25 | |
| SFRGZUST | Transaction Release: Release Status | TB_FRGZUST | CHAR | 1 | |
| RANL | Security Class ID Number | VVRANLW | CHAR | 13 | |
| RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | TRGC_COM_VALCL | NUMC | 4 |
| FACILITYNR | Transaction Number of Facility | TB_FACILITYNR | VTBFHA | CHAR | 13 |
| FACILITYBUKRS | Company Code of Facility | TB_FACILITYBUKRS | T001 | CHAR | 4 |
| POSACC | Futures Account for Listed Options and Futures | TPM_POS_ACCOUNT_FUT | TRFT_POS_ACCOUNT | CHAR | 10 |
| RCOMVALCL2 | General Valuation Class | TPM_COM_VAL_CLASS | TRGC_COM_VALCL | NUMC | 4 |
| FUND | Fund | FM_FUND | CHAR | 10 | |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| TIMESTAMP_DEAL | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | TRCOT_CTY_MASTER | CHAR | 18 |
| RPORTB2 | Portfolio | RPORTB | TWPOB | CHAR | 10 |
| COMMODITY_ID1 | Commodity ID (obsolete) | TRCO_COMM_ID | TRCOT_CTY_MASTER | CHAR | 18 |
| COMMODITY_ID2 | Commodity ID (obsolete) | TRCO_COMM_ID | TRCOT_CTY_MASTER | CHAR | 18 |
| CLEARING_OPTION | Central Clearing Option (TREA) | TPM_TREA_CLEARING_OPT | NUMC | 1 | |
| CLEARING_STATUS | Clearing Status (TREA) | TPM_TREA_CLEARING_STATUS | NUMC | 1 | |
| CLEARING_DATE | Planned Clearing Date | TPM_TREA_CLEARING_DATE | DATS | 8 | |
| EXT_ACCOUNT | External Account | TPM_EXT_ACCOUNT | CHAR | 10 | |
| CLEAR_DATE_ACT | Actual Clearing Date | TPM_TREA_CLEARING_DATE_ACT | DATS | 8 | |
| SCONDITION | Indicates Whether Financial Trans. Is Based on a Condition | FTR_CONDITION_USED | CHAR | 1 | |
| RISK_MITIGATING | Risk Mitigation Indicator | FTR_THRESHOLD_RISK_MITIGATING | CHAR | 1 | |
| FIMA_CALCULATION | Cash Flow Calculation | TB_FIMA_CALCULATION | CHAR | 2 | |
| TRUSTEE | Trustee Number | FTR_TRUSTEE | CHAR | 10 | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| RCNTR | Cost Center | KOSTL | CSKS | CHAR | 10 |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| RBUSA | Business Area | GSBER | TGSB | CHAR | 4 |
| HEDGE_CLASS | Hedging Classification | TOE_HEDGING_CLASSIFICATION | TOEC_CLASS | CHAR | 5 |
| INIT_CLASSIFIER | Initial Stage Value | TRPA_INITIAL_STAGE | CHAR | 10 | |
| COUNTRY | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| FB_SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FAGL_SEGM | CHAR | 10 |
| BEHALF_OF_COMPANY | On Behalf of Company Code | TRBA_BEHALF_OF_COMPANY | T001 | CHAR | 4 |
| TRADED_CURRENCY | Traded Currency | FTR_TRADED_CURR | CUKY | 5 | |
| HEDGE_REQUEST_ID | Hedge Request ID | TOE_REQUEST_ID | CHAR | 13 | |
| CFI_CODE | CFI Code | FTR_CFI_CODE | CHAR | 6 | |
| ISIN | Security ID Number (ISIN) | RANL_ISIN | CHAR | 12 | |
| MIC | Market Identifier Code | TBA_MIC | TBAC_MIC | CHAR | 4 |
| CONTRACT_TIMESTAMP_UTC | Contract Timestamp in UTC | FTR_CONTRACT_TIMESTAMP_UTC | DEC | 21 | |
| BUPLA | Business Place | BUPLA | J_1BBRANCH | CHAR | 4 |
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 VTBFHA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBFHA | ABWTYP | 1: CN | AT05 |
| VTBFHA | BEHALF_OF_COMPANY | 1: CN | T001 |
| VTBFHA | BUKRS | 1: CN | T001 |
| VTBFHA | BUPLA | : | J_1BBRANCH |
| VTBFHA | COMMODITY_ID | : | TRCOT_CTY_MASTER |
| VTBFHA | COMMODITY_ID1 | : | TRCOT_CTY_MASTER |
| VTBFHA | COMMODITY_ID2 | : | TRCOT_CTY_MASTER |
| VTBFHA | COUNTRY | 1: CN | T005 |
| VTBFHA | FACILITYBUKRS | 1: CN | T001 |
| VTBFHA | FACILITYNR | : | VTBFHA |
| VTBFHA | FB_SEGMENT | 1: CN | FAGL_SEGM |
| VTBFHA | HEDGE_CLASS | : | TOEC_CLASS |
| VTBFHA | MANDT | 1: CN | T000 |
| VTBFHA | MIC | : | TBAC_MIC |
| VTBFHA | OBJNR | 1: N | ONR00 |
| VTBFHA | POSACC | : | TRFT_POS_ACCOUNT |
| VTBFHA | PRCTR | : | CEPC |
| VTBFHA | PS_POSID | : | PRPS |
| VTBFHA | RBUSA | : | TGSB |
| VTBFHA | RCNTR | : | CSKS |
| VTBFHA | RCOMVALCL | 1: CN | TRGC_COM_VALCL |
| VTBFHA | RCOMVALCL2 | 1: CN | TRGC_COM_VALCL |
| VTBFHA | RLDEPO | C: CN | TWD01 |
| VTBFHA | RMAID | C: CN | VTBMA |
| VTBFHA | RPORTB | : | TWPOB |
| VTBFHA | RPORTB2 | : | TWPOB |
| VTBFHA | RREFKONT | C: CN | T037S |
| VTBFHA | RREFKONT2 | C: CN | T037S |
| VTBFHA | SANLF | 1: CN | TZAF |
| VTBFHA | SFGTYP | 1: CN | AT01 |
| VTBFHA | SFHAART | 1: CN | AT10 |
| VTBFHA | SGSART | 1: CN | TZPA |
| VTBFHA | SKALID | 1: CN | TFACD |
| VTBFHA | SKALID2 | 1: CN | TFACD |
| VTBFHA | TBEGRU | C: N | TRBRG |
| VTBFHA | WGSCHFT | 1: CN | TCURC |