SAP VIOB18 Comparative apartments for rent adjustment, external accomm. Table
Overview
VIOB18 is a standard SAP S/4HANA table that stores Comparative apartments for rent adjustment, external accomm. data. There are total 29 fields in the VIOB18 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIOB18 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).
In addition, following links provide an overview of foreign key relationships, if any, that link VIOB18 to other SAP tables and standard CDS views available based on VIOB18 table in S/4HANA 2020.
Techincal Settings of VIOB18
Below are technical details of the table VIOB18
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIOB18 Fields
The following table gives you an overview of the fields available in VIOB18
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RVGLWHN | Comparative apartment key | RVGLWHN | NUMC | 8 | |
| AZIMM | Number of rooms | AZIMM | DEC | 3 | |
| AHALBZI | Number of half rooms | AHALBZI | DEC | 2 | |
| STOCK | Dummy (previously storey replaced by VVSSTOCKW) | RGESCH | CHAR | 2 | |
| XLAGE | Location class | SLAGK | TIV22 | NUMC | 2 |
| SMOEBL | Furniture indicator | SMOEB | CHAR | 1 | |
| SHEIZART | Heating type | SHEIZ | CHAR | 1 | |
| SGEBT | Part of Building | SGEBT | TIV12 | CHAR | 2 |
| XAUSTKL | Fixtures and fittings category | SAUSKL | TIV23 | NUMC | 2 |
| BGRUNDM | Basic net rent of comparative apartment excl. heating | BGRUNDM | CURR | 13 | |
| WGRUNDM | Currency in which the basic rent is displayed | WGRUNDM | TCURC | CUKY | 5 |
| FWOHNFL | Rental unit living area | FWOHNFL | QUAN | 14 | |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | |
| SMIETSP | Representative list of rents assignment | SMIETSP | TIV20 | CHAR | 6 |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 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 | |
| SSTOCKW | Floor | VVSSTOCKW | TIV37 | NUMC | 3 |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 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 VIOB18
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIOB18 | BUKRS | 1: CN | T001 |
| VIOB18 | FEINS | 1: CN | T006 |
| VIOB18 | SGEBT | 1: CN | TIV12 |
| VIOB18 | SMIETSP | 1: CN | TIV20 |
| VIOB18 | SSTOCKW | 1: CN | TIV37 |
| VIOB18 | WGRUNDM | 1: CN | TCURC |
| VIOB18 | XAUSTKL | 1: CN | TIV23 |
| VIOB18 | XLAGE | 1: CN | TIV22 |