VIRAINVITEM SAP (RE Invoice Item) Table details

Dictionary Type: Table
Description: RE Invoice Item




ABAP Code to SELECT data from VIRAINVITEM
Related tables to VIRAINVITEM
Access table VIRAINVITEM




Table field list including key, data, relationships and ABAP select examples

VIRAINVITEM is a standard SAP Table which is used to store RE Invoice Item data and is available within R/3 SAP systems depending on the version and release level.

The VIRAINVITEM table consists of various fields, each holding specific information or linking keys about RE Invoice Item data available in SAP. These include INVGUID (GUID: Unique Internal Key for RE Invoice), ITEMNO (Item Number in RE Invoice), OBJNR (Object Number of Contract for the Invoice Item), OBJNRCALC (Object Number for Calculation).. 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 VIRAINVITEM 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
INVGUIDGUID: Unique Internal Key for RE Invoice RERAINVGUIDRAW16VIRAINVRECAGUID
ITEMNOItem Number in RE Invoice RERAINVITEMNONUMC10POSNR_ACC
OBJNRObject Number of Contract for the Invoice Item RERAINVOBJNRCHAR22Assigned to domainJ_OBJNR
OBJNRCALCObject Number for Calculation RECDOBJNRCALCCHAR22Assigned to domainJ_OBJNRONR
ITEMSRCINDSource of Invoice Item RERAINVITEMSRCINDCHAR1RERAINVITEMSRCIND
CONDTYPECondition Type RECDCONDTYPECHAR4TIVCDCONDTYPEALPHARECDCONDTYPE
FLOWTYPEFlow Type RECDFLOWTYPECHAR4TIVCDFLOWTYPEALPHARECDFLOWTYPE
BLINEDATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
CALCFROMStart of Calculation Period DBERVONDATS8DATUM
CALCTOEnd of Calculation Period DBERBISDATS8DATUM
ISADVANCEPAYMENTCondition Is Advance Payment Condition RECDADVANCEPAYMENTCHAR1RECABOOL
CURRENCYLocal Currency RECACTLCCURRKEYCUKY5Assigned to domainWAERS
GROSSAMOUNTGross Amount in Local Currency RECACTLCGROSSAMOUNTCURR15(2) RECACURR
NETAMOUNTNet Amount in Local Currency RECACTLCNETAMOUNTCURR15(2) RECACURR
TAXAMOUNTTax Amount in Local Currency RECACTLCTAXAMOUNTCURR15(2) RECACURR
TAXTYPETax Type RERATAXTYPECHAR4TIVRATAXTYPERERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20TIVRATAXGROUPRERATAXGROUP
PYMTMETHPayment Method RERAPYMTMETHCHAR4CHAR4
PYMTTERMTerms of Payment Key RERAPYMTTERMCHAR4ZTERM
XMACCTSHEETITEMName of Contract Account Sheet Item RERAXLACCTSHEETITEMCHAR60RECAXLDESCRIPTION
DOCITEMIDCoded Key of FI Document Item for RE Internal Use RERADOCITEMIDCHAR30RERADOCITEMID
REFDOCIDReference Key of Document RERAREFDOCIDCHAR20CHAR20
REFITEMNOReference to Other Item Number of Document RERAREFITEMNONUMC10POSNR_ACC
LOGSYSTEMLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
OBJ_TYPEReference Transaction AWTYPCHAR5Assigned to domainAWTYP
OBJ_KEYReference Key AWKEYCHAR20AWKEY
PSTNGDATEPosting Date RERAPSTNGDATEDATS8RECADATE
DOCDATEDocument Date RERADOCDATEDATS8RECADATE
CLEARINGDATEClearing Date RERACLRNGDATEDATS8RECADATE
CLEARINGSTATUSClearing status RERACLEARINGSTATUSCHAR2CHAR02
PROCESSIDProcess Identification -> Accounting Reference Number RECAPROCESSIDCHAR16RECAPROCESSID
PSTNGPROCEDUREPosting Procedure RERAPROCEDURECHAR4Assigned to domainRERAPROCEDURE
XMACCTSHEETHDRName from Document Header RERAXLACCTSHEETHDRCHAR60RECAXLDESCRIPTION
TAXRATETax Rate RERATAXRATEDEC7(3) PRZ43V
TAXDATEDate of Tax Calculation RERATAXDATEDATS8RECADATE
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
HOUSEBKIDKey for House Bank RERAHOUSEBKIDCHAR15CHAR15
HOUSEBKACCKey for House Bank Account RERAHOUSEBKACCCHAR15CHAR15
BANKDETAILIDBank Details ID RERABANKDETAILIDCHAR15CHAR15
FCCURRKEYForeign Currency RECACTFCCURRKEYCUKY5Assigned to domainWAERS
FCGROSSAMOUNTGross Amount in Foreign Currency RECACTFCGROSSAMOUNTCURR15(2) RECACURR
FCNETAMOUNTNet Amount in Foreign Currency RECACTFCNETAMOUNTCURR15(2) RECACURR
FCTAXAMOUNTTax Amount in Foreign Currency RECACTFCTAXAMOUNTCURR15(2) RECACURR
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTRATEExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
CTDATEREQPlanned Translation Date RECACTDATEREQDATS8DATS
CTDATEACTActual Translation Date RECACTDATEACTDATS8DATS
POSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
TCCURRKEYDocument Currency (Transaction Currency) RERATCCURRKEYCUKY5Assigned to domainWAERS
TCGROSSAMOUNTGross Amount in Document Currency (Transaction Currency) RERATCGROSSAMOUNTCURR15(2) RECACURR
TCNETAMOUNTNet Amount in Document Currency (Transaction Currency) RERATCNETAMOUNTCURR15(2) RECACURR
TCTAXAMOUNTTax Amount in Document Currency (Transaction Currency) RERATCTAXAMOUNTCURR15(2) RECACURR
SEPAMNDIDSEPA Mandate: Unique Reference to Mandate per Vendor RETMSEPAMNDIDCHAR35RETMSEPAMNDID
SEPARECCRDIDSEPA Mandate: Creditor ID RETMSEPARECCRDIDCHAR35RETMSEPACRDID

Key field Non-key field



How do I retrieve data from SAP table VIRAINVITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIRAINVITEM to SELECT all data from the table
DATA: WA_VIRAINVITEM TYPE VIRAINVITEM.

SELECT SINGLE *
FROM VIRAINVITEM
INTO CORRESPONDING FIELDS OF WA_VIRAINVITEM
WHERE...

How to access SAP table VIRAINVITEM

Within an ECC or HANA version of SAP you can also view further information about VIRAINVITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!