VIRAINV SAP (RE Invoice Header) Table details
Dictionary Type: Table
Description: RE Invoice Header
Description: RE Invoice Header
Table field list including key, data, relationships and ABAP select examples
VIRAINV is a standard SAP Table which is used to store RE Invoice Header data and is available within R/3 SAP systems depending on the version and release level.
The VIRAINV table consists of various fields, each holding specific information or linking keys about RE Invoice Header data available in SAP. These include INVGUID (GUID: Unique Internal Key for RE Invoice), BUKRS (Company Code), INVNO (Invoice Number), FISC_YEAR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIRAINV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
INVGUID | GUID: Unique Internal Key for RE Invoice | RERAINVGUID | RAW | 16 | RECAGUID | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
INVNO | Invoice Number | RERAINVNO | NUMC | 10 | RERAINVNO | ||||
FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
PROCESSGUID | Generic Key of Process | RECAPROCESSGUID | RAW | 16 | VICAPROCESSID | RECAGUID | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ADDRTYPE | Address Type | REBPADDRTYPE | CHAR | 10 | Assigned to domain | BU_ADRKIND | |||
ROLE | Business Partner: Role | REBPROLE | CHAR | 6 | Assigned to domain | BU_ROLE | |||
ITEMSELIND | Type of Selection of Invoice Items | RERAINVITEMSELIND | CHAR | 1 | RERAINVITEMSELIND | ||||
DUEDATEFROM | Start Date of Due Period of the Items | RERADUEDATEFROM | DATS | 8 | RECADATEBEG | ||||
DUEDATETO | End Date of Due Period of the Items | RERADUEDATETO | DATS | 8 | REDAT | RECADATEEND | |||
INCLCLEAREDITEMS | Also Consider Cleared Items? | RERAINVINCLCLEAREDITEMS | CHAR | 1 | RECABOOL | ||||
CLEARCREDITITEMS | Also Consider Credit Memo Items? | RERAINVCLEARCREDITITEMS | CHAR | 1 | RECABOOL | ||||
ALLOPENITEMS | Also Consider Items Already Invoiced? | RERAINVALLOPENITEMS | CHAR | 1 | RECABOOL | ||||
COLLECTIND | Grouping Option: Summarize Invoices | RERAINVCOLLECTIND | CHAR | 1 | RERAINVCOLLECTIND | ||||
CUSTOMER | Customer Number | RERACUSTOMERNO | CHAR | 10 | ALPHA | RERAPARTNERNO | KUN | C_KUNNR | |
OBJNR | Object Number of Only Contract of Invoice, Otherwise Blank | RERAINVOBJNRSINGLE | CHAR | 22 | Assigned to domain | J_OBJNR | |||
OBJCOUNT | Number of Contracts in This Invoice | RERAINVOBJCOUNT | INT4 | 10 | INT4 | ||||
ISCREDITMEMO | Credit Memo? | RERAINVISCREDITMEMO | CHAR | 1 | RECABOOL | ||||
ISMINORAMOUNT | Trivial Amount? | RERAINVISMINORAMOUNT | CHAR | 1 | RECABOOL | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
TOTALGROSSAMOUNT | Full Amount of Invoice | RERAINVTOTALAMOUNT | CURR | 15(2) | RECACURR | ||||
TOTALNETAMOUNT | Net Amount of Invoice | RERAINVTOTALNETAMOUNT | CURR | 15(2) | RECACURR | ||||
TOTALTAXAMOUNT | Tax Amount of Invoice | RERAINVTOTALTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
CANCELED | Invoice Reversed? | RERAINVCANCELED | CHAR | 1 | RECABOOL | ||||
SFDOCGUID | GUID for Document to be Output | RECPSFDOCGUID | RAW | 16 | RECAGUID | ||||
PRINTEDON | Invoice Last Printed On | RERAINVPRINTEDON | DATS | 8 | RECADATE | ||||
PRINTEDBY | Invoice Last Printed By | RERAINVPRINTEDBY | CHAR | 12 | SYCHAR12 |
Key field | Non-key field |
How do I retrieve data from SAP table VIRAINV using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIRAINV to SELECT all data from the tableDATA: WA_VIRAINV TYPE VIRAINV.
SELECT SINGLE *
FROM VIRAINV
INTO CORRESPONDING FIELDS OF WA_VIRAINV
WHERE...
How to access SAP table VIRAINV
Within an ECC or HANA version of SAP you can also view further information about VIRAINV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects