VIOB02

Property master data | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
BUKRS FK Company Code
SWENR FK Business Entity Number
SGRNR Land Number for BE
Column Name Description
πŸ’² Currency Key (VIOB01.WAERS):
BDMQMB1 Market value
BDMQMB2 Purchase price
BDNRWERT Land reference value for determining current market value
BDNWERT Land value for determining current market value
Column Name Description
πŸ“ Unit of length (LEINS):
ZULBAUH Permitted building height
Column Name Description
DBDNWERT Date of land value
DBEPLAN Date of development plan
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DAKTBEST Date active in portfolio
DWIRTUB Transfer usage / charges
DVERKAUF Sale date
DVRKPLAN Planned sale
VALIDFROM Date: Object Valid From
VALIDTO Date: Object Valid To
Column Name Description
JVORKAUF Preemptive right indicator Show values
JAUSNAHM Special licence indicator Show values
JGRUNDW Ground water indicator Show values
JUEBERS Danger of flooding indicator Show values
RARTOPT Option rate calculation type Show values
JUNUTZA Indicator: Predominant usage type ' '-ANLKL, 'X'-TIV36 Show values
CREATIONTYPE How the Object Was Created Show values
Column Name Description Domain name
XGRTXT Text for property XLBEZ
RBEPLAN Development plan XMBEZ
XNUTZGRU Current usage of property XMBEZ
NZGRZ Permitted Usage: Site Occupancy Index DEC1_2
NZGFZ Permitted Usage: Floor Area Ratio DEC2_2
NZBMZ Permitted Usage: Construction Dimension Number DEC3_2
NTGRZ Actual Usage: Site Occupancy Index DEC1_2
NTGFZ Actual Usage: Floor Area Ratio DEC2_2
NTBMZ Actual Usage: Construction Dimension Number DEC3_2
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
KOSTL Cost Center KOSTL
RFAKT Conversion factor for fractional share of property VVRFAKT
INTRENO Internal Real Estate Master Data Code VVINTRENO
TXJCD Tax Jurisdiction TXJCD
BERGRP Authorization group VVBERGRP
NFLURNR Number of Tract of Land in Land Register NFLURNR
XFLURST Parcel of Land TEXT10
BRFLURST Fractional Parcel of Land VVBRFLURST
RESPONSIBLE Person Responsible XUBNAME
USEREXCLUSIVE User with Exclusive Change Authorization XUBNAME
Master Data Relations Join Conditions
Company Code
  • VIOB02.MANDT == T001.MANDT
  • VIOB02.BUKRS == T001.BUKRS
Municipality
  • VIOB02.MANDT == TIVG1.MANDT
  • VIOB02.GEMEINDE == TIVG1.GEMEINDE
Business Area
  • VIOB02.MANDT == TGSB.MANDT
  • VIOB02.GSBER == TGSB.GSBER
Heritable Building Right
  • VIOB02.MANDT == TDO9.MANDT
  • VIOB02.JERBBAU == TDO9.SOBJERBBAU
Controlling Area
  • VIOB02.MANDT == TKA01.MANDT
  • VIOB02.KOKRS == TKA01.KOKRS
Profit Center
  • ?
  • ?
  • Profit Center
  • VIOB02.MANDT == CEPC.MANDT
  • VIOB02.[column in domain "DATBI"] == CEPC.DATBI
  • VIOB02.[column in domain "KOKRS"] == CEPC.KOKRS
  • VIOB02.PRCTR == CEPC.PRCTR
Settlement profile for costs
  • Settlement profile for costs
  • Client
  • VIOB02.PROFL == TKB1A.APROF
  • VIOB02.MANDT == TKB1A.MANDT
Usage Type of Property According to Land Use Map
  • VIOB02.MANDT == TIVC4.MANDT
  • VIOB02.RGRNART == TIVC4.RGRNART
Usage type according to development plan
  • VIOB02.MANDT == TIVB3.MANDT
  • VIOB02.RNBPLAN == TIVB3.RNBPLAN
Property Type
  • VIOB02.MANDT == TIV56.MANDT
  • VIOB02.SGRART == TIV56.SGRART
Ground Type
  • VIOB02.MANDT == TIV58.MANDT
  • VIOB02.SGRFRM == TIV58.SGRFRM
Overall Condition
  • VIOB02.MANDT == TIV59.MANDT
  • VIOB02.SGRGZS == TIV59.SGRGZS
Property Quality
  • VIOB02.MANDT == TIV57.MANDT
  • VIOB02.SGRQAL == TIV57.SGRQAL
Land Register
  • Land register number
  • Client
Main Usage Type
  • VIOB02.MANDT == TIV36.MANDT
  • VIOB02.SUNUTZA == TIV36.SUNART
Relationship to Business Entity
  • Company Code
  • Business Entity Number
Local Subdistrict
  • VIOB02.MANDT == TIVG2.MANDT
  • VIOB02.XGEMARK == TIVG2.GEMARK
Other Relations | to Master Data Relations ↑ Join Conditions
Object Address
  • ?
  • Object number (virtual object)
  • Client
  • ?
  • VIOB02.[column in domain "SADRNR"] == SANO1.ADRNR
  • VIOB02.ADRNR == SANO1.OBJNR
  • VIOB02.MANDT == SANO1.MANDT
  • VIOB02.[column in domain "SOBTYP"] == SANO1.OBTYP