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