1. Home
  2. Resources
  3. SAP Tables
  4. VIOB03 - Real estate building master

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
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
NULL No
X Yes
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
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 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
0 No selection
1 Floating new value 1914
2 New value
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
NULL No
X Yes
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
NULL No
X Yes
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
NULL No
X Yes
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
NULL 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 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 MANDT T001 Company Codes MANDT
VIOB03 BUKRS VIOB03 BUKRS T001 Company Codes BUKRS
VIOB03 GEMEINDE VIOB03 MANDT TIVG1 Municipality Key MANDT
VIOB03 GEMEINDE VIOB03 GEMEINDE TIVG1 Municipality Key GEMEINDE
VIOB03 GSBER VIOB03 GSBER TGSB Business Areas GSBER
VIOB03 GSBER VIOB03 MANDT TGSB Business Areas MANDT
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 MANDT TKA01 Controlling Areas MANDT
VIOB03 KOKRS VIOB03 KOKRS TKA01 Controlling Areas KOKRS
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 RFAZUST TIV83 Condition of a real estate object RZUSTAND
VIOB03 RFAZUST VIOB03 MANDT TIV83 Condition of a real estate object MANDT
VIOB03 RGEBART VIOB03 MANDT TIV5A Classification of real estate objects MANDT
VIOB03 RGEBART VIOB03 RGEBART TIV5A Classification of real estate objects SOBJART
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 SUNUTZA TIV36 Main Usage Types SUNART
VIOB03 SUNUTZA VIOB03 MANDT TIV36 Main Usage Types MANDT
VIOB03 SWENR VIOB03 BUKRS VIOB01 Business entities BUKRS
VIOB03 SWENR VIOB03 SWENR VIOB01 Business entities SWENR
VIOB03 SWENR VIOB03 MANDT VIOB01 Business entities MANDT