VIOB03
Real estate building masterExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table VIOB03.
SAP table VIOB03 has 4 primary key fields: MANDT,BUKRS,SWENR,SGENR.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
VIOB03 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||||||||||||||||||
| Key BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||||||||||||
| Key SWENR | Business Entity Number | CHAR | 8 | 0 | VIOB01 | SWENR | |||||||||||||||||||||
| Key SGENR | Building Number | CHAR | 8 | 0 | SGENR | ||||||||||||||||||||||
| ADRNR | Object number (virtual object) | NUMC | 10 | 0 | SANO1 | SOBJNR | |||||||||||||||||||||
| RGEBART | Type of building | NUMC | 2 | 0 | TIV5A | RGEBART | |||||||||||||||||||||
| JERBBAU | Heritable building right indicator | CHAR | 1 | 0 | TDO9 | JERBBAU | |||||||||||||||||||||
| RGEBZUST | General condition of building | NUMC | 2 | 0 | TIV83 | RGEBZUST | |||||||||||||||||||||
| YBAUJAHR | ConstYr | DATS | 8 | 0 | VVYBAUJAHR | ||||||||||||||||||||||
| YMODERN | Year of modernization | DATS | 8 | 0 | VVYMODERN | ||||||||||||||||||||||
| YAUFBAU | Year of reconstruction | DATS | 8 | 0 | VVYAUFBAU | ||||||||||||||||||||||
| DBAUBEGI | Construction start date | DATS | 8 | 0 | DBAUBEGI | ||||||||||||||||||||||
| BBAUW13 | Building value | CURR | 11 | 2 | BBAUW13 | ||||||||||||||||||||||
| BBAUWAKT | Current building value | CURR | 11 | 2 | BBAUWAKT | ||||||||||||||||||||||
| BBETRIEB | Production equipment value | CURR | 11 | 2 | BBETRIEB | ||||||||||||||||||||||
| BAUSSEN | Grounds value | CURR | 11 | 2 | BAUSSEN | ||||||||||||||||||||||
| BSCHADEN | Structural damage value | CURR | 11 | 2 | BSCHADEN | ||||||||||||||||||||||
| BREPSTAU | Value of repair backlog | CURR | 11 | 2 | BREPSTAU | ||||||||||||||||||||||
| BDMCBMRA | Amount per volume unit | CURR | 11 | 2 | BDMCBMRA | ||||||||||||||||||||||
| DBAUGENE | Building permit | DATS | 8 | 0 | DBAUGENE | ||||||||||||||||||||||
| XBAUGENE | Note on building permit | CHAR | 30 | 0 | XBAUGENE | ||||||||||||||||||||||
| DBEZUGSF | Ready for occupancy | DATS | 8 | 0 | DBEZUGSF | ||||||||||||||||||||||
| DFERTIG | Completion | DATS | 8 | 0 | DFERTIG | ||||||||||||||||||||||
| DSCHLUSS | Final Inspection | DATS | 8 | 0 | DSCHLUSS | ||||||||||||||||||||||
| FDACHFL | Attic space | DEC | 8 | 2 | FDACHFL | ||||||||||||||||||||||
| RDAZUST | Condition of roof | NUMC | 2 | 0 | TIV83 | RDAZUST | |||||||||||||||||||||
| RFAZUST | Condition of facade | NUMC | 2 | 0 | TIV83 | RFAZUST | |||||||||||||||||||||
| BUBRA | Cubic Volume | DEC | 11 | 3 | BUBRA | ||||||||||||||||||||||
| JDENKMAL | Protection of Historical Sites | CHAR | 1 | 0 | JDENKMAL | ||||||||||||||||||||||
| AGESCH | Dummy, since replaced: Number of floors | DEC | 3 | 1 | AGESCH | ||||||||||||||||||||||
| AUGESCH | Number of basements | DEC | 2 | 0 | AUGESCH | ||||||||||||||||||||||
| RARTOPT | Option rate calculation type | NUMC | 1 | 0 | RARTOPT | ||||||||||||||||||||||
| |||||||||||||||||||||||||||
| JLOESCH | Real Estate Deletion Indicator/Flag | CHAR | 1 | 0 | JLOESCH | ||||||||||||||||||||||
| RERF | Entered By | CHAR | 12 | 0 | RERF | ||||||||||||||||||||||
| DERF | First Entered On | DATS | 8 | 0 | DERF | ||||||||||||||||||||||
| TERF | Time of Creation | TIMS | 6 | 0 | TERF | ||||||||||||||||||||||
| REHER | Source of Initial Entry | CHAR | 10 | 0 | REHER | ||||||||||||||||||||||
| RBEAR | Employee ID | CHAR | 12 | 0 | RBEAR | ||||||||||||||||||||||
| DBEAR | Last Edited On | DATS | 8 | 0 | DBEAR | ||||||||||||||||||||||
| TBEAR | Last Edited At | TIMS | 6 | 0 | TBEAR | ||||||||||||||||||||||
| RBHER | Editing Source | CHAR | 10 | 0 | RBHER | ||||||||||||||||||||||
| DAKTBEST | Date active in portfolio | DATS | 8 | 0 | DAKTBEST | ||||||||||||||||||||||
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||||||||||||||||||||||
| DBAUVOR | Date of planning inquiry | DATS | 8 | 0 | DBAUVOR | ||||||||||||||||||||||
| DVORBES | Date of prior notice | DATS | 8 | 0 | DVORBES | ||||||||||||||||||||||
| DANTBAU | Application for building permit | DATS | 8 | 0 | DANTBAU | ||||||||||||||||||||||
| SGRUNDB | Land register number | NUMC | 8 | 0 | SGRUNDB | ||||||||||||||||||||||
| XGETXT | Building text | CHAR | 60 | 0 | XGETXT | ||||||||||||||||||||||
| BEINHEITW | Assessed value of building | CURR | 11 | 2 | BEINHEITW | ||||||||||||||||||||||
| NEINHEITW | Assessed value base year | NUMC | 4 | 0 | NEINHEITW | ||||||||||||||||||||||
| BVERSWRT | Insurable value amount | CURR | 11 | 2 | BVERSWRT | ||||||||||||||||||||||
| RVERSWRT | Type of insurance value | NUMC | 1 | 0 | RVERSWRT | ||||||||||||||||||||||
| |||||||||||||||||||||||||||
| SLAGK | Location class | NUMC | 2 | 0 | TIV22 | SLAGK | |||||||||||||||||||||
| KOSTL | Cost Center | CHAR | 10 | 0 | KOSTL | ||||||||||||||||||||||
| J_OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |||||||||||||||||||||
| RFAKT | Conversion factor for fractional share of property | NUMC | 6 | 0 | VVRFAKT | ||||||||||||||||||||||
| JNURJAHR | Indicator: Only regard construction date in terms of years | CHAR | 1 | 0 | VVJNURJ | ||||||||||||||||||||||
| PRCTR | Profit Center | CHAR | 10 | 0 | CEPC | PRCTR | |||||||||||||||||||||
| DWIRTUB | Transfer usage / charges | DATS | 8 | 0 | VVDWIRTUB | ||||||||||||||||||||||
| DVERKAUF | Sale date | DATS | 8 | 0 | VVDVERKAUF | ||||||||||||||||||||||
| SUNUTZA | Main usage type | CHAR | 8 | 0 | TIV36 | VVSUNART | |||||||||||||||||||||
| JUNUTZA | Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 | CHAR | 1 | 0 | VVJUNUTZA | ||||||||||||||||||||||
| PROFL | Settlement Profile | CHAR | 6 | 0 | TKB1A | APROF | |||||||||||||||||||||
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||||||||||||||
| DVRKPLAN | Planned sale | DATS | 8 | 0 | VVDVRKPLAN | ||||||||||||||||||||||
| DNUTZEND | End of usage | DATS | 8 | 0 | VVDNUTZEND | ||||||||||||||||||||||
| DFRDVON | Public funding from | DATS | 8 | 0 | VVDFRDVON | ||||||||||||||||||||||
| DFRDBIS | Public funding to | DATS | 8 | 0 | VVDFRDBIS | ||||||||||||||||||||||
| NSTCKLFT | Number of highest floor reached by elevator | NUMC | 3 | 0 | VVNSTCKLFT | ||||||||||||||||||||||
| BANZGE | Number of floors | DEC | 4 | 1 | VVBANZGE | ||||||||||||||||||||||
| RPGENR | Building no. of hierarchical superior building part | CHAR | 8 | 0 | VVRPGENR | ||||||||||||||||||||||
| JANLHIE | Indicator: Asset allocation valid for subordin. building | CHAR | 1 | 0 | VVJANLHIE | ||||||||||||||||||||||
| SSTCKBIS | Uppermost Floor of a Building | NUMC | 3 | 0 | VVSTCKBIS | ||||||||||||||||||||||
| SLIFTBIS | Elevator to Floor in Building | NUMC | 3 | 0 | VVLIFTBIS | ||||||||||||||||||||||
| INTRENO | Internal Real Estate Master Data Code | CHAR | 13 | 0 | VVINTRENO | ||||||||||||||||||||||
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |||||||||||||||||||||
| TXJCD | Tax Jurisdiction | CHAR | 15 | 0 | TXJCD | ||||||||||||||||||||||
| BERGRP | Authorization group | CHAR | 40 | 0 | VVBERGRP | ||||||||||||||||||||||
| GEMEINDE | Municipality key | CHAR | 8 | 0 | TIVG1 | VVGEMEINDE | |||||||||||||||||||||
| VALIDFROM | Date: Object Valid From | DATS | 8 | 0 | REBDOBJVALIDFROM | ||||||||||||||||||||||
| VALIDTO | Date: Object Valid To | DATS | 8 | 0 | REBDOBJVALIDTO | ||||||||||||||||||||||
| CREATIONTYPE | How the Object Was Created | CHAR | 1 | 0 | RECACREATIONTYPE | ||||||||||||||||||||||
| |||||||||||||||||||||||||||
| RESPONSIBLE | Person Responsible | CHAR | 12 | 0 | RECARESPONSIBLE | ||||||||||||||||||||||
| USEREXCLUSIVE | User with Exclusive Change Authorization | CHAR | 12 | 0 | RECAUSEREXCLUSIVE | ||||||||||||||||||||||
VIOB03 relationships.
| Table | Field | Check table | Description | Check field |
|---|---|---|---|---|
| VIOB03 | ADRNR | SANO1 | Address-object relationship | MANDT |
| VIOB03 | ADRNR | SANO1 | Address-object relationship | ADRNR |
| VIOB03 | ADRNR | SANO1 | Address-object relationship | OBTYP |
| VIOB03 | BUKRS | T001 | Company Codes | BUKRS |
| VIOB03 | GEMEINDE | TIVG1 | Municipality Key | MANDT |
| VIOB03 | GSBER | TGSB | Business Areas | MANDT |
| VIOB03 | GSBER | TGSB | Business Areas | GSBER |
| VIOB03 | JERBBAU | TDO9 | Heritable Building Right Indicator for Collateral Objects | MANDT |
| VIOB03 | JERBBAU | TDO9 | Heritable Building Right Indicator for Collateral Objects | SOBJERBBAU |
| VIOB03 | J_OBJNR | ONR00 | General Object Number | MANDT |
| VIOB03 | KOKRS | TKA01 | Controlling Areas | MANDT |
| VIOB03 | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| VIOB03 | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| VIOB03 | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| VIOB03 | PROFL | TKB1A | Settlement Profile | MANDT |
| VIOB03 | PROFL | TKB1A | Settlement Profile | APROF |
| VIOB03 | RDAZUST | TIV83 | Condition of a real estate object | MANDT |
| VIOB03 | RFAZUST | TIV83 | Condition of a real estate object | MANDT |
| VIOB03 | RGEBART | TIV5A | Classification of real estate objects | MANDT |
| VIOB03 | RGEBART | TIV5A | Classification of real estate objects | SOBJART |
| VIOB03 | RGEBZUST | TIV83 | Condition of a real estate object | MANDT |
| VIOB03 | SLAGK | TIV22 | Representative list of rents location classes | MANDT |
| VIOB03 | SLAGK | TIV22 | Representative list of rents location classes | SLAGK |
| VIOB03 | SUNUTZA | TIV36 | Main Usage Types | MANDT |
| VIOB03 | SWENR | VIOB01 | Business entities | MANDT |
| VIOB03 | SWENR | VIOB01 | Business entities | BUKRS |