VIRPS406

Rental units | #transactional | Component: Real Estate Management
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
BUKRS_01 FK Company Code
GSBER_02 FK Business Area
SWENR_03 FK Business Entity Number
SGRNR_04 FK Land Number for BE
SGENR_05 FK Building Number
SMENR_06 FK Number of Rental Unit
Column Name Description
💲 User field: Unit for value fields (USRCUKY1):
USR06 User field 1 for values (length 10.3)
💲 User field: Unit for value fields (USRCUKY2):
USR07 User field 2 for values (length 10.3)
💲 Currency Key (WAERS):
BKOND Condition: amount
Column Name Description
📏 User field: Unit for quantity fields (USRUNIT1):
USR04 User field 1 for set (length 10,3)
📏 User field: Unit for quantity fields (USRUNIT2):
USR05 User field 2 for set (length 10.3)
📏 Area Unit (FEINS):
FBEZUG Reference area for calculation of amounts per area unit
FQMFLART Area of area type
📏 Base Unit of Measure (MEINS):
BABRE Apportionment units
📏 Unit for cubic volume (REINS):
UMBRAUM Cubic Volume
Column Name Description
SPTAG Period to analyze - current date
USR08 User field 1 for date
USR09 User field 2 for date
DSFLART Area: effective from
DATAB Cost center: effective from_
DGULTAB Condition: effective from
DBEZU Date: First usage
DGAB Apportionment unit: effective from
BELEAB Occupancy type: effet.from
BELEBIS Occupancy type: eff. to
DBEGEH Last access: date
DFSTRBIS Date: Cash flow until
DHPZSAKT CH rent adj.:Date of mort.loan rate status for current rent
DUTBKAKT CH rnt adj.:Dte maint./oper.costs index status for new rent
DTEURAKT CH rnt adj.:Dte of living stndrd index status for curr.rent
DWTVERM Date: Subsequent rental
DBINDBIS Occupancy obligation: until
DRESAB Date: Reserved from
DRESBIS Date: Reserved upto
Column Name Description
USR10 User field 1 indicator for evaluations Show values
USR11 User field 2 indicator for evaluations Show values
SMOEBL Furniture indicator Show values
JEIGWOHN Rental Unit in Separate Ownership (COA) Show values
JVORSTEIG Input tax deduction for vacancy Show values
JKONDMV Cond.transfer RA: indicator Show values
JRMSCHPR Tenant service charge settlement? Show values
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
XORT Address: City TEXT35
XPLZ Address: Postal code PSTLZ
XSTRASSE Address: Street/house number TEXT35
ANZME Number of rental units DEC6
USR02 User-defined field 1 for 10 characters USRCHAR10
USR03 User-defined field 2 for 10 characters USRCHAR10
USR00 User-defined field 1 for 20 characters USRCHAR20
USR01 User field 2 for 20 characters USRCHAR20
KOSTL Cost center: name KOSTL
ADRNR Object number (virtual object) SOBJNR
INTRENO Internal Real Estate Master Data Code VVINTRENO
PRCTR Profit Center PRCTR
STTXT_EXT Status: Set by user CHAR40
STTXT_INT Status: Set by system CHAR40
XMETXT Text for rental unit XMBEZ
XNUNR Rental unit usage type (text) CHAR30
SALTNR Number of rental unit in existing real estate system SALTNR
BRAART Number of rooms per room type DEC3
XMERKMA Characteristic XTEXT30
XSTOCKW Floor (text) CHAR15
XLGESCH Location in floor (text) CHAR15
TXT04 Occupancy type: short text CHAR04
TXT30 Occupancy type (text) CHAR30
XBEGEH Last inspection: by XKBEZ
PERHOE Increase: percentage DEC8_2
XPROZGRD Increase: Reason for difference CHAR15
AZIMM Number of rooms DEC6
AHALBZI Number of half rooms DEC6
XSTANDNR Number of garage / parking space VVXSTANDNR
ABNNR Settlement firm: number TEXT20
STECHEM Settlement firm: Evaluation group STECHEM
RFAKT Conversion factor for fractional share of property CHAR6
PKONDMV Cond.transfer LO: percent PRZ32
XMIETSP Representative list of rents: allocation CHAR15
PZUABSP Representative list of rents: surcharge/reduction DEC8_2
XLAGK Representative list of rents: locat.class XMBEZ
XAUSTKL Represent. list of rents: Fixture/fitting category CHAR15
XBELBIND Occupancy obligation: to CHAR15
SBWNR Reservation application number of a rental unit VVXBWNR
XPARTNR Name of applicant for a rental unit CHAR35
XNNPART Last name of applicant TEXT20
XGEBT Building: part CHAR15
Master Data Relations Join Conditions
Company Code
  • VIRPS406.MANDT == T001.MANDT
  • VIRPS406.BUKRS == T001.BUKRS
