SAP VIOB20 Fixtures and fittings objects for building Table
Overview
VIOB20 is a standard SAP S/4HANA table that stores Fixtures and fittings objects for building data. There are total 7 fields in the VIOB20 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIOB20 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 VIOB20 to other SAP tables and standard CDS views available based on VIOB20 table in S/4HANA 2020.
Techincal Settings of VIOB20
Below are technical details of the table VIOB20
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIOB20 Fields
The following table gives you an overview of the fields available in VIOB20
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SGENR | Building Number | SGENR | VIOB03 | CHAR | 8 |
| VVSAOGR | Group of object characteristics | VVSAOGR | TIV74 | NUMC | 3 |
| VVSAOB | Number of Object Characteristic | VVSAOB | TIV72 | NUMC | 3 |
| VVSAUSP | Number of object characteristic value | VVSAUSP | TIV73 | NUMC | 3 |
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 VIOB20
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIOB20 | BUKRS | 1: CN | T001 |
| VIOB20 | MANDT | 1: CN | T000 |
| VIOB20 | SGENR | 1: CN | VIOB03 |
| VIOB20 | SWENR | 1: CN | VIOB01 |
| VIOB20 | VVSAOB | 1: CN | TIV72 |
| VIOB20 | VVSAOGR | 1: CN | TIV74 |
| VIOB20 | VVSAUSP | 1: CN | TIV73 |