SAP table VIRAINV (RE Invoice Header)
SAP table VIRAINV has 2 primary key fields being MANDT,INVGUID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
MANDT
GUID: Unique Internal Key for RE Invoice
RAW
16
0
RERAINVGUID
BUKRS
Company Code
CHAR
4
0
BUKRS
INVNO
Invoice Number
NUMC
10
0
RERAINVNO
FISC_YEAR
Fiscal Year
NUMC
4
0
GJAHR
PROCESSGUID
Generic Key of Process
RAW
16
0
VICAPROCESSID
RECAPROCESSGUID
PARTNER
Business Partner Number
CHAR
10
0
BU_PARTNER
ADDRTYPE
Address Type
CHAR
10
0
*
REBPADDRTYPE
ROLE
Business Partner: Role
CHAR
6
0
*
REBPROLE
ITEMSELIND
Type of Selection of Invoice Items
CHAR
1
0
RERAINVITEMSELIND
Possible values
Only Items from FI Documents
B
From FI Documents and Cash Flow
P
Only Planned Items from Cash Flow
DUEDATEFROM
Start Date of Due Period of the Items
DATS
8
0
RERADUEDATEFROM
DUEDATETO
End Date of Due Period of the Items
DATS
8
0
RERADUEDATETO
INCLCLEAREDITEMS
Also Consider Cleared Items?
CHAR
1
0
RERAINVINCLCLEAREDITEMS
CLEARCREDITITEMS
Also Consider Credit Memo Items?
CHAR
1
0
RERAINVCLEARCREDITITEMS
ALLOPENITEMS
Also Consider Items Already Invoiced?
CHAR
1
0
RERAINVALLOPENITEMS
COLLECTIND
Grouping Option: Summarize Invoices
CHAR
1
0
RERAINVCOLLECTIND
Possible values
1
Per Recipient (Might Include Multiple Contracts)
4
Per Contract
SELECTPROCESSID
Selection by PROCESSID
CHAR
1
0
RERAINVSELPROCESSID
CUSTOMER
Customer Number
CHAR
10
0
RERACUSTOMERNO
OBJNR
Object Number of Only Contract of Invoice, Otherwise Blank
CHAR
22
0
*
RERAINVOBJNRSINGLE
OBJCOUNT
Number of Contracts in This Invoice
INT4
10
0
RERAINVOBJCOUNT
ISCREDITMEMO
Credit Memo?
CHAR
1
0
RERAINVISCREDITMEMO
ISMINORAMOUNT
Trivial Amount?
CHAR
1
0
RERAINVISMINORAMOUNT
CURRENCY
Currency Key
CUKY
5
0
*
WAERS
TOTALGROSSAMOUNT
Full Amount of Invoice
CURR
15
2
RERAINVTOTALAMOUNT
TOTALNETAMOUNT
Net Amount of Invoice
CURR
15
2
RERAINVTOTALNETAMOUNT
TOTALTAXAMOUNT
Tax Amount of Invoice
CURR
15
2
RERAINVTOTALTAXAMOUNT
RERF
Entered By
CHAR
12
0
RERF
DERF
First Entered On
DATS
8
0
DERF
TERF
Time of Creation
TIMS
6
0
TERF
REHER
Source of Initial Entry
CHAR
10
0
REHER
RBEAR
Employee ID
CHAR
12
0
RBEAR
DBEAR
Last Edited On
DATS
8
0
DBEAR
TBEAR
Last Edited At
TIMS
6
0
TBEAR
RBHER
Editing Source
CHAR
10
0
RBHER
CANCELED
Invoice Reversed?
CHAR
1
0
RERAINVCANCELED
SFDOCGUID
GUID for Document to be Output
RAW
16
0
RECPSFDOCGUID
PRINTEDON
Invoice Last Printed On
DATS
8
0
RERAINVPRINTEDON
PRINTEDBY
Invoice Last Printed By
CHAR
12
0
RERAINVPRINTEDBY
RSGUID
GUID of Only Reservation of Invoice, Otherwise Blank
RAW
16
0
RERAINVRSGUIDSINGLE
RSCOUNT
Number of Reservations in This Invoice
INT4
10
0
RERAINVRESCOUNT
VIRAINV foreign key relationships