SAP VILIC ICI Historical Data Table
Overview
VILIC is a standard SAP S/4HANA table that stores ICI Historical Data data. There are total 48 fields in the VILIC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILIC belongs to Real Estate Management (RE) module and is located in the package (FVVIIT).
In addition, following links provide an overview of foreign key relationships, if any, that link VILIC to other SAP tables and standard CDS views available based on VILIC table in S/4HANA 2020.
Techincal Settings of VILIC
Below are technical details of the table VILIC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILIC Fields
The following table gives you an overview of the fields available in VILIC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| ANFIS | Fiscal Year | GJAHR | NUMC | 4 | |
| DTVAL | Validity date | VVLICDTVAL | DATS | 8 | |
| BUKRS | Company Code | BUKRS | * | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | * | CHAR | 8 |
| SMENR | Number of Rental Unit | SMENR | * | CHAR | 8 |
| SGRNR | Land Number for BE | SGRNR | * | CHAR | 8 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| DTFIN | End period date | VVLICDTFIN | DATS | 8 | |
| ICVAL | ICI value | VVLICICVAL | CURR | 13 | |
| ORT01 | Ort | VVLICORT01 | CHAR | 35 | |
| ZOCEN | Census Area | VVLICZOCEN | CHAR | 2 | |
| ALCOM | County rate | VVLICALCOM | DEC | 5 | |
| ESATT | Name of the ICI collector | VVLICESATT | CHAR | 60 | |
| CCNRO | C/C number | VVLICCCNRO | CHAR | 10 | |
| IDCAT | Category ID | VVLICIDCAT | TIVLICTG | CHAR | 4 |
| COFCA | Category coefficient | VVLICCOFCA | DEC | 5 | |
| IDCLA | Class ID | VVLICIDCLA | TIVLICLA | CHAR | 2 |
| COFRE | Regional Coefficient | VVLICCOFRE | DEC | 5 | |
| COFRI | Revaluation Coefficient | VVLICCOFRI | DEC | 5 | |
| TPCAL | Calculation type | VVLICTPCAL | CHAR | 2 | |
| CORUS | Use grouping code | VVLICCORUS | TIVLICRU | CHAR | 2 |
| RENBA | Basic Cadastral revenue | VVLICRENBA | CURR | 13 | |
| RENCA | Cadastral revenue | VVLICRENCA | CURR | 13 | |
| VAVEN | Selling value for building areas | VVLICVAVEN | CURR | 13 | |
| REDOM | Domain revenue | VVLICREDOM | CURR | 13 | |
| VAIMM | D-Building value | VVLICVAIMM | CURR | 13 | |
| BASVL | Basic value | VVLICBASVL | CURR | 13 | |
| BASIM | Taxable amount | VVLICBASIM | CURR | 13 | |
| MEPOS | Months of ownership | VVLICMEPOS | NUMC | 2 | |
| PEPOS | Percentage of ownership | VVLICPEPOS | DEC | 5 | |
| MEESC | Months of exclusion | VVLICMEESC | NUMC | 2 | |
| VEDET | Possible detraction value | VVLICVEDET | CURR | 13 | |
| PEDET | Detraction percentage | VVLICPEDET | DEC | 5 | |
| AUPER | Raising percentage | VVLICAUPER | DEC | 5 | |
| DTPRI | First payment deadline | VVLICDTPRI | DATS | 8 | |
| VLPRI | First instalment value | VVLICVLPRI | CURR | 13 | |
| DEPRI | First instalment detractions | VVLICDEPRI | CURR | 13 | |
| FLPRI | Flag 1st instalment payment | VVLICFLPRI | CHAR | 1 | |
| ACCON | Down payment | VVLICACCON | CURR | 13 | |
| DTSEC | Second payment deadline | VVLICDTSEC | DATS | 8 | |
| VLSEC | Second instalments value | VVLICVLSEC | CURR | 13 | |
| DESEC | Second instalment detractions | VVLICDESEC | CURR | 13 | |
| SALDO | Balance | VVLICSALDO | CURR | 13 | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | |
| USNAM | User Name | USNAM | * | CHAR | 12 |
| BLDAT | Document Date in Document | BLDAT | DATS | 8 |
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 VILIC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILIC | CORUS | : | TIVLICRU |
| VILIC | IDCAT | : | TIVLICTG |
| VILIC | IDCLA | : | TIVLICLA |
| VILIC | WAERS | : | TCURC |