1. SAP Tutorial
  2. Real Estate Management

VIRADOCITEM SAP table for – RE Document Item

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

SAP VIRADOCITEM table

Table VIRADOCITEM technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key Fields of RE Line Items
    Its a key field.
  • .INCLUDE : Key Fields of RE Document Header
    Its a key field.
  • DOCGUID : GUID: Unique Internal Key for RE Document
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • ITEMNO : Accounting Document Line Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • .INCLUDE : Contents of RE Line Items
  • REFITEMNO : Reference to Other Item Number of Document
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • ITEMTYPE : Item Category
    Its data type is CHAR (Character String) with field length 2
  • REFDATE : Reference date for settlement
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PROCESS : Process
    Its data type is CHAR (Character String) with field length 4
  • PROCESSGUID : Generic Key of Process
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : RE Document Item Status Fields
  • CLEARINGSTATUS : Clearing status
    Its data type is CHAR (Character String) with field length 2
  • CLEARNGPROCESSID : Process Identification -> Accounting Reference Number
    Its data type is CHAR (Character String) with field length 16
  • PAYEDSTATUS : Payment Status
    Its data type is CHAR (Character String) with field length 2
  • DUNNINGSTATUS : Dunning Status
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : RE Posting Rules
  • REFGUIDORIGIN : Source of GUID
    Its data type is CHAR (Character String) with field length 4
  • REFGUID : Reference GUID
    Its data type is RAW (Byte string) with field length 16
  • OBJNR : Account Assignment: Object Number
    Its data type is CHAR (Character String) with field length 22
  • PFROM : Start of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PTO : End of Calculation Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLINEDATE : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ORIGDUEDATE : Original Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • ISADVANCEPAYMENT : Condition Is Advance Payment Condition
    Its data type is CHAR (Character String) with field length 1
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • DCINDICATOR : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • TAXGROUPID : Group Indicator for Tax Line Items
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TAXDATE : Date of Tax Calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERMNOOA : Term Number
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Table Fields for Term Organizational Assignment
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • ADDOBJNR : Object Number for Additional Account Assignment
    Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Table Fields: Funds Management Account Assignments
  • .INCLUDE : Account Assignment Fields – Funds Management
  • FUND : Fund
    Its data type is CHAR (Character String) with field length 24
  • FUNDSCENTER : Funds Center
    Its data type is CHAR (Character String) with field length 24
  • COMMITMENTITEM : Commitment Item
    Its data type is CHAR (Character String) with field length 24
  • FUNCTIONALAREA : Functional Area
    Its data type is CHAR (Character String) with field length 24
  • GRANTNUMBER : Grant
    Its data type is CHAR (Character String) with field length 24
  • MEASURE : Program in Funds Management
    Its data type is CHAR (Character String) with field length 24
  • BUDGETPERIOD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 24
  • TERMNOPY : Term Number
    Its data type is CHAR (Character String) with field length 4
  • CDSPLITNO : Number of Condition Split
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : Table Fields for Posting Rule
  • PYMTMETH : Payment Method
    Its data type is CHAR (Character String) with field length 4
  • PYMTMETHCRMO : Payment Method for Credit Memos
    Its data type is CHAR (Character String) with field length 4
  • PYMTBLOCK : Payment block key
    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
  • 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
  • NOTETOPAYEE : Note to Payee
    Its data type is CHAR (Character String) with field length 25
  • DUNNAREA : Dunning Area
    Its data type is CHAR (Character String) with field length 4
  • DUNNKEY : Dunning Keys
    Its data type is CHAR (Character String) with field length 4
  • DUNNBLOCK : Dunning Block
    Its data type is CHAR (Character String) with field length 4
  • ACCDETKEY : Account Determination Value
    Its data type is CHAR (Character String) with field length 10
  • 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
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its data type is CHAR (Character String) with field length 22
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • ISCDSPLIT : Condition Split
    Its data type is CHAR (Character String) with field length 1
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • ISPARTNERBLOCKED : Lock of Partner Data in Posting Term
    Its data type is CHAR (Character String) with field length 1
  • 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
  • TERMNOWT : Term Number
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : RE Posting Record Account
  • ACCTYPE : Account Type
    Its data type is CHAR (Character String) with field length 1
  • GLACCSYMB : Account Determination: Account Symbols
    Its data type is CHAR (Character String) with field length 15
  • GLACCOUNT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : RE Currency Structure
  • .INCLUDE : RE Currency Structure
  • AMOUNT : Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • GROSSAMOUNT : Gross Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • NETAMOUNT : Net Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • TAXAMOUNT : Tax Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTLCAMOUNT : Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCGROSSAMOUNT : Gross Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCNETAMOUNT : Net Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCTAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCCURRKEY : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTFCAMOUNT : Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCGROSSAMOUNT : Gross Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCNETAMOUNT : Net Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXAMOUNT : Tax Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCCURRKEY : Foreign Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAXRATE : Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • EXTTAXCODE : Tax Code of the Accounting System
    Its data type is CHAR (Character String) with field length 5
  • EXTREF1 : External Reference 1 (Line Item)
    Its data type is CHAR (Character String) with field length 60
  • EXTREF2 : External Reference 2 (Line Item)
    Its data type is CHAR (Character String) with field length 60
  • EXTREF3 : External Reference 3 (Line Item)
    Its data type is CHAR (Character String) with field length 60
  • EXTREF4 : External Reference 4 (Line Item)
    Its data type is CHAR (Character String) with field length 60

    • VIRADOCITEM related tables

    • TIVRAITEMTXT : Document Item Text
    • TIVRAACCSYMBT : Account Symbol (Text)
    • TIVRATAXTYPE : Tax Types
    • TIVRAACCDET : Account Determination
    • TIVRAACCSYSTEMT : Accounting System (Text)
    • TIVRAPROCEDURET : Posting Transaction (Texts)
    • TIVRAACCPROPT : RE-Specific Account Properties (Text)
    • TIVRADETKEYT : Account Determination Value (Text)
    • TIVRAACCPROP : RE-Specific Account Properties
    • VIRADOCITEM : RE Document Item
    • TIVRAFLOWTPCNDS : Flow Type for Summarization
    • VIRADOC : RE Document Header
    • TIVRATAXGROUP : Tax Group
    • TIVRATAXGROUPT : Tax Group (Text)
    • TIVRAACCSYSTEM : Accounting System
    • TIVRAPROCEDURE : Posting Procedure
    • TIVRAACCSYMB : Accnt symbol
    • TIVRADETKEY : Acct determin.value
    • TIVRATAXTYPET : Tax Type (Text)
    • TIVRAITEMTXTT : Line Item Text (Text)

    VIRADOCITEM related transaction codes under SAP package RE_RA_CA

    • RERAZD : Posting Transactions
    • RERAZB : Account Symbols
    • RERAZI : Line Item Texts
    • RERAZE : Tax groups
    • RERADOCARE : Display RE Documents (Archive)
    • RERAZA : Account determination values
    • RERAZF : Tax Types
    • RERAZH : Default Values Tax Grp / Tax Type
    • RERADOCAR : Archive RE Documents
    • RERAZC : Account Determination
    • RERAPL : General Real Estate Posting Log
    • RERAZG : Accounting Systems

    Related References

    Related Tutorials

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

    VIITTAXDSITEM SAP table for – Distributed Tax Document Item (VIITTAXDSITEM)

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

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

    ETXDCI SAP table for – External tax document: line item info

    ETXDCI table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of External...

    VIXCMSSINGLDOC SAP table for – Item Data: Single Document

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

    KBLP SAP table for – Document Item: Manual Document Entry

    KBLP table in SAP FI (Funds Management in FI) module. This table is used for storing data of Document Item:...

    FKK_VBRP_SHORT SAP table for – Item Data for SD Billing Document – Extracts

    FKK_VBRP_SHORT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »