VIBDPR

Land | #masterdata | Component: Basic Data
Column Name Description
MANDT Client
INTRENO Internal Key of Real Estate Object
Column Name Description
πŸ’² Currency Key (WAERS):
BDMQMB1 Market value
BDMQMB2 Purchase price
BDNRWERT Land reference value for determining current market value
BDNWERT Land value for determining current market value
πŸ’² Currency Key (CURRENCY):
VPT Property Taxable Value
Column Name Description
πŸ“ Unit of length (LEINS):
ZULBAUH Permitted building height
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
VALIDFROM Date: Object Valid From
VALIDTO Date: Object Valid To
DBDNWERT Date of land value
DBEPLAN Date of development plan
DWIRTUB Transfer usage / charges
DVERKAUF Sale date
DVRKPLAN Planned sale
Column Name Description
CREATIONTYPE How the Object Was Created Show values
Column Name Description Domain name
SWENR Business Entity Number REBDBENO
SGRNR Number of Land REBDPRNO
IMKEY Internal Key of Real Estate Object (FI) IMKEY
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
AUTHGRP Authorization Group RECAAUTHGRP
XGRTXT Name of Land RECAXLDESCRIPTION
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
JUNUTZA OBSOLETE: Main Usage Type CHAR1
NFLURNR Number of Tract of Land in Land Register NFLURNR
XFLURST Parcel of Land TEXT10
BRFLURST Fractional Parcel of Land VVBRFLURST
PLANNO Real Properties Register Number RELMRPRGNO
LOCATIONCH Location Description of Land Acc. To Tax Auth. RECAXLDESCRIPTION
ESTATEDESCR Location Description of Land Acc. To Land Register RECAXLDESCRIPTION
GEMEINDECH Land Register District RELMLRDISTRICT
SECCO Section Code SECCO
BUPLA Business Place J_1BBRANCH
Master Data Relations Join Conditions
Company Code
  • VIBDPR.MANDT == T001.MANDT
  • VIBDPR.BUKRS == T001.BUKRS
Currency Key
  • VIBDPR.MANDT == TCURC.MANDT
  • VIBDPR.CURRENCY == TCURC.WAERS
Municipality key
  • VIBDPR.MANDT == TIVG1.MANDT
  • VIBDPR.GEMEINDE == TIVG1.GEMEINDE
Heritable building right indicator
  • VIBDPR.MANDT == TDO9.MANDT
  • VIBDPR.JERBBAU == TDO9.SOBJERBBAU
Unit of length
  • VIBDPR.MANDT == T006.MANDT
  • VIBDPR.LEINS == T006.MSEHI
Person Responsible
  • VIBDPR.MANDT == USR02.MANDT
  • VIBDPR.RESPONSIBLE == USR02.BNAME
Usage Type of Property According to Land Use Map
  • VIBDPR.MANDT == TIVC4.MANDT
  • VIBDPR.RGRNART == TIVC4.RGRNART
Usage type according to development plan
  • VIBDPR.MANDT == TIVB3.MANDT
  • VIBDPR.RNBPLAN == TIVB3.RNBPLAN
Property Type
  • VIBDPR.MANDT == TIV56.MANDT
  • VIBDPR.SGRART == TIV56.SGRART
Ground Type
  • VIBDPR.MANDT == TIV58.MANDT
  • VIBDPR.SGRFRM == TIV58.SGRFRM
Overall Condition
  • VIBDPR.MANDT == TIV59.MANDT
  • VIBDPR.SGRGZS == TIV59.SGRGZS
Property Quality
  • VIBDPR.MANDT == TIV57.MANDT
  • VIBDPR.SGRQAL == TIV57.SGRQAL
Main Usage Type
  • VIBDPR.MANDT == TIV36.MANDT
  • VIBDPR.SUNUTZA == TIV36.SUNART
User with Exclusive Change Authorization
  • VIBDPR.MANDT == USR02.MANDT
  • VIBDPR.USEREXCLUSIVE == USR02.BNAME
Function of Object
  • ?
  • Function of Object
Currency Key
  • VIBDPR.MANDT == TCURC.MANDT
  • VIBDPR.WAERS == TCURC.WAERS
Local Subdistrict
  • VIBDPR.MANDT == TIVG2.MANDT
  • VIBDPR.XGEMARK == TIVG2.GEMARK