SAP VIOB03 Real estate building master Table
Overview
VIOB03 is a standard SAP S/4HANA table that stores Real estate building master data. There are total 84 fields in the VIOB03 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIOB03 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 VIOB03 to other SAP tables and standard CDS views available based on VIOB03 table in S/4HANA 2020.
Techincal Settings of VIOB03
Below are technical details of the table VIOB03
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIOB03 Fields
The following table gives you an overview of the fields available in VIOB03
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | SWENR | VIOB01 | CHAR | 8 |
| SGENR | Building Number | SGENR | CHAR | 8 | |
| ADRNR | Object number (virtual object) | SOBJNR | SANO1 | NUMC | 10 |
| RGEBART | Type of building | RGEBART | TIV5A | NUMC | 2 |
| JERBBAU | Heritable building right indicator | JERBBAU | TDO9 | CHAR | 1 |
| RGEBZUST | General condition of building | RGEBZUST | TIV83 | NUMC | 2 |
| YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | |
| YMODERN | Year of modernization | VVYMODERN | DATS | 8 | |
| YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | |
| DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | |
| BBAUW13 | Building value | BBAUW13 | CURR | 11 | |
| BBAUWAKT | Current building value | BBAUWAKT | CURR | 11 | |
| BBETRIEB | Production equipment value | BBETRIEB | CURR | 11 | |
| BAUSSEN | Grounds value | BAUSSEN | CURR | 11 | |
| BSCHADEN | Structural damage value | BSCHADEN | CURR | 11 | |
| BREPSTAU | Value of repair backlog | BREPSTAU | CURR | 11 | |
| BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 11 | |
| DBAUGENE | Building permit | DBAUGENE | DATS | 8 | |
| XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | |
| DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | |
| DFERTIG | Completion | DFERTIG | DATS | 8 | |
| DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | |
| FDACHFL | Attic space | FDACHFL | DEC | 8 | |
| RDAZUST | Condition of roof | RDAZUST | TIV83 | NUMC | 2 |
| RFAZUST | Condition of facade | RFAZUST | TIV83 | NUMC | 2 |
| BUBRA | Cubic Volume | BUBRA | DEC | 11 | |
| JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | |
| AGESCH | Dummy since replaced: Number of floors | AGESCH | DEC | 3 | |
| AUGESCH | Number of basements | AUGESCH | DEC | 2 | |
| RARTOPT | Option rate calculation type | RARTOPT | NUMC | 1 | |
| JLOESCH | Real Estate Deletion Indicator/Flag | JLOESCH | CHAR | 1 | |
| 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 | |
| DAKTBEST | Date active in portfolio | DAKTBEST | DATS | 8 | |
| IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | |
| DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | |
| DVORBES | Date of prior notice | DVORBES | DATS | 8 | |
| DANTBAU | Application for building permit | DANTBAU | DATS | 8 | |
| SGRUNDB | Land register number | SGRUNDB | NUMC | 8 | |
| XGETXT | Building text | XGETXT | CHAR | 60 | |
| BEINHEITW | Assessed value of building | BEINHEITW | CURR | 11 | |
| NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | |
| BVERSWRT | Insurable value amount | BVERSWRT | CURR | 11 | |
| RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | |
| SLAGK | Location class | SLAGK | TIV22 | NUMC | 2 |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| J_OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | |
| JNURJAHR | Indicator: Only regard construction date in terms of years | VVJNURJ | CHAR | 1 | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | |
| DVERKAUF | Sale date | VVDVERKAUF | DATS | 8 | |
| SUNUTZA | Main usage type | VVSUNART | TIV36 | CHAR | 8 |
| JUNUTZA | Indicator: Predominant usage type ' '-ANLKL 'X'-TIV36 | VVJUNUTZA | CHAR | 1 | |
| PROFL | Settlement Profile | APROF | TKB1A | CHAR | 6 |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| DVRKPLAN | Planned sale | VVDVRKPLAN | DATS | 8 | |
| DNUTZEND | End of usage | VVDNUTZEND | DATS | 8 | |
| DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | |
| DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | |
| NSTCKLFT | Number of highest floor reached by elevator | VVNSTCKLFT | NUMC | 3 | |
| BANZGE | Number of floors | VVBANZGE | DEC | 4 | |
| RPGENR | Building no. of hierarchical superior building part | VVRPGENR | CHAR | 8 | |
| JANLHIE | Indicator: Asset allocation valid for subordin. building | VVJANLHIE | CHAR | 1 | |
| SSTCKBIS | Uppermost Floor of a Building | VVSTCKBIS | NUMC | 3 | |
| SLIFTBIS | Elevator to Floor in Building | VVLIFTBIS | NUMC | 3 | |
| INTRENO | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 13 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | |
| BERGRP | Authorization group | VVBERGRP | CHAR | 40 | |
| GEMEINDE | Municipality key | VVGEMEINDE | TIVG1 | CHAR | 8 |
| VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | |
| VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 |
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 VIOB03
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIOB03 | ADRNR | 1: C | SANO1 |
| VIOB03 | BUKRS | 1: CN | T001 |
| VIOB03 | GEMEINDE | : | TIVG1 |
| VIOB03 | GSBER | 1: CN | TGSB |
| VIOB03 | JERBBAU | : | TDO9 |
| VIOB03 | J_OBJNR | 1: CN | ONR00 |
| VIOB03 | KOKRS | C: CN | TKA01 |
| VIOB03 | PRCTR | 1: CN | CEPC |
| VIOB03 | PROFL | C: CN | TKB1A |
| VIOB03 | RDAZUST | : | TIV83 |
| VIOB03 | RFAZUST | : | TIV83 |
| VIOB03 | RGEBART | 1: CN | TIV5A |
| VIOB03 | RGEBZUST | : | TIV83 |
| VIOB03 | SLAGK | 1: CN | TIV22 |
| VIOB03 | SUNUTZA | 1: CN | TIV36 |
| VIOB03 | SWENR | 1: CN | VIOB01 |