1. Home
  2. Resources
  3. SAP Tables
  4. VIRAINVITEM - RE Invoice Item

SAP Table VIRAINVITEM

RE Invoice Item

VIRAINVITEM (RE Invoice Item) 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 VIRAINVITEM to other SAP tables.

Source: VIRAINVITEM (RE Invoice Item)

VIRAINVITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INVGUID GUID: Unique Internal Key for RE Invoice RERAINVGUID VIRAINV RAW 16 0
ITEMNO Item Number in RE Invoice RERAINVITEMNO NUMC 10 0
OBJNR Object Number of Contract for the Invoice Item RERAINVOBJNR CHAR 22 0
OBJNRCALC Object Number for Calculation RECDOBJNRCALC CHAR 22 0
ITEMSRCIND Source of Invoice Item RERAINVITEMSRCIND CHAR 1 0
NULL Open Item from FI Document
P Planned Item from Cash Flow
CONDTYPE Condition Type RECDCONDTYPE TIVCDCONDTYPE CHAR 4 0
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
BLINEDATE Baseline Date for Due Date Calculation DZFBDT DATS 8 0
CALCFROM Start of Calculation Period DBERVON DATS 8 0
CALCTO End of Calculation Period DBERBIS DATS 8 0
ISADVANCEPAYMENT Condition Is Advance Payment Condition RECDADVANCEPAYMENT CHAR 1 0
X Yes
NULL No
CURRENCY Local Currency RECACTLCCURRKEY CUKY 5 0
GROSSAMOUNT Gross Amount in Local Currency RECACTLCGROSSAMOUNT CURR 15 2
NETAMOUNT Net Amount in Local Currency RECACTLCNETAMOUNT CURR 15 2
TAXAMOUNT Tax Amount in Local Currency RECACTLCTAXAMOUNT CURR 15 2
TAXTYPE Tax Type RERATAXTYPE TIVRATAXTYPE CHAR 4 0
TAXGROUP Tax Group RERATAXGROUP TIVRATAXGROUP CHAR 20 0
PYMTMETH Payment Method RERAPYMTMETH CHAR 4 0
PYMTTERM Terms of Payment Key RERAPYMTTERM CHAR 4 0
XMACCTSHEETITEM Name of Contract Account Sheet Item RERAXLACCTSHEETITEM CHAR 60 0
DOCITEMID Coded Key of FI Document Item for RE Internal Use RERADOCITEMID CHAR 30 0
REFDOCID Reference Key of Document RERAREFDOCID CHAR 20 0
REFITEMNO Reference to Other Item Number of Document RERAREFITEMNO NUMC 10 0
LOGSYSTEM Logical System LOGSYSTEM CHAR 10 0
OBJ_TYPE Reference Transaction AWTYP CHAR 5 0
OBJ_KEY Reference Key AWKEY CHAR 20 0
PSTNGDATE Posting Date RERAPSTNGDATE DATS 8 0
DOCDATE Document Date RERADOCDATE DATS 8 0
CLEARINGDATE Clearing Date RERACLRNGDATE DATS 8 0
CLEARINGSTATUS Clearing status RERACLEARINGSTATUS CHAR 2 0
PROCESSID Process Identification -> Accounting Reference Number RECAPROCESSID CHAR 16 0
PSTNGPROCEDURE Posting Procedure RERAPROCEDURE CHAR 4 0
XMACCTSHEETHDR Name from Document Header RERAXLACCTSHEETHDR CHAR 60 0
TAXRATE Tax Rate RERATAXRATE DEC 7 3
TAXDATE Date of Tax Calculation RERATAXDATE DATS 8 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
HOUSEBKID Key for House Bank RERAHOUSEBKID CHAR 15 0
HOUSEBKACC Key for House Bank Account RERAHOUSEBKACC CHAR 15 0
BANKDETAILID Bank Details ID RERABANKDETAILID CHAR 15 0
FCCURRKEY Foreign Currency RECACTFCCURRKEY CUKY 5 0
FCGROSSAMOUNT Gross Amount in Foreign Currency RECACTFCGROSSAMOUNT CURR 15 2
FCNETAMOUNT Net Amount in Foreign Currency RECACTFCNETAMOUNT CURR 15 2
FCTAXAMOUNT Tax Amount in Foreign Currency RECACTFCTAXAMOUNT CURR 15 2
CTRULE Currency Translation Rule RECACTRULE CHAR 20 0
CTRATE Exchange Rate RECACTRATE DEC 9 5
CTDATEREQ Planned Translation Date RECACTDATEREQ DATS 8 0
CTDATEACT Actual Translation Date RECACTDATEACT DATS 8 0
POSTCDCURR Post in Condition Currency RECACTPOSTCDCURR CHAR 1 0
X Yes
NULL No
TCCURRKEY Document Currency (Transaction Currency) RERATCCURRKEY CUKY 5 0
TCGROSSAMOUNT Gross Amount in Document Currency (Transaction Currency) RERATCGROSSAMOUNT CURR 15 2
TCNETAMOUNT Net Amount in Document Currency (Transaction Currency) RERATCNETAMOUNT CURR 15 2
TCTAXAMOUNT Tax Amount in Document Currency (Transaction Currency) RERATCTAXAMOUNT CURR 15 2
SEPAMNDID SEPA Mandate: Unique Reference to Mandate per Vendor RETMSEPAMNDID CHAR 35 0
SEPARECCRDID SEPA Mandate: Creditor ID RETMSEPARECCRDID CHAR 35 0

VIRAINVITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VIRAINVITEM CONDTYPE SYST MANDT TIVCDCONDTYPE Condition Type MANDT
VIRAINVITEM CONDTYPE VIRAINVITEM CONDTYPE TIVCDCONDTYPE Condition Type CONDTYPE
VIRAINVITEM FLOWTYPE SYST MANDT TIVCDFLOWTYPE Flow Type MANDT
VIRAINVITEM FLOWTYPE VIRAINVITEM FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
VIRAINVITEM INVGUID SYST MANDT VIRAINV RE Invoice Header MANDT
VIRAINVITEM INVGUID VIRAINVITEM INVGUID VIRAINV RE Invoice Header INVGUID
VIRAINVITEM TAXGROUP SYST MANDT TIVRATAXGROUP Tax Group MANDT
VIRAINVITEM TAXGROUP VIRAINVITEM TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
VIRAINVITEM TAXTYPE SYST MANDT TIVRATAXTYPE Tax Types MANDT
VIRAINVITEM TAXTYPE * TIVRATAXTYPE Tax Types COUNTRY
VIRAINVITEM TAXTYPE VIRAINVITEM TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE