SAP VIRAINV RE Invoice Header Table
Overview
VIRAINV is a standard SAP S/4HANA table that stores RE Invoice Header data. There are total 40 fields in the VIRAINV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIRAINV belongs to Rental Accounting (RE-FX-RA) module and is located in the package RE: Invoice for Rent (RE_RA_IV).
In addition, following links provide an overview of foreign key relationships, if any, that link VIRAINV to other SAP tables and standard CDS views available based on VIRAINV table in S/4HANA 2020.
Techincal Settings of VIRAINV
Below are technical details of the table VIRAINV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIRAINV Fields
The following table gives you an overview of the fields available in VIRAINV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INVGUID | GUID: Unique Internal Key for RE Invoice | RERAINVGUID | RAW | 16 | |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| INVNO | Invoice Number | RERAINVNO | NUMC | 10 | |
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | |
| PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | VICAPROCESSID | RAW | 16 |
| PARTNER | Business Partner Number | BU_PARTNER | * | CHAR | 10 |
| ADDRTYPE | Address Type | REBPADDRTYPE | * | CHAR | 10 |
| ROLE | Business Partner: Role | REBPROLE | * | CHAR | 6 |
| ITEMSELIND | Type of Selection of Invoice Items | RERAINVITEMSELIND | CHAR | 1 | |
| DUEDATEFROM | Start Date of Due Period of the Items | RERADUEDATEFROM | DATS | 8 | |
| DUEDATETO | End Date of Due Period of the Items | RERADUEDATETO | DATS | 8 | |
| INCLCLEAREDITEMS | Also Consider Cleared Items? | RERAINVINCLCLEAREDITEMS | CHAR | 1 | |
| CLEARCREDITITEMS | Also Consider Credit Memo Items? | RERAINVCLEARCREDITITEMS | CHAR | 1 | |
| ALLOPENITEMS | Also Consider Items Already Invoiced? | RERAINVALLOPENITEMS | CHAR | 1 | |
| COLLECTIND | Grouping Option: Summarize Invoices | RERAINVCOLLECTIND | CHAR | 1 | |
| SELECTPROCESSID | Selection by PROCESSID | RERAINVSELPROCESSID | CHAR | 1 | |
| CUSTOMER | Customer Number | RERACUSTOMERNO | CHAR | 10 | |
| OBJNR | Object Number of Only Contract of Invoice Otherwise Blank | RERAINVOBJNRSINGLE | * | CHAR | 22 |
| OBJCOUNT | Number of Contracts in This Invoice | RERAINVOBJCOUNT | INT4 | 10 | |
| ISCREDITMEMO | Credit Memo? | RERAINVISCREDITMEMO | CHAR | 1 | |
| ISMINORAMOUNT | Trivial Amount? | RERAINVISMINORAMOUNT | CHAR | 1 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| TOTALGROSSAMOUNT | Full Amount of Invoice | RERAINVTOTALAMOUNT | CURR | 15 | |
| TOTALNETAMOUNT | Net Amount of Invoice | RERAINVTOTALNETAMOUNT | CURR | 15 | |
| TOTALTAXAMOUNT | Tax Amount of Invoice | RERAINVTOTALTAXAMOUNT | CURR | 15 | |
| 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 | |
| CANCELED | Invoice Reversed? | RERAINVCANCELED | CHAR | 1 | |
| SFDOCGUID | GUID for Document to be Output | RECPSFDOCGUID | RAW | 16 | |
| PRINTEDON | Invoice Last Printed On | RERAINVPRINTEDON | DATS | 8 | |
| PRINTEDBY | Invoice Last Printed By | RERAINVPRINTEDBY | CHAR | 12 | |
| RSGUID | GUID of Only Reservation of Invoice Otherwise Blank | RERAINVRSGUIDSINGLE | RAW | 16 | |
| RSCOUNT | Number of Reservations in This Invoice | RERAINVRESCOUNT | INT4 | 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 VIRAINV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIRAINV | PROCESSGUID | 1: CN | VICAPROCESSID |