VIOB18

Comparative apartments for rent adjustment, external accomm. | #masterdata | Component: Real Estate Management
Column Name Description
MANDT Client
BUKRS FK Company Code
RVGLWHN Comparative apartment key
Column Name Description
πŸ’² Currency in which the basic rent is displayed (WGRUNDM):
BGRUNDM Basic net rent of comparative apartment excl. heating
Column Name Description
πŸ“ Area Unit (FEINS):
FWOHNFL Rental unit living area
Column Name Description
YBAUJAHR ConstYr
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
Column Name Description
SMOEBL Furniture indicator Show values
SHEIZART Heating type Show values
Column Name Description Domain name
AZIMM Number of rooms DEC3
AHALBZI Number of half rooms DEC2
STOCK Dummy (previously storey, replaced by VVSSTOCKW) CHAR2
JLOESCH Real Estate Deletion Indicator/Flag JLOESCH
IMKEY Internal Key for Real Estate Object IMKEY
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
INTRENO Internal Real Estate Master Data Code VVINTRENO
Master Data Relations Join Conditions
Company code
  • VIOB18.MANDT == T001.MANDT
  • VIOB18.BUKRS == T001.BUKRS
Area unit
  • VIOB18.MANDT == T006.MANDT
  • VIOB18.FEINS == T006.MSEHI
Part of building
  • VIOB18.MANDT == TIV12.MANDT
  • VIOB18.SGEBT == TIV12.SGEBT
Representative list of rents
  • VIOB18.MANDT == TIV20.MANDT
  • VIOB18.SMIETSP == TIV20.SMIETSP
Floor
  • VIOB18.MANDT == TIV37.MANDT
  • VIOB18.SSTOCKW == TIV37.SSTOCKW
Currency
  • VIOB18.MANDT == TCURC.MANDT
  • VIOB18.WGRUNDM == TCURC.WAERS
Fixtures and fittings category
  • Fixtures and fittings category
  • Client
  • Representative list of rents assignment
  • VIOB18.XAUSTKL == TIV23.SMKLASS
  • VIOB18.MANDT == TIV23.MANDT
  • VIOB18.SMIETSP == TIV23.SMIETSP
Location class
  • Representative list of rents assignment
  • Client
  • Location class
  • VIOB18.SMIETSP == TIV22.SMIETSP
  • VIOB18.MANDT == TIV22.MANDT
  • VIOB18.XLAGE == TIV22.SLAGK