AVIRAINVITEM SAP (Change Structure for RE Invoice Item (VIRAINVITEM)) Structure details

Dictionary Type: Structure
Description: Change Structure for RE Invoice Item (VIRAINVITEM)




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




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

AVIRAINVITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Structure for RE Invoice Item (VIRAINVITEM)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AVIRAINVITEM TYPE AVIRAINVITEM.

The AVIRAINVITEM table consists of various fields, each holding specific information or linking keys about Change Structure for RE Invoice Item (VIRAINVITEM) data available in SAP. These include MANDT (Client), INVGUID (GUID: Unique Internal Key for RE Invoice), ITEMNO (Item Number in RE Invoice), OBJNR (Object Number of Contract for the Invoice Item).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AVIRAINVITEM structure 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
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



How do I retrieve data from SAP structure AVIRAINVITEM using ABAP code?

As AVIRAINVITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AVIRAINVITEM as there is no data to select.

How to access SAP table AVIRAINVITEM

Within an ECC or HANA version of SAP you can also view further information about AVIRAINVITEM 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!