SAP VTBFIOR FI: open requests Table
Overview
VTBFIOR is a standard SAP S/4HANA table that stores FI: open requests data. There are total 24 fields in the VTBFIOR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBFIOR belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package Application development R/3 treasury hedging (FTH).
In addition, following links provide an overview of foreign key relationships, if any, that link VTBFIOR to other SAP tables and standard CDS views available based on VTBFIOR table in S/4HANA 2020.
Techincal Settings of VTBFIOR
Below are technical details of the table VTBFIOR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBFIOR Fields
The following table gives you an overview of the fields available in VTBFIOR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| BUZEI | Document line item number in a Financial Accounting document | BF_BUZEI | NUMC | 3 | |
| LFDNR | 2 Byte Signed Integer | INT2 | INT2 | 5 | |
| SSTATUS | Status | TB_SSTATUS | NUMC | 1 | |
| SSIGN | Direction of flow | TH_SSIGN | CHAR | 1 | |
| DVZAHL | Expected Payment Date | TB_DVZAHL | DATS | 8 | |
| BTRANS | Amount in Transaction Currency | TB_BTRANS | CURR | 13 | |
| WTRANS | Transaction currency (currency subject to risk) | TB_WTRANS | * | CUKY | 5 |
| WBASIS | Base currency (usually local currency) | TH_WBASIS | * | CUKY | 5 |
| KONTRH | Business partner (customer vendor counterparty..) | TH_KUNNR | * | CHAR | 10 |
| KOART | Account type | KOART | CHAR | 1 | |
| SIANUSER | Entered by | TH_CRUSER | CHAR | 12 | |
| SIANDATE | Entry date | TH_DCRDAT | DATS | 8 | |
| SIANTIME | Entry time | TH_TCRTIM | TIMS | 6 | |
| SIANUUSER | Last changed by | TH_UPUSER | CHAR | 12 | |
| SIANUDATE | Changed on | TH_DUPDAT | DATS | 8 | |
| SIANUTIME | Time changed | TH_TUPTIM | TIMS | 6 | |
| N_BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| N_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| N_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| N_RSICH | Hedge number | TB_RSICH | * | CHAR | 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 VTBFIOR