SAP VIXCPTIMIDATA IMI Master Data Table
Overview
VIXCPTIMIDATA is a standard SAP S/4HANA table that stores IMI Master Data data. There are total 36 fields in the VIXCPTIMIDATA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIXCPTIMIDATA belongs to Localization (FI-LOC) module and is located in the package Localization Flexible Real Estate Portugal (GLO_REFX_PT_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link VIXCPTIMIDATA to other SAP tables and standard CDS views available based on VIXCPTIMIDATA table in S/4HANA 2020.
Techincal Settings of VIXCPTIMIDATA
Below are technical details of the table VIXCPTIMIDATA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIXCPTIMIDATA Fields
The following table gives you an overview of the fields available in VIXCPTIMIDATA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | VILMPL | CHAR | 13 |
| DATEFROM | Valid from date | REXCPTIMIDATEFROM | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
| DATETO | Valid to date | REXCPTIMIDATETO | DATS | 8 | |
| IMIAMOUNT | Municipal Property Tax Amount | REXCPTIMIAMOUNT | CURR | 15 | |
| CITY | Municipality Code | REXCPTMUNICIPALITY | NUMC | 4 | |
| PARISH | Parish (Freguesia) Code | REXCPTPARISH | NUMC | 6 | |
| IMIRATE | Municipal Property Tax Rate | REXCPTIMIRATE | DEC | 6 | |
| ISMANUALAMOUNT | Tax Amount Entered Manually | REXCPTISMANUALAMOUNT | CHAR | 1 | |
| VPT | Property Taxable Value | REXCPTVPT | CURR | 15 | |
| TAXCATID | Municipal Property Tax Category | REXCPTTAXCAT | CHAR | 4 | |
| ISRESIDENTIAL | In Residential Use | REXCPTISRESIDENTIAL | CHAR | 1 | |
| STARTDATE_RES | Start Date of Tax Exemption | REXCPTSTARTDATE_RES | DATS | 8 | |
| EXEMPTSTAT | Exemption Status | REXCPTEXEMPTSTAT | CHAR | 1 | |
| EXEMPTPERIODCAT | Exemption Period Category | REXCPTEXPERCAT | CHAR | 2 | |
| FIRSTINSTDATE | Due Date of First Installment | REXCPTFIRSTINSTDATE | DATS | 8 | |
| FIRSTINSTAMOUNT | Amount of First Installment | REXCPTFIRSTINSTAMOUNT | CURR | 15 | |
| ISFIRSTINSTPAID | First Installment Paid | REXCPTISFIRSTINSTPAID | CHAR | 1 | |
| SECINSTDATE | Due Date of Second Installment | REXCPTSECINSTDATE | DATS | 8 | |
| SECINSTAMOUNT | Amount of Second Installment | REXCPTSECINSTAMOUNT | CURR | 15 | |
| ISSECINSTPAID | Second Installment Paid | REXCPTISSECINSTPAID | CHAR | 1 | |
| THIRDINSTDATE | Due Date of Third Installment | REXCPTTHIRDINSTDATE | DATS | 8 | |
| THIRDINSTAMOUNT | Amount of Third Installment | REXCPTTHIRDINSTAMOUNT | CURR | 15 | |
| ISRECORDLOCKED | IMI Record Locked for Recalculation | REXCPTISIMIRECORDLOCKED | CHAR | 1 | |
| ACCTASSIGOBJNR | Account Assignment Object Number | REXCPTACCASSOBJNR | * | CHAR | 22 |
| LIABLE_TAX | Liable Property Tax Amount | REXCPTLIABLETAX | CURR | 15 | |
| CONSTRUCTIONDATE | Construction Date (of the assigned object) | REXCPTCONSTDATE | DATS | 8 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIXCPTIMIDATA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIXCPTIMIDATA | CURRENCY | : | TCURC |
| VIXCPTIMIDATA | INTRENO | : | VILMPL |