SAP table VIOB03 (Real estate building master)

SAP table VIOB03 has 4 primary key fields being MANDT,BUKRS,SWENR,SGENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
SWENR Business Entity Number CHAR 8 0 VIOB01 SWENR
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
0 No calculation/date of service
1 Square meter ratio (automatic)
2 Cubic meter ratio (automatic)
3 Apport.unit relat. (automatic)
4 Predistribution (automatic)
5 Plan option rate (manual)
6 Square meter ratio (manual)
7 Cubic meter ratio (manual)
8 Other procedure (manual)
9 No input tax option (automatic)
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
0 No selection
1 Floating new value 1914
2 New value
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
Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RESPONSIBLE Person Responsible CHAR 12 0 RECARESPONSIBLE
USEREXCLUSIVE User with Exclusive Change Authorization CHAR 12 0 RECAUSEREXCLUSIVE

VIOB03 foreign key relationships

Table Field Check Table Check Field
0 VIOB03 ADRNR SANO1 Address-object relationship MANDT
0 VIOB03 ADRNR SANO1 Address-object relationship ADRNR
0 VIOB03 ADRNR SANO1 Address-object relationship OBTYP
1 VIOB03 BUKRS T001 Company Codes BUKRS
0 VIOB03 GEMEINDE TIVG1 Municipality Key MANDT
1 VIOB03 GSBER TGSB Business Areas MANDT
1 VIOB03 GSBER TGSB Business Areas GSBER
0 VIOB03 JERBBAU TDO9 Heritable Building Right Indicator for Collateral Objects MANDT
0 VIOB03 JERBBAU TDO9 Heritable Building Right Indicator for Collateral Objects SOBJERBBAU
1 VIOB03 J_OBJNR ONR00 General Object Number MANDT
0 VIOB03 KOKRS TKA01 Controlling Areas MANDT
1 VIOB03 PRCTR CEPC Profit Center Master Data Table PRCTR
1 VIOB03 PRCTR CEPC Profit Center Master Data Table DATBI
1 VIOB03 PRCTR CEPC Profit Center Master Data Table KOKRS
0 VIOB03 PROFL TKB1A Settlement Profile MANDT
0 VIOB03 PROFL TKB1A Settlement Profile APROF
1 VIOB03 RDAZUST TIV83 Condition of a real estate object MANDT
0 VIOB03 RFAZUST TIV83 Condition of a real estate object MANDT
1 VIOB03 RGEBART TIV5A Classification of real estate objects MANDT
1 VIOB03 RGEBART TIV5A Classification of real estate objects SOBJART
0 VIOB03 RGEBZUST TIV83 Condition of a real estate object MANDT
1 VIOB03 SLAGK TIV22 Representative list of rents location classes MANDT
1 VIOB03 SLAGK TIV22 Representative list of rents location classes SLAGK
0 VIOB03 SUNUTZA TIV36 Main Usage Types MANDT
1 VIOB03 SWENR VIOB01 Business entities MANDT
1 VIOB03 SWENR VIOB01 Business entities BUKRS