Company Code
  • VIRPS406.MANDT == T001.MANDT
  • VIRPS406.BUKRS_01 == T001.BUKRS
Area Unit
  • VIRPS406.MANDT == T006.MANDT
  • VIRPS406.FEINS == T006.MSEHI
Business Area
  • VIRPS406.MANDT == TGSB.MANDT
  • VIRPS406.GSBER == TGSB.GSBER
Business Area
  • VIRPS406.MANDT == TGSB.MANDT
  • VIRPS406.GSBER_02 == TGSB.GSBER
Client VIRPS406.MANDT == T000.MANDT
Base Unit of Measure
  • VIRPS406.MANDT == T006.MANDT
  • VIRPS406.MEINS == T006.MSEHI
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • VIRPS406.PERIV == T009.PERIV
  • VIRPS406.MANDT == T009.MANDT
Occupancy obligation key
  • VIRPS406.MANDT == TIV31.MANDT
  • VIRPS406.RBELBIND == TIV31.RBELBIND
Unit for cubic volume
  • VIRPS406.MANDT == T006.MANDT
  • VIRPS406.REINS == T006.MSEHI
Location on Floor
  • VIRPS406.MANDT == TIV38.MANDT
  • VIRPS406.RLGESCH == TIV38.RLGESCH
Increase: Reason for difference
  • VIRPS406.MANDT == TIV43.MANDT
  • VIRPS406.RPROZGRD == TIV43.RPROZGRD
Apportionment unit: type
  • VIRPS406.MANDT == TIV07.MANDT
  • VIRPS406.SABRG == TIV07.SABRG
Fixtures and fittings category
  • Fixtures and fittings category
  • Client
  • Representative list of rents assignment
  • VIRPS406.SAUSTKL == TIV23.SMKLASS
  • VIRPS406.MANDT == TIV23.MANDT
  • VIRPS406.SMIETSP == TIV23.SMIETSP
Area type
  • VIRPS406.MANDT == TIV08.MANDT
  • VIRPS406.SFLART == TIV08.SFLART
Part of Building
  • VIRPS406.MANDT == TIV12.MANDT
  • VIRPS406.SGEBT == TIV12.SGEBT
Building: number
  • Building: number
  • Company Code
  • Business Entity Number
  • VIRPS406.MANDT == VIOB03.MANDT
  • VIRPS406.SGENR == VIOB03.SGENR
  • VIRPS406.BUKRS == VIOB03.BUKRS
  • VIRPS406.SWENR == VIOB03.SWENR
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
  • VIRPS406.MANDT == VIOB03.MANDT
  • VIRPS406.SGENR_05 == VIOB03.SGENR
  • VIRPS406.BUKRS == VIOB03.BUKRS
  • VIRPS406.SWENR == VIOB03.SWENR
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
  • VIRPS406.BUKRS == VIOB02.BUKRS
  • VIRPS406.SGRNR == VIOB02.SGRNR
  • VIRPS406.MANDT == VIOB02.MANDT
  • VIRPS406.SWENR == VIOB02.SWENR
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
  • VIRPS406.BUKRS == VIOB02.BUKRS
  • VIRPS406.SGRNR_04 == VIOB02.SGRNR
  • VIRPS406.MANDT == VIOB02.MANDT
  • VIRPS406.SWENR == VIOB02.SWENR
