VIOB03

Real estate building master | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
BUKRS FK Company Code
SWENR FK Business Entity Number
SGENR Building Number
Column Name Description
πŸ’² Currency Key (VIOB01.WAERS):
BBAUW13 Building value
BBAUWAKT Current building value
BBETRIEB Production equipment value
BAUSSEN Grounds value
BSCHADEN Structural damage value
BREPSTAU Value of repair backlog
BDMCBMRA Amount per volume unit
BEINHEITW Assessed value of building
BVERSWRT Insurable value amount
Column Name Description
Column Name Description
YBAUJAHR ConstYr
YMODERN Year of modernization
YAUFBAU Year of reconstruction
DBAUBEGI Construction start date
DBAUGENE Building permit
DBEZUGSF Ready for occupancy
DFERTIG Completion
DSCHLUSS Final Inspection
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DAKTBEST Date active in portfolio
DBAUVOR Date of planning inquiry
DVORBES Date of prior notice
DANTBAU Application for building permit
DWIRTUB Transfer usage / charges
DVERKAUF Sale date
DVRKPLAN Planned sale
DNUTZEND End of usage
DFRDVON Public funding from
DFRDBIS Public funding to
VALIDFROM Date: Object Valid From
VALIDTO Date: Object Valid To
Column Name Description
JDENKMAL Protection of Historical Sites Show values
RARTOPT Option rate calculation type Show values
RVERSWRT Type of insurance value Show values
JNURJAHR Indicator: Only regard construction date in terms of years Show values
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 Show values
JANLHIE Indicator: Asset allocation valid for subordin. building Show values
CREATIONTYPE How the Object Was Created Show values
Column Name Description Domain name
XBAUGENE Note on building permit XMBEZ
FDACHFL Attic space DEC6_2
BUBRA Cubic Volume DEC8_3
AGESCH Dummy, since replaced: Number of floors DEC2_1
AUGESCH Number of basements DEC2
JLOESCH Real Estate Deletion Indicator/Flag JLOESCH
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
IMKEY Internal Key for Real Estate Object IMKEY
SGRUNDB Land register number SGRUNDB
XGETXT Building text XLBEZ
NEINHEITW Assessed value base year GJAHR
KOSTL Cost Center KOSTL
RFAKT Conversion factor for fractional share of property VVRFAKT
NSTCKLFT Number of highest floor reached by elevator NUMC3
BANZGE Number of floors DEC3_1
RPGENR Building no. of hierarchical superior building part SGENR
SSTCKBIS Uppermost Floor of a Building VVSSTOCKW
SLIFTBIS Elevator to Floor in Building VVSSTOCKW
INTRENO Internal Real Estate Master Data Code VVINTRENO
TXJCD Tax Jurisdiction TXJCD
BERGRP Authorization group VVBERGRP
RESPONSIBLE Person Responsible XUBNAME
USEREXCLUSIVE User with Exclusive Change Authorization XUBNAME
Master Data Relations Join Conditions
Company code
  • VIOB03.MANDT == T001.MANDT
  • VIOB03.BUKRS == T001.BUKRS
Municipality key
  • VIOB03.MANDT == TIVG1.MANDT
  • VIOB03.GEMEINDE == TIVG1.GEMEINDE
Business area
  • VIOB03.MANDT == TGSB.MANDT
  • VIOB03.GSBER == TGSB.GSBER
Heritable building right indicator
  • VIOB03.MANDT == TDO9.MANDT
  • VIOB03.JERBBAU == TDO9.SOBJERBBAU
Controlling area
  • VIOB03.MANDT == TKA01.MANDT
  • VIOB03.KOKRS == TKA01.KOKRS
Profit center
  • ?
  • ?
  • Profit Center
  • VIOB03.MANDT == CEPC.MANDT
  • VIOB03.[column in domain "DATBI"] == CEPC.DATBI
  • VIOB03.[column in domain "KOKRS"] == CEPC.KOKRS
  • VIOB03.PRCTR == CEPC.PRCTR
Settlement profile
  • Settlement Profile
  • Client
  • VIOB03.PROFL == TKB1A.APROF
  • VIOB03.MANDT == TKB1A.MANDT
Roof condit.
  • VIOB03.MANDT == TIV83.MANDT
  • VIOB03.RDAZUST == TIV83.RZUSTAND
Facade condition
  • VIOB03.MANDT == TIV83.MANDT
  • VIOB03.RFAZUST == TIV83.RZUSTAND
Building type
  • VIOB03.MANDT == TIV5A.MANDT
  • VIOB03.RGEBART == TIV5A.SOBJART
Building Condition
  • VIOB03.MANDT == TIV83.MANDT
  • VIOB03.RGEBZUST == TIV83.RZUSTAND
Location class
  • ?
  • Client
  • Location class
  • VIOB03.[column in domain "SMIETSP"] == TIV22.SMIETSP
  • VIOB03.MANDT == TIV22.MANDT
  • VIOB03.SLAGK == TIV22.SLAGK
Main usage type
  • VIOB03.MANDT == TIV36.MANDT
  • VIOB03.SUNUTZA == TIV36.SUNART
Relationship to business entity
  • Company Code
  • Business Entity Number
Other Relations | to Master Data Relations ↑ Join Conditions
Address-object relationship
  • ?
  • Object number (virtual object)
  • Client
  • ?
  • VIOB03.[column in domain "SADRNR"] == SANO1.ADRNR
  • VIOB03.ADRNR == SANO1.OBJNR
  • VIOB03.MANDT == SANO1.MANDT
  • VIOB03.[column in domain "SOBTYP"] == SANO1.OBTYP