SAP VTIFHA Underlying transaction Table
Overview
VTIFHA is a standard SAP S/4HANA table that stores Underlying transaction data. There are total 44 fields in the VTIFHA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTIFHA belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 application development for Treasury forward trading (FTT).
In addition, following links provide an overview of foreign key relationships, if any, that link VTIFHA to other SAP tables and standard CDS views available based on VTIFHA table in S/4HANA 2020.
Techincal Settings of VTIFHA
Below are technical details of the table VTIFHA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTIFHA Fields
The following table gives you an overview of the fields available in VTIFHA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| 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 | NUMC | 3 | |
| SFGTYP | Transaction Category | TB_SFGTYP | NUMC | 3 | |
| SGSART | Product Type | VVSART | TZPA | CHAR | 3 |
| SFHAART | Financial Transaction Type | TB_SFHAART | AT10 | CHAR | 3 |
| RGATT | Class | TI_RGATT | CHAR | 13 | |
| 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 | Dummy function | DUMMY_3 | CHAR | 3 | |
| RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8 | |
| RREFKONT2 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8 | |
| RPORTB | Portfolio | RPORTB | 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 | TCURC | 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 | CHAR | 2 | |
| SKALID2 | Factory calendar | SKALID | 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 | CHAR | 22 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| RLDEPO | Securities Account | RLDEPO | CHAR | 10 | |
| ZUONR | Finance Project | TB_TFPROJ | CHAR | 13 | |
| DELFZ | End of Term | DELFZ | DATS | 8 | |
| ABWTYP | Processing Category | TB_ABWTYP | CHAR | 5 | |
| VRFHA | Reference Transaction (Rollover/Premature Settlement) | TB_VORFHA | CHAR | 13 | |
| SINCLBE | Calculation Period: Start Inclusive vs. End Inclusive | TB_SINCLBE | CHAR | 1 | |
| RCOMVALCL | General Valuation Class | TPM_COM_VAL_CLASS | NUMC | 4 | |
| ROLLOVERFL | Poss. to Roll Over | TI_ROLLOVERFL | CHAR | 1 | |
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18 | |
| FIMA_CALCULATION | Cash Flow Calculation | TB_FIMA_CALCULATION | CHAR | 2 |
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 VTIFHA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTIFHA | MANDT | 1: CN | T000 |
| VTIFHA | SFHAART | 1: CN | AT10 |
| VTIFHA | SGSART | 1: CN | TZPA |
| VTIFHA | WGSCHFT | 1: CN | TCURC |
| VTIFHA | WGSCHFT2 | C: CN | TCURC |