SAP VILID ICI Historical Data of D-Building Table
Overview
VILID is a standard SAP S/4HANA table that stores ICI Historical Data of D-Building data. There are total 11 fields in the VILID table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VILID 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 VILID to other SAP tables and standard CDS views available based on VILID table in S/4HANA 2020.
Techincal Settings of VILID
Below are technical details of the table VILID
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VILID Fields
The following table gives you an overview of the fields available in VILID
| 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 | |
| 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 |
| COEFF | Annual coefficient for D-Building | VVLICCOEFF | DEC | 5 | |
| COSIM | Annual Asset incrementative cost | VVLICCOSIM | CURR | 13 | |
| VALIM | Asset value of the year | VVLICVALIM | CURR | 13 |
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 VILID
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VILID | WAERS | : | TCURC |