VIXCOTDS SAP table for – COA, Distribution of VAT

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

SAP VIXCOTDS table

Table VIXCOTDS technical data

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

SAP VIXCOTDS 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 VIXCOTDS 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, 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
  • INTRENOCN : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : COA, Distribution of VAT, Non-Key Fields
  • CALCBASE : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • OTAMOUNT : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • MEASVALUE : Measurement Amount: Available
    Its data type is QUAN (Quantity field) with field length 17
  • MEASUNIT : Measurement Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • 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
  • OPAMOUNT : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • METHOD : Calculation Method for COA Subsequent Allocation
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4