AVIRAINV SAP (Change Structure for RE Invoice Header (VIRAINV)) Structure details

Dictionary Type: Structure
Description: Change Structure for RE Invoice Header (VIRAINV)




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




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

AVIRAINV 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 Header (VIRAINV)" 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_AVIRAINV TYPE AVIRAINV.

The AVIRAINV table consists of various fields, each holding specific information or linking keys about Change Structure for RE Invoice Header (VIRAINV) data available in SAP. These include MANDT (Client), INVGUID (GUID: Unique Internal Key for RE Invoice), BUKRS (Company Code), INVNO (Invoice Number).. 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 AVIRAINV 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 RERAINVGUIDRAW16RECAGUID
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
INVNOInvoice Number RERAINVNONUMC10RERAINVNO
FISC_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PROCESSGUIDGeneric Key of Process RECAPROCESSGUIDRAW16VICAPROCESSIDRECAGUID
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ADDRTYPEAddress Type REBPADDRTYPECHAR10Assigned to domainBU_ADRKIND
ROLEBusiness Partner: Role REBPROLECHAR6Assigned to domainBU_ROLE
ITEMSELINDType of Selection of Invoice Items RERAINVITEMSELINDCHAR1RERAINVITEMSELIND
DUEDATEFROMStart Date of Due Period of the Items RERADUEDATEFROMDATS8RECADATEBEG
DUEDATETOEnd Date of Due Period of the Items RERADUEDATETODATS8REDATRECADATEEND
INCLCLEAREDITEMSAlso Consider Cleared Items? RERAINVINCLCLEAREDITEMSCHAR1RECABOOL
CLEARCREDITITEMSAlso Consider Credit Memo Items? RERAINVCLEARCREDITITEMSCHAR1RECABOOL
ALLOPENITEMSAlso Consider Items Already Invoiced? RERAINVALLOPENITEMSCHAR1RECABOOL
COLLECTINDGrouping Option: Summarize Invoices RERAINVCOLLECTINDCHAR1RERAINVCOLLECTIND
CUSTOMERCustomer Number RERACUSTOMERNOCHAR10ALPHARERAPARTNERNOKUNC_KUNNR
OBJNRObject Number of Only Contract of Invoice, Otherwise Blank RERAINVOBJNRSINGLECHAR22Assigned to domainJ_OBJNR
OBJCOUNTNumber of Contracts in This Invoice RERAINVOBJCOUNTINT410INT4
ISCREDITMEMOCredit Memo? RERAINVISCREDITMEMOCHAR1RECABOOL
ISMINORAMOUNTTrivial Amount? RERAINVISMINORAMOUNTCHAR1RECABOOL
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
TOTALGROSSAMOUNTFull Amount of Invoice RERAINVTOTALAMOUNTCURR15(2) RECACURR
TOTALNETAMOUNTNet Amount of Invoice RERAINVTOTALNETAMOUNTCURR15(2) RECACURR
TOTALTAXAMOUNTTax Amount of Invoice RERAINVTOTALTAXAMOUNTCURR15(2) RECACURR
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
CANCELEDInvoice Reversed? RERAINVCANCELEDCHAR1RECABOOL
SFDOCGUIDGUID for Document to be Output RECPSFDOCGUIDRAW16RECAGUID
PRINTEDONInvoice Last Printed On RERAINVPRINTEDONDATS8RECADATE
PRINTEDBYInvoice Last Printed By RERAINVPRINTEDBYCHAR12SYCHAR12
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



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

As AVIRAINV 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 AVIRAINV as there is no data to select.

How to access SAP table AVIRAINV

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