1. SAP Tutorial
  2. Real Estate Management

VIRAINVITEM SAP table for – RE Invoice Item

Here we would like to draw your attention to VIRAINVITEM 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). VIRAINVITEM is a SAP standard transp table used for storing RE Invoice Item related data in SAP. It comes under the package RE_RA_IV.

SAP VIRAINVITEM table

Table VIRAINVITEM technical data

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

SAP VIRAINVITEM 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 VIRAINVITEM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : RE Invoice Item: Key Fields
    Its a key field.
  • INVGUID : GUID: Unique Internal Key for RE Invoice
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • ITEMNO : Item Number in RE Invoice
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : RE Invoice Item: Non-Key Fields
  • OBJNR : Object Number of Contract for the Invoice Item
    Its data type is CHAR (Character String) with field length 22
  • OBJNRCALC : Object Number for Calculation
    Its data type is CHAR (Character String) with field length 22
  • ITEMSRCIND : Source of Invoice Item
    Its data type is CHAR (Character String) with field length 1
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • BLINEDATE : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALCFROM : Start of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CALCTO : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ISADVANCEPAYMENT : Condition Is Advance Payment Condition
    Its data type is CHAR (Character String) with field length 1
  • CURRENCY : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GROSSAMOUNT : Gross Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • NETAMOUNT : Net Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • PYMTMETH : Payment Method
    Its data type is CHAR (Character String) with field length 4
  • PYMTTERM : Terms of Payment Key
    Its data type is CHAR (Character String) with field length 4
  • XMACCTSHEETITEM : Name of Contract Account Sheet Item
    Its data type is CHAR (Character String) with field length 60
  • .INCLUDE : RE Invoice Item: Fields from FI Document Item
  • DOCITEMID : Coded Key of FI Document Item for RE Internal Use
    Its data type is CHAR (Character String) with field length 30
  • REFDOCID : Reference Key of Document
    Its data type is CHAR (Character String) with field length 20
  • REFITEMNO : Reference to Other Item Number of Document
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • LOGSYSTEM : Logical System
    Its data type is CHAR (Character String) with field length 10
  • OBJ_TYPE : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • OBJ_KEY : Object key
    Its data type is CHAR (Character String) with field length 20
  • PSTNGDATE : Posting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCDATE : Document Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLEARINGDATE : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CLEARINGSTATUS : Clearing status
    Its data type is CHAR (Character String) with field length 2
  • PROCESSID : Process Identification -> Accounting Reference Number
    Its data type is CHAR (Character String) with field length 16
  • PSTNGPROCEDURE : Posting Procedure
    Its data type is CHAR (Character String) with field length 4
  • XMACCTSHEETHDR : Name from Document Header
    Its data type is CHAR (Character String) with field length 60
  • TAXRATE : Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • TAXDATE : Date of Tax Calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • HOUSEBKID : Key for House Bank
    Its data type is CHAR (Character String) with field length 15
  • HOUSEBKACC : Key for House Bank Account
    Its data type is CHAR (Character String) with field length 15
  • BANKDETAILID : Bank Details ID
    Its data type is CHAR (Character String) with field length 15
  • FCCURRKEY : Foreign Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FCGROSSAMOUNT : Gross Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • FCNETAMOUNT : Net Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • FCTAXAMOUNT : Tax Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • CTRATE : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTDATEREQ : Planned Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTDATEACT : Actual Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POSTCDCURR : Post in Condition Currency
    Its data type is CHAR (Character String) with field length 1
  • TCCURRKEY : Document Currency (Transaction Currency)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TCGROSSAMOUNT : Gross Amount in Document Currency (Transaction Currency)
    Its data type is CURR (Currency Field) with field length 15
  • TCNETAMOUNT : Net Amount in Document Currency (Transaction Currency)
    Its data type is CURR (Currency Field) with field length 15
  • TCTAXAMOUNT : Tax Amount in Document Currency (Transaction Currency)
    Its data type is CURR (Currency Field) with field length 15
  • SEPAMNDID : SEPA Mandate: Unique Reference to Mandate per Vendor
    Its data type is CHAR (Character String) with field length 35
  • SEPARECCRDID : SEPA Mandate: Creditor ID
    Its data type is CHAR (Character String) with field length 35

    • VIRAINVITEM related tables

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

    VIRAINVITEM related transaction codes under SAP package RE_RA_IV

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

    Related References

    Related Tutorials

    VIRAINV SAP table for – RE Invoice Header

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

    IDGT_VATI SAP table for – VAT Invoice Item

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

    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....

    ISJPINVSUMIT SAP table for – Line items for invoice summary

    ISJPINVSUMIT table in SAP FI (Localization in FI) module. This table is used for storing data of Line items for...

    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....

    VIRADOCITEM SAP table for – RE Document Item

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

    VIITTAXDSBASE SAP table for – Tax Document Item to Be Broken Down (VIITTAXDSBASE)

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

    «
    »