SAP VTBPFHAPO Treasury: Flow Shells Table
Overview
VTBPFHAPO is a standard SAP S/4HANA table that stores Treasury: Flow Shells data. There are total 79 fields in the VTBPFHAPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBPFHAPO 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 VTBPFHAPO to other SAP tables and standard CDS views available based on VTBPFHAPO table in S/4HANA 2020.
Techincal Settings of VTBPFHAPO
Below are technical details of the table VTBPFHAPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBPFHAPO Fields
The following table gives you an overview of the fields available in VTBPFHAPO
| 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 | |
| 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 | TZB0A | CHAR | 4 |
| SBKKLAS | Classification of Flows and Conditions | TB_SBKKLAS | CHAR | 1 | |
| SBKTYP | Category of Flows and Conditions | TB_SBKTYP | AT07 | CHAR | 2 |
| SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | AT40 | 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 | TZK01 | NUMC | 4 |
| RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | T037S | CHAR | 8 |
| SBZVABW | Alternative Payment Details Stated in Flow | TB_SBZVABW | CHAR | 1 | |
| RAHABKI | Short Key for Own House Bank | TB_RHABKI | T012 | CHAR | 5 |
| RAHKTID | Short Key for House Bank Account | TB_RHKTID | T012K | CHAR | 5 |
| RPZAHL | Payer/Payee | TB_RPZAHL_NEW | BUT000 | CHAR | 10 |
| RPBANK | Partner Bank Details | TB_RPBANK | CHAR | 4 | |
| SZART | Payment Transaction | TB_SZART | CHAR | 1 | |
| ZLSCH | Payment Method | DZLSCH | T042Z | CHAR | 1 |
| UZAWE | Payment method supplement | UZAWE | T042F | 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 | |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| DBUCHUNG | Posting Date in the Document | BUDAT | DATS | 8 | |
| 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 | TCURC | 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 | TCURC | 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 | TWH01 | CHAR | 10 |
| SKURSART | Rate/Price Type - Treasury Instruments | TI_KURSART | TW56 | 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 | |
| SZSREF | Reference Interest Rate | SZSREF | T056R | CHAR | 10 |
| SFORMREF | Formula Reference | TB_XFORMBE | AT30 | CHAR | 4 |
| SVARNAME | Variable Name | TB_VARNAME | CHAR | 4 | |
| 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 | |
| SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | |
| BBASIS | Calculation Base Amount | BBASIS | CURR | 13 | |
| WBASIS | Currency of Calculation Basis | TB_WBASIS | TCURC | 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 | |
| SALTSATZ | Checkbox | XFELD | CHAR | 1 | |
| REGI_STATE | Status of Interest Rate Adjustment | TB_IRA_REGISTRATION_STATE | 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 VTBPFHAPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTBPFHAPO | BUKRS | 1: CN | T001 |
| VTBPFHAPO | MANDT | 1: CN | T000 |
| VTBPFHAPO | RAHABKI | C: CN | T012 |
| VTBPFHAPO | RAHKTID | C: CN | T012K |
| VTBPFHAPO | RFHA | 1: CN | VTBFHA |
| VTBPFHAPO | RHANDPL | C: CN | TWH01 |
| VTBPFHAPO | RPZAHL | C: CN | BUT000 |
| VTBPFHAPO | RREFKONT | C: CN | T037S |
| VTBPFHAPO | SBERFIMA | : | AT40 |
| VTBPFHAPO | SBKTYP | 1: CN | AT07 |
| VTBPFHAPO | SFHAZBA | 1: CN | TZB0A |
| VTBPFHAPO | SFORMREF | C: CN | AT30 |
| VTBPFHAPO | SKOART | 1: CN | TZK01 |
| VTBPFHAPO | SKURSART | C: CN | TW56 |
| VTBPFHAPO | SZSREF | C: CN | T056R |
| VTBPFHAPO | UZAWE | C: CN | T042F |
| VTBPFHAPO | WBASIS | C: CN | TCURC |
| VTBPFHAPO | WPRICE | C: CN | TCURC |
| VTBPFHAPO | WZBETR | 1: CN | TCURC |
| VTBPFHAPO | ZLSCH | C: CN | T042Z |