VIXCOTDOC SAP table for – COA, Distribution of VAT, Documents

Here we would like to draw your attention to VIXCOTDOC 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). VIXCOTDOC is a SAP standard transp table used for storing COA, Distribution of VAT, Documents related data in SAP. It comes under the package RE_XC_MM_AT.

SAP VIXCOTDOC table

Table VIXCOTDOC technical data

TableVIXCOTDOC
Data storingCOA, Distribution of VAT, Documents
ModuleRE
Sub ModuleRE-FX
SAP PackageRE_XC_MM_AT
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : COA, Distribution of VAT, Documents, Key Fields
    Its a key field.
  • INTRENOSU : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • MONAT : Fiscal period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • BELNR : Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : COA, Distribution of VAT, Documents, Non-Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • DMBTR : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • WRBTR : Amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • MWSTS : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • BRUTTO : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5