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.

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
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
X Yes
NULL No
CLEARCREDITITEMS Also Consider Credit Memo Items? RERAINVCLEARCREDITITEMS CHAR 1 0
X Yes
NULL No
ALLOPENITEMS Also Consider Items Already Invoiced? RERAINVALLOPENITEMS CHAR 1 0
X Yes
NULL No
COLLECTIND Grouping Option: Summarize Invoices RERAINVCOLLECTIND CHAR 1 0
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
X Yes
NULL No
ISMINORAMOUNT Trivial Amount? RERAINVISMINORAMOUNT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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 ' ' VICAPROCESSID Process PROCESSGUID
VIRAINV PROCESSGUID SYST MANDT VICAPROCESSID Process MANDT
VIRAINV PROCESSGUID VIRAINV PROCESSGUID VICAPROCESSID Process .INCLUDE