VIBDRO

Rental Object | #masterdata | Component: Basic Data
Column Name Description
MANDT Client
INTRENO Internal Key of Real Estate Object
Column Name Description
πŸ’² Currency Key (VPTCURRENCY):
VPT Property Taxable Value
Column Name Description
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
FIRSTPOSTING Cash Flow Generated Starting On
DBEZU Date of initial usage
DWTVERM Date: Subsequent rental
DRESAB Date: Reserved from
DRESBIS Date: Reserved upto
DRESTAUR Date of reconstruction/extensive modernization
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived
CFLOCKEDTO Date Until Which the Cash Flow Is Locked
CFPOSTINGFROM First Posting From
BUILDYEAR ConstYr
YEARDECONSTR Year of Demolition
Column Name Description
CREATIONTYPE How the Object Was Created Show values
ROTYPE Rental Object Type Show values
CANBECOMMON Common Usage Possible Show values
SPOSINMSP Method for Calculating Base Rent of Rep. List of Rents Show values
JEIGWOHN Rental Unit in Separate Ownership (COA) Show values
HASCOP Uses Current Occupancy Principle Show values
USESRLRA Representative List of Rents Is Used Show values
COMMONOWNED Rental Object Is Common Property Show values
OOLOCK Do Not Consider Object for Real Estate Search Show values
FLOOR Code of Floor Show values
KITCHEN Code of Cooking Facilities Show values
OBJCOND Code of Dwelling Status Show values
USAGETYPE Code of Usage Type Show values
PROTCV Protected City View (Conservation Law 1988, Article 1g) Show values
LLPMON Conservation Paid by Landlord Show values
CAREHOME Care Home Show values
STATMON State Monument (Conservation Law 1988, Article 1d) Show values
Column Name Description Domain name
SWENR Business Entity Number REBDBENO
SMENR Number of Rental Object REBDRONO
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
XMETXT Rental Object Name RECAXLDESCRIPTION
SALTNR Number of rental unit in existing real estate system SALTNR
PZUABSP Increase or Reduction for Representative List of Rents REBDSUREPERCENT
PPOSINMSP Percentage for Positioning RU in RLR Spread DECV3_2
PERHOE Percentage rate increase DEC3_2
XSTANDNR Number of garage / parking space VVXSTANDNR
EDID Federal Building Entrance Identification Number (EDID) REXCCHEDID
EGID Federal Building Identification Number (EGID) REXCCHEGID
FLOORLOC Location of Dwelling on a Floor REXCCHROFLOORLOC
EWID Federal Dwelling Identification Number (EWID) REXCCHEWID
ADMINNO Administrative Dwelling Number REXCCHROADMINNO
DOORNO Door Number of Dwelling REXCCHRODOORNO
NUMROOMS Number of Rooms in the Dwelling REXCCHRONUMROOMS
LIVINGAREA Floor Area of Dwelling in M2 REXCCHGWRFORMATUNITFIELD
GEMEINDECH Land Register District RELMLRDISTRICT
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • VIBDRO.MANDT == T001.MANDT
  • VIBDRO.BUKRS == T001.BUKRS
Conservation Level
  • Conservation Level
  • Client
Currency Key
  • VIBDRO.MANDT == TCURC.MANDT
  • VIBDRO.CURRENCY == TCURC.WAERS
Person Responsible
  • VIBDRO.MANDT == USR02.MANDT
  • VIBDRO.RESPONSIBLE == USR02.BNAME
Location on Floor
  • VIBDRO.MANDT == TIV38.MANDT
  • VIBDRO.RLGESCH == TIV38.RLGESCH
Representative List of Rents
  • Representative List of Rents
  • Client
Fixtures and Fittings Category
  • ?
  • Fixtures and Fittings Category
Location Class
  • Representative List of Rents
  • Location Class
Reason for Reduced Increase Percentage Rate
  • VIBDRO.MANDT == TIV43.MANDT
  • VIBDRO.RPROZGRD == TIV43.RPROZGRD
Part of Building
  • VIBDRO.MANDT == TIV12.MANDT
  • VIBDRO.SGEBT == TIV12.SGEBT
Usage Type of Rental Object
  • Usage Type of Rental Object
  • Client
  • VIBDRO.SNUNR == TIV01.SNUNR
  • VIBDRO.MANDT == TIV01.MANDT
Up to Floor
  • VIBDRO.MANDT == TIV37.MANDT
  • VIBDRO.SSTCKBIS == TIV37.SSTOCKW
Floor
  • VIBDRO.MANDT == TIV37.MANDT
  • VIBDRO.SSTOCKW == TIV37.SSTOCKW
User with Exclusive Change Authorization
  • VIBDRO.MANDT == USR02.MANDT
  • VIBDRO.USEREXCLUSIVE == USR02.BNAME
Currency Key
  • VIBDRO.MANDT == TCURC.MANDT
  • VIBDRO.VPTCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Neighborhood
Neighborhood
Neighborhood