SAP VIMIIH Invoice Header Table
Overview
VIMIIH is a standard SAP S/4HANA table that stores Invoice Header data. There are total 31 fields in the VIMIIH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIMIIH belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIMIIH to other SAP tables and standard CDS views available based on VIMIIH table in S/4HANA 2020.
Techincal Settings of VIMIIH
Below are technical details of the table VIMIIH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIMIIH Fields
The following table gives you an overview of the fields available in VIMIIH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| SRECHNGNR | Rent Invoice: Invoice Number | VVRECHNGNR | NUMC | 10 | |
| SRECHNGJAHR | Calendar Year of the Invoice Number | VVRECHNGJAHR | NUMC | 4 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| PARTNR | Business Partner Number | BP_PARTNR | BP000 | CHAR | 10 |
| KUNNR_P | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| ADR_REF | Address ID | BP_ADR_REF | TP14 | CHAR | 10 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | |
| BVTYP | Partner bank type | BVTYP | CHAR | 4 | |
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | |
| DINVFROM | Start Date for Due Period of Open Items | VVDINVFROM | DATS | 8 | |
| DINVTO | End Date for Due Period of Open Items | VVDINVTO | DATS | 8 | |
| CREDCH | Clear credit memo items? | RECPCREDCH | CHAR | 1 | |
| INVALLOPENITEMS | Also print open items that have already been invoiced | RECPINVALLOPENITEMS | CHAR | 1 | |
| INVCOLLECT | Grouping option: group invoices for each ... | RECPINVCOLLECT | CHAR | 1 | |
| INVPERIOD | Grouping option: divide up invoices for each ... | RECPINVPERIOD | CHAR | 1 | |
| DRUCKDTM | Print date for letters in Real Estate Management | DRUCKDTM | DATS | 8 | |
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 13 | |
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| ALTPAYER | Does business partner act as alternative payer? | RECPALTPAYER | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RQIDENT | Spool number | RQIDENT | CHAR | 10 |
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 VIMIIH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIMIIH | ADR_REF | 1: CN | TP14 |
| VIMIIH | BUKRS | 1: CN | T001 |
| VIMIIH | KUNNR_P | 1: CN | KNA1 |
| VIMIIH | PARTNR | 1: CN | BP000 |
| VIMIIH | WAERS | 1: CN | TCURC |