VDHOBJ

Collateral Objects | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
ROBJNR Collateral object number
Column Name Description
💲 Currency Key (SKAUFWHR):
BBAUW13 Building value
BKAUF Purchase price/total prime costs
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DANTBAU Application for building permit
DBAUGENE Building permit
DBEZUGSF Ready for occupancy
DFERTIG Completion
DSCHLUSS Final Inspection
DKAUF Object purchase date
DERBBAU Inheritable building leasehold end
Column Name Description
SZWANG Collateral object legal measures ID Show values
JREICHSH Reichsheimstätte indicator Show values
JDENKMAL Protection of Historical Sites Show values
JHAUPT Indicator for the main object within a complete object Show values
SFGKZ Release Indicator Show values
MODGRAD Modernization Grade Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
SGRUNDB Land register number SGRUNDB
XBAUGENE Note on building permit XMBEZ
YBAUJ ConstYr GJAHR
YLMOD Year of last modernization GJAHR
NWOHNNR Apartment number for condominium CHAR5
NGESCHNR Floor Number for Condominium CHAR5
RFAKT Conversion factor for fractional share of property VVRFAKT
BMITEIG Co-ownership share DEC6_3
RKLAMMER Object master number VVRSTANR
XOBJALT Previous object number XKBEZ
YBAUJF Notional Construction Year GJAHR
WRND Economical Remaining Useful Life
MOD_RND Modified Remaining Useful Life (rounded)
ASTUFE Faciity level
GND Total Useful Life
BAUINDEX_STAND Building index state CMLQUARTER
LRINTRENO Internal Number of Land Register CHAR13
LRDISTRICT Land Register District CHAR60
LRVOLUMENO Number of Land Register Volume CHAR15
LRPAGENO Page Number in Land Register CHAR15
LRTYPE Land Register Type NUMC2
XLR Name of Land Register CHAR60
Master Data Relations Join Conditions
Address number for collateral object
  • Address number for collateral object
  • ?
  • ?
  • VDHOBJ.MANDT == ADRC.CLIENT
  • VDHOBJ.BOBADRNR == ADRC.ADDRNUMBER
  • VDHOBJ.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • VDHOBJ.[column in domain "AD_NATION"] == ADRC.NATION
Area Unit
  • VDHOBJ.MANDT == T006.MANDT
  • VDHOBJ.FEINS == T006.MSEHI
Heritable building right indicator for collateral objects
  • VDHOBJ.MANDT == TDO9.MANDT
  • VDHOBJ.JERBBAU == TDO9.SOBJERBBAU
Client VDHOBJ.MANDT == T000.MANDT
Room Contents
  • VDHOBJ.MANDT == T006.MANDT
  • VDHOBJ.REINS == T006.MSEHI
Property conditions
  • Property conditions
  • Client
  • VDHOBJ.SGVER == TDO8.SGVER
  • VDHOBJ.MANDT == TDO8.MANDT
Currency
  • VDHOBJ.MANDT == TCURC.MANDT
  • VDHOBJ.SKAUFWHR == TCURC.WAERS
Usage Type
  • Main usage type of object
  • Client
  • VDHOBJ.SNUTZART == TIV01.SNUNR
  • VDHOBJ.MANDT == TIV01.MANDT
Indicator for Object Type
  • VDHOBJ.MANDT == TIV5A.MANDT
  • VDHOBJ.SOBJART == TIV5A.SOBJART
Object fixtures/fittings indicator
  • VDHOBJ.MANDT == TDO11.MANDT
  • VDHOBJ.SOBJAUST == TDO11.SOBJAUST
Building Method
  • VDHOBJ.MANDT == TDO1.MANDT
  • VDHOBJ.SOBJBAU == TDO1.SOBJBAU
Indicator: Area Description for Object
  • Indicator: Area Description for Object
  • Client
  • VDHOBJ.SOBJGEB == TDO12.SOBJGEB
  • VDHOBJ.MANDT == TDO12.MANDT
Object Location
  • VDHOBJ.MANDT == TIV45.MANDT
  • VDHOBJ.SOBJLAGE == TIV45.SOBJLAGE
Indicator for Condition of Object
  • VDHOBJ.MANDT == TDO10.MANDT
  • VDHOBJ.SOBJZUST == TDO10.SOBJZUST
Transport conn.
  • Transport Connections of Business Entity
  • Client
  • VDHOBJ.SVERKEHR == TIV44.SVERKEHR
  • VDHOBJ.MANDT == TIV44.MANDT