SAP VTIFHAPO Underlying transaction flows Table
Overview
VTIFHAPO is a standard SAP S/4HANA table that stores Underlying transaction flows data. There are total 86 fields in the VTIFHAPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTIFHAPO 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 VTIFHAPO to other SAP tables and standard CDS views available based on VTIFHAPO table in S/4HANA 2020.
Techincal Settings of VTIFHAPO
Below are technical details of the table VTIFHAPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTIFHAPO Fields
The following table gives you an overview of the fields available in VTIFHAPO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | |
| RFHAZU | Transaction Activity | TB_RFHAZU | NUMC | 5 | |
| DCRDAT | Entered On | TB_CRDAT | DATS | 8 | |
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | |
| RFHAZB | Transaction Flow | TB_RFHAZB | NUMC | 4 | |
| CRUSER | Entered By | TB_CRUSER | CHAR | 12 | |
| 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 | |
| SFHAZBA | Flow Type | TB_SFHAZBA | CHAR | 4 | |
| SBKKLAS | Classification of Flows and Conditions | TB_SBKKLAS | CHAR | 1 | |
| SBKTYP | Category of Flows and Conditions | TB_SBKTYP | CHAR | 2 | |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | |
| SSIGN | Direction of Flow | TB_SSIGN | CHAR | 1 | |
| SHERKUNFT | Display Area of Flow or Condition | TB_SHERK | CHAR | 4 | |
| RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | |
| RKOND | Condition | TB_KOND | NUMC | 4 | |
| DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | |
| NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | |
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | |
| RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8 | |
| SBZVABW | Alternative Payment Details Stated in Flow | TB_SBZVABW | CHAR | 1 | |
| RAHABKI | Short Key for Own House Bank | TB_RHABKI | CHAR | 5 | |
| RAHKTID | Short Key for House Bank Account | TB_RHKTID | CHAR | 5 | |
| RPZAHL | Payer/Payee | TB_RPZAHL_NEW | CHAR | 10 | |
| RPBANK | Partner Bank Details | TB_RPBANK | CHAR | 4 | |
| SZART | Payment Transaction | TB_SZART | CHAR | 1 | |
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | |
| UZAWE | Payment method supplement | UZAWE | CHAR | 2 | |
| SBEWEBE | Posting Status of Flow | TB_SBEWEBE | CHAR | 1 | |
| SSPRGRD | Reason Why Flow Is Blocked for Posting | TB_SSPRGRD | NUMC | 1 | |
| SBFREI | Release Given for Flow to Be Posted? | TB_SBFREI | CHAR | 1 | |
| DFAELL | Due Date | TB_DFAELL | DATS | 8 | |
| DZTERM | Payment or Delivery Date | TB_DZTERM | DATS | 8 | |
| BZBETR | Payment Amount in Payment Currency | TB_BZBETR | CURR | 13 | |
| WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | |
| BHWBETR | Payment Amount in Local Currency | TB_HWBETR | CURR | 13 | |
| KHWKURS | Local Currency Rate | TB_KHWKURS | DEC | 9 | |
| ASTUECK | No. of Units for Financial Instruments | TB_ASTUECK | DEC | 15 | |
| BPRICE | Price per Unit | TB_BPRICE | CURR | 13 | |
| WPRICE | Price Currency | TB_WPRICE | CUKY | 5 | |
| BHWPREIS | Price in Local Currency | TB_HWPREIS | CURR | 13 | |
| BINDEX | Value of a Point | TB_BINDEX | CURR | 13 | |
| VVBASIS | Price in Points | TB_VVBASIS | DEC | 11 | |
| PWKURS | Price as Percentage Quotation | TB_PWKURS | DEC | 10 | |
| BNWHR | Nominal Amount | TB_BNWHR | CURR | 13 | |
| RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | |
| SKURSART | Rate/Price Type - Treasury Instruments | TI_KURSART | CHAR | 2 | |
| DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | |
| DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | |
| ATAGE | Number of Days | VVATAGE | NUMC | 6 | |
| ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | |
| PKOND | Percentage rate for condition items | PKOND | DEC | 10 | |
| DPKOND | Fixing Date of Percentage Rate from Condition | VVDPKOND | DATS | 8 | |
| DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | |
| SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| WBASIS | Currency of Calculation Basis | TB_WBASIS | CUKY | 5 | |
| SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | |
| SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | |
| SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | |
| SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | |
| SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | |
| SAEND | Change Indicator for FiMa Flow Records | TFM_SAEND | NUMC | 1 | |
| DVALUT | Calculation Date | DVALUT | DATS | 8 | |
| SVINCL | Inclusive indicator for value date | VVSVINCL | NUMC | 1 | |
| SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | |
| SBWGARTREF | Referenced Flow Type | TB_SBWGREF | CHAR | 4 | |
| SKHWFIX | Indicator for Translation into Local Currency | TB_SKHWFIX | CHAR | 1 | |
| ZUONR | Assignment number | DZUONR | CHAR | 18 | |
| BPPRC | Security Price for Percentage Quotation | TB_BPPRC | DEC | 15 | |
| BUPRC | Security Price Without Currency Ref. with Unit Quotation | TB_BUPRC | DEC | 15 | |
| SRUNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | |
| REGI_STATE | Status of Interest Rate Adjustment | TB_IRA_REGISTRATION_STATE | CHAR | 2 | |
| QUANTITY | Quantity | FTR_QUAN | QUAN | 13 | |
| UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | |
| CONTRACT_PRICE | Commodity Price | FTR_COMPRICE | DEC | 13 | |
| SPOT_PRICE | Commodity Spot Price | FTR_COMSPOT | DEC | 13 | |
| CONTANGO_BACKWRD | Commodity Contango / Backwardation | FTR_CONBACK | DEC | 13 | |
| COMMODITY_ID | Commodity ID (obsolete) | TRCO_COMM_ID | CHAR | 18 | |
| PRICE_CURR_UNIT | Currency Unit of the Rate | TB_RUNIT | CHAR | 5 | |
| PRICE_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | T006 | UNIT | 3 |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 20 | |
| MIC | Market Identifier Code | TBA_MIC | 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 VTIFHAPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTIFHAPO | PRICE_UOM | : | T006 |