- Home
- Resources
- SAP Tables
- VIRAINV - RE Invoice Header
SAP Table VIRAINV
RE Invoice Header
VIRAINV (RE Invoice Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VIRAINV to other SAP tables.
Source: VIRAINV (RE Invoice Header)
VIRAINV table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| INVGUID |
GUID: Unique Internal Key for RE Invoice |
RERAINVGUID |
|
RAW |
|
16 |
0 |
|
| BUKRS |
Company Code |
BUKRS |
|
CHAR |
|
4 |
0 |
|
| INVNO |
Invoice Number |
RERAINVNO |
|
NUMC |
|
10 |
0 |
|
| FISC_YEAR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
0 |
|
| PROCESSGUID |
Generic Key of Process |
RECAPROCESSGUID |
VICAPROCESSID
|
RAW |
|
16 |
0 |
|
| PARTNER |
Business Partner Number |
BU_PARTNER |
|
CHAR |
|
10 |
0 |
|
| ADDRTYPE |
Address Type |
REBPADDRTYPE |
|
CHAR |
|
10 |
0 |
|
| ROLE |
Business Partner: Role |
REBPROLE |
|
CHAR |
|
6 |
0 |
|
| ITEMSELIND |
Type of Selection of Invoice Items |
RERAINVITEMSELIND |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Only Items from FI Documents |
| P |
Only Planned Items from Cash Flow |
| B |
From FI Documents and Cash Flow |
|
| DUEDATEFROM |
Start Date of Due Period of the Items |
RERADUEDATEFROM |
|
DATS |
|
8 |
0 |
|
| DUEDATETO |
End Date of Due Period of the Items |
RERADUEDATETO |
|
DATS |
|
8 |
0 |
|
| INCLCLEAREDITEMS |
Also Consider Cleared Items? |
RERAINVINCLCLEAREDITEMS |
|
CHAR |
|
1 |
0 |
Possible values
|
| CLEARCREDITITEMS |
Also Consider Credit Memo Items? |
RERAINVCLEARCREDITITEMS |
|
CHAR |
|
1 |
0 |
Possible values
|
| ALLOPENITEMS |
Also Consider Items Already Invoiced? |
RERAINVALLOPENITEMS |
|
CHAR |
|
1 |
0 |
Possible values
|
| COLLECTIND |
Grouping Option: Summarize Invoices |
RERAINVCOLLECTIND |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Per Recipient (Might Include Multiple Contracts) |
| 4 |
Per Contract |
|
| CUSTOMER |
Customer Number |
RERACUSTOMERNO |
|
CHAR |
|
10 |
0 |
|
| OBJNR |
Object Number of Only Contract of Invoice, Otherwise Blank |
RERAINVOBJNRSINGLE |
|
CHAR |
|
22 |
0 |
|
| OBJCOUNT |
Number of Contracts in This Invoice |
RERAINVOBJCOUNT |
|
INT4 |
|
10 |
0 |
|
| ISCREDITMEMO |
Credit Memo? |
RERAINVISCREDITMEMO |
|
CHAR |
|
1 |
0 |
Possible values
|
| ISMINORAMOUNT |
Trivial Amount? |
RERAINVISMINORAMOUNT |
|
CHAR |
|
1 |
0 |
Possible values
|
| CURRENCY |
Currency Key |
WAERS |
|
CUKY |
|
5 |
0 |
|
| TOTALGROSSAMOUNT |
Full Amount of Invoice |
RERAINVTOTALAMOUNT |
|
CURR |
|
15 |
2 |
|
| TOTALNETAMOUNT |
Net Amount of Invoice |
RERAINVTOTALNETAMOUNT |
|
CURR |
|
15 |
2 |
|
| TOTALTAXAMOUNT |
Tax Amount of Invoice |
RERAINVTOTALTAXAMOUNT |
|
CURR |
|
15 |
2 |
|
| RERF |
Entered by |
RERF |
|
CHAR |
|
12 |
0 |
|
| DERF |
First Entered on |
DERF |
|
DATS |
|
8 |
0 |
|
| TERF |
Time of Initial Entry |
TERF |
|
TIMS |
|
6 |
0 |
|
| REHER |
Source of initial entry |
REHER |
|
CHAR |
|
10 |
0 |
|
| RBEAR |
Employee ID |
RBEAR |
|
CHAR |
|
12 |
0 |
|
| DBEAR |
Last Edited on |
DBEAR |
|
DATS |
|
8 |
0 |
|
| TBEAR |
Last Edited at |
TBEAR |
|
TIMS |
|
6 |
0 |
|
| RBHER |
Editing Source |
RBHER |
|
CHAR |
|
10 |
0 |
|
| CANCELED |
Invoice Reversed? |
RERAINVCANCELED |
|
CHAR |
|
1 |
0 |
Possible values
|
| SFDOCGUID |
GUID for Document to be Output |
RECPSFDOCGUID |
|
RAW |
|
16 |
0 |
|
| PRINTEDON |
Invoice Last Printed On |
RERAINVPRINTEDON |
|
DATS |
|
8 |
0 |
|
| PRINTEDBY |
Invoice Last Printed By |
RERAINVPRINTEDBY |
|
CHAR |
|
12 |
0 |
|
VIRAINV foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| VIRAINV |
PROCESSGUID |
SYST |
MANDT |
VICAPROCESSID |
Process |
MANDT |
| VIRAINV |
PROCESSGUID |
VIRAINV |
PROCESSGUID |
VICAPROCESSID |
Process |
.INCLUDE |
| VIRAINV |
PROCESSGUID |
' ' |
|
VICAPROCESSID |
Process |
PROCESSGUID |
