1. SAP Tutorial
  2. Real Estate Management

VIRAINV SAP table for – RE Invoice Header

Here we would like to draw your attention to VIRAINV table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIRAINV is a SAP standard transp table used for storing RE Invoice Header related data in SAP. It comes under the package RE_RA_IV.

SAP VIRAINV table

Table VIRAINV technical data

TableVIRAINV
Data storingRE Invoice Header
ModuleRE
Sub ModuleRE-FX-RA
SAP PackageRE_RA_IV
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIRAINV Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIRAINV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INVGUID : GUID: Unique Internal Key for RE Invoice
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : RE Invoice Header: Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • INVNO : Invoice Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • FISC_YEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : RE Invoice Header: Non-Key Fields
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • ADDRTYPE : Address Type
    Its data type is CHAR (Character String) with field length 10
  • ROLE : Business Partner: Role
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Options That Are Saved in Invoice Header
  • ITEMSELIND : Type of Selection of Invoice Items
    Its data type is CHAR (Character String) with field length 1
  • DUEDATEFROM : Start Date of Due Period of the Items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DUEDATETO : End Date of Due Period of the Items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INCLCLEAREDITEMS : Also Consider Cleared Items?
    Its data type is CHAR (Character String) with field length 1
  • CLEARCREDITITEMS : Also Consider Credit Memo Items?
    Its data type is CHAR (Character String) with field length 1
  • ALLOPENITEMS : Also Consider Items Already Invoiced?
    Its data type is CHAR (Character String) with field length 1
  • COLLECTIND : Grouping Option: Summarize Invoices
    Its data type is CHAR (Character String) with field length 1
  • CUSTOMER : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • OBJNR : Object Number of Only Contract of Invoice, Otherwise Blank
    Its data type is CHAR (Character String) with field length 22
  • OBJCOUNT : Number of Contracts in This Invoice
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ISCREDITMEMO : Credit Memo?
    Its data type is CHAR (Character String) with field length 1
  • ISMINORAMOUNT : Trivial Amount?
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TOTALGROSSAMOUNT : Full Amount of Invoice
    Its data type is CURR (Currency Field) with field length 15
  • TOTALNETAMOUNT : Net Amount of Invoice
    Its data type is CURR (Currency Field) with field length 15
  • TOTALTAXAMOUNT : Tax Amount of Invoice
    Its data type is CURR (Currency Field) with field length 15
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • CANCELED : Invoice Reversed?
    Its data type is CHAR (Character String) with field length 1
  • SFDOCGUID : GUID for Document to be Output
    Its data type is RAW (Byte string) with field length 16
  • PRINTEDON : Invoice Last Printed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PRINTEDBY : Invoice Last Printed By
    Its data type is CHAR (Character String) with field length 12

    • VIRAINV related tables

    • VIRAINV : RE Invoice Header
    • VIRAINVITEM : RE Invoice Item

    VIRAINV related transaction codes under SAP package RE_RA_IV

    • RERAIVRV : Reverse Invoices
    • RERAIV : Create Invoices
    • RERAINVNO : Number Range Maint: RERAINV

    Related References

    Related Tutorials

    VIRAINVITEM SAP table for – RE Invoice Item

    VIRAINVITEM table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    ISJPINVSUMHD SAP table for – Invoice Summary Header

    ISJPINVSUMHD table in SAP FI (Localization in FI) module. This table is used for storing data of Invoice Summary Header....

    IDGT_VATH SAP table for – VAT Invoice Header

    IDGT_VATH table in SAP FI (Localization in FI) module. This table is used for storing data of VAT Invoice Header....

    J_1IEXCHDR SAP table for – Excise invoice header detail

    J_1IEXCHDR table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice header...

    RBKPB SAP table for – Invoice Document Header (Batch Invoice Verification)

    RBKPB table in SAP MM (Invoice Verification in MM) module. This tables is used for storing data of Invoice Document...

    VIXCRAESRREFH SAP table for – Assignment of ISR Ref./Cash Flow Plan (Header Data)

    VIXCRAESRREFH table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    IFW_HEADER SAP table for – Invoice forecasting header

    IFW_HEADER table in SAP LO (Agency Business (Global Trade) in LO) module. This tables is used for storing data of...

    «
    »