VIXCPTIMIDATA SAP table for – IMI Master Data

Here we would like to draw your attention to VIXCPTIMIDATA table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). VIXCPTIMIDATA is a SAP standard transp table used for storing IMI Master Data related data in SAP. It comes under the package GLO_REFX_PT_DDIC.

SAP VIXCPTIMIDATA table

Table VIXCPTIMIDATA technical data

TableVIXCPTIMIDATA
Data storingIMI Master Data
ModuleFI
Sub ModuleFI-LOC
SAP PackageGLO_REFX_PT_DDIC
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : IMI Data – Key Fields
    Its a key field.
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • DATEFROM : Valid from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : IMI Data – Data fields
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DATETO : Valid to date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • IMIAMOUNT : Municipal Property Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • CITY : Municipality Code
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PARISH : Parish (Freguesia) Code
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • IMIRATE : Municipal Property Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ISMANUALAMOUNT : Tax Amount Entered Manually
    Its data type is CHAR (Character String) with field length 1
  • VPT : Property Taxable Value
    Its data type is CURR (Currency Field) with field length 15
  • TAXCATID : Municipal Property Tax Category
    Its data type is CHAR (Character String) with field length 4
  • ISRESIDENTIAL : In Residential Use
    Its data type is CHAR (Character String) with field length 1
  • STARTDATE_RES : Start Date of Tax Exemption
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXEMPTSTAT : Exemption Status
    Its data type is CHAR (Character String) with field length 1
  • EXEMPTPERIODCAT : Exemption Period Category
    Its data type is CHAR (Character String) with field length 2
  • FIRSTINSTDATE : Due Date of First Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FIRSTINSTAMOUNT : Amount of First Installment
    Its data type is CURR (Currency Field) with field length 15
  • ISFIRSTINSTPAID : First Installment Paid
    Its data type is CHAR (Character String) with field length 1
  • SECINSTDATE : Due Date of Second Installment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SECINSTAMOUNT : Amount of Second Installment
    Its data type is CURR (Currency Field) with field length 15
  • ISRECORDLOCKED : IMI Record Locked for Recalculation
    Its data type is CHAR (Character String) with field length 1
  • ACCTASSIGOBJNR : Account Assignment Object Number
    Its data type is CHAR (Character String) with field length 22
  • LIABLE_TAX : Liable Property Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • CONSTRUCTIONDATE : Construction Date (of the assigned object)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .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