SAP VTBMROR invoice verification: open requests Table
Overview
VTBMROR is a standard SAP S/4HANA table that stores invoice verification: open requests data. There are total 24 fields in the VTBMROR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTBMROR 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 VTBMROR to other SAP tables and standard CDS views available based on VTBMROR table in S/4HANA 2020.
Techincal Settings of VTBMROR
Below are technical details of the table VTBMROR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTBMROR Fields
The following table gives you an overview of the fields available in VTBMROR
| 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 VTBMROR