Condition: Type
  • Condition: Type
  • ?
  • VIRPS406.MANDT == TZK01.MANDT
  • VIRPS406.SKOART == TZK01.SKOART
  • VIRPS406.[column in domain "RANTYP"] == TZK01.RANTYP
Location class
  • Representative list of rents assignment
  • Client
  • Location class
  • VIRPS406.SMIETSP == TIV22.SMIETSP
  • VIRPS406.MANDT == TIV22.MANDT
  • VIRPS406.SLAGK == TIV22.SLAGK
Rental unit: number
  • Company Code
  • Business Entity Number
  • Rental unit: number
  • VIRPS406.MANDT == VIMI01.MANDT
  • VIRPS406.BUKRS == VIMI01.BUKRS
  • VIRPS406.SWENR == VIMI01.SWENR
  • VIRPS406.SMENR == VIMI01.SMENR
Number of Rental Unit
  • Company Code
  • Business Entity Number
  • Number of Rental Unit
  • VIRPS406.MANDT == VIMI01.MANDT
  • VIRPS406.BUKRS == VIMI01.BUKRS
  • VIRPS406.SWENR == VIMI01.SWENR
  • VIRPS406.SMENR_06 == VIMI01.SMENR
Fixtures and Fittings Characteristics
  • Fixtures and Fittings Characteristics
  • Client
  • VIRPS406.SMERKMA == TIV71.SMERKMA
  • VIRPS406.MANDT == TIV71.MANDT
Representative list of rents assignment
  • VIRPS406.MANDT == TIV20.MANDT
  • VIRPS406.SMIETSP == TIV20.SMIETSP
Rental unit external usage type
  • Rental unit external usage type
  • Client
  • VIRPS406.SNUNR == TIV01.SNUNR
  • VIRPS406.MANDT == TIV01.MANDT
Room type
  • Room type
  • Client
  • VIRPS406.SRAART == TIV09.SRAART
  • VIRPS406.MANDT == TIV09.MANDT
For RUs with Multiple Floors: Top Floor of RU
  • VIRPS406.MANDT == TIV37.MANDT
  • VIRPS406.SSTCKBIS == TIV37.SSTOCKW
Floor
  • VIRPS406.MANDT == TIV37.MANDT
  • VIRPS406.SSTOCKW == TIV37.SSTOCKW
Business Entity Number
  • Company Code
  • Business Entity Number
  • VIRPS406.MANDT == VIOB01.MANDT
  • VIRPS406.BUKRS == VIOB01.BUKRS
  • VIRPS406.SWENR == VIOB01.SWENR
Business Entity Number
  • Company Code
  • Business Entity Number
  • VIRPS406.MANDT == VIOB01.MANDT
  • VIRPS406.BUKRS == VIOB01.BUKRS
  • VIRPS406.SWENR_03 == VIOB01.SWENR
User field: Unit for value fields
  • VIRPS406.MANDT == TCURC.MANDT
  • VIRPS406.USRCUKY1 == TCURC.WAERS
User field: Unit for value fields
  • VIRPS406.MANDT == TCURC.MANDT
  • VIRPS406.USRCUKY2 == TCURC.WAERS
User field: Unit for quantity fields
  • VIRPS406.MANDT == T006.MANDT
  • VIRPS406.USRUNIT1 == T006.MSEHI
User field: Unit for quantity fields
  • VIRPS406.MANDT == T006.MANDT
  • VIRPS406.USRUNIT2 == T006.MSEHI
Currency Key
  • VIRPS406.MANDT == TCURC.MANDT
  • VIRPS406.WAERS == TCURC.WAERS