VIRPS405

Building | #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
SGENR_04 FK Building Number
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):
BBAUW13 Building value
BBAUWAKT Current building value
BBETRIEB Production equipment value
BAUSSEN Grounds value
BSCHADEN Structural damage value
BREPSTAU Value of repair backlog
BDMCBMRA Amount per volume unit
BEINHEITW Assessed value of building
BVERSWRT Insurable value 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):
FQMFLART Area of area type
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
DVERKAUF Date: Sale
DVRKPLAN Date: Planned sale
YBAUJAHR ConstYr
YMODERN Year of modernization
YAUFBAU Year of reconstruction
DBAUBEGI Construction start date
DBAUGENE Building permit
DBEZUGSF Ready for occupancy
DFERTIG Completion
DSCHLUSS Final Inspection
DAKTBEST Date active in portfolio
DBAUVOR Date of planning inquiry
DVORBES Date of prior notice
DANTBAU Application for building permit
DWIRTUB Transfer usage / charges
DNUTZEND End of usage
DFRDVON Public funding from
DFRDBIS Public funding to
Column Name Description
USR10 User field 1 indicator for evaluations Show values
USR11 User field 2 indicator for evaluations Show values
JDENKMAL Protection of Historical Sites Show values
RVERSWRT Type of insurance value Show values
JNURJAHR Indicator: Only regard construction date in terms of years 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
ANZGE No. of buildings 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 KOSTL
ADRNR Object number (virtual object) SOBJNR
PRCTR Profit Center PRCTR
STTXT_EXT Status: Set by user CHAR40
STTXT_INT Status: Set by system CHAR40
XUNART Main usage type XTEXT35
XGEBART Type of building XTEXT50
JERBBAU Heritable building right indicator SOBJERBBAU
XGEBZUST Description of condition of building XTEXT50
XBAUGENE Note on building permit XMBEZ
FDACHFL Attic space DEC6_2
XDAZUST Condition of roof XTEXT50
XFAZUST Condition of facade XTEXT50
BUBRA Cubic Volume DEC8_3
AUGESCH Number of basements DEC2
XGBVON Land register district XTEXT25
XGETXT Building text XLBEZ
NEINHEITW Assessed value base year GJAHR
XVERSWRT Type of insurance value TEXT25
XMIETSP Representative list of rents: allocation CHAR15
XLAGK Description of location class for rep.list of rents XMBEZ
RFAKT Conversion factor for fractional share of property VVRFAKT
NSTCKLFT Number of highest floor reached by elevator CHAR3
BANZGE Number of floors DEC3_1
XPGENR Building text XLBEZ
XMERKMA Description of characteristic XTEXT50
Master Data Relations Join Conditions
Asset Subnumber
  • Asset Subnumber
  • Company Code
  • Main Asset Number
  • VIRPS405.MANDT == ANLA.MANDT
  • VIRPS405.ANLN2 == ANLA.ANLN2
  • VIRPS405.BUKRS == ANLA.BUKRS
  • VIRPS405.ANLN1 == ANLA.ANLN1
Company Code
  • VIRPS405.MANDT == T001.MANDT
  • VIRPS405.BUKRS == T001.BUKRS
Company Code
  • VIRPS405.MANDT == T001.MANDT
  • VIRPS405.BUKRS_01 == T001.BUKRS
Area Unit
  • VIRPS405.MANDT == T006.MANDT
  • VIRPS405.FEINS == T006.MSEHI
Business Area
  • VIRPS405.MANDT == TGSB.MANDT
  • VIRPS405.GSBER == TGSB.GSBER
Business Area
  • VIRPS405.MANDT == TGSB.MANDT
  • VIRPS405.GSBER_02 == TGSB.GSBER
Client VIRPS405.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • VIRPS405.PERIV == T009.PERIV
  • VIRPS405.MANDT == T009.MANDT
Settlement Profile
  • Settlement Profile
  • Client
  • VIRPS405.PROFL == TKB1A.APROF
  • VIRPS405.MANDT == TKB1A.MANDT
Condition of roof
  • VIRPS405.MANDT == TIV83.MANDT
  • VIRPS405.RDAZUST == TIV83.RZUSTAND
Unit for cubic volume
  • VIRPS405.MANDT == T006.MANDT
  • VIRPS405.REINS == T006.MSEHI
Condition of facade
  • VIRPS405.MANDT == TIV83.MANDT
  • VIRPS405.RFAZUST == TIV83.RZUSTAND
Type of building
  • VIRPS405.MANDT == TIV5A.MANDT
  • VIRPS405.RGEBART == TIV5A.SOBJART
General condition of building
  • VIRPS405.MANDT == TIV83.MANDT
  • VIRPS405.RGEBZUST == TIV83.RZUSTAND
Building no. of hierarchical superior building part
  • Building no. of hierarchical superior building part
  • Company Code
  • Business Entity Number
  • VIRPS405.MANDT == VIOB03.MANDT
  • VIRPS405.RPGENR == VIOB03.SGENR
  • VIRPS405.BUKRS == VIOB03.BUKRS
  • VIRPS405.SWENR == VIOB03.SWENR
Area type
  • VIRPS405.MANDT == TIV08.MANDT
  • VIRPS405.SFLART == TIV08.SFLART
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
  • VIRPS405.MANDT == VIOB03.MANDT
  • VIRPS405.SGENR == VIOB03.SGENR
  • VIRPS405.BUKRS == VIOB03.BUKRS
  • VIRPS405.SWENR == VIOB03.SWENR
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
  • VIRPS405.MANDT == VIOB03.MANDT
  • VIRPS405.SGENR_04 == VIOB03.SGENR
  • VIRPS405.BUKRS == VIOB03.BUKRS
  • VIRPS405.SWENR == VIOB03.SWENR
Land register number
  • Land register number
  • Client
Location class
  • Representative list of rents assignment
  • Client
  • Location class
  • VIRPS405.SMIETSP == TIV22.SMIETSP
  • VIRPS405.MANDT == TIV22.MANDT
  • VIRPS405.SLAGK == TIV22.SLAGK
Fixtures and Fittings Characteristics
  • Fixtures and Fittings Characteristics
  • Client
  • VIRPS405.SMERKMA == TIV71.SMERKMA
  • VIRPS405.MANDT == TIV71.MANDT
Representative list of rents assignment
  • VIRPS405.MANDT == TIV20.MANDT
  • VIRPS405.SMIETSP == TIV20.SMIETSP
Main usage type
  • VIRPS405.MANDT == TIV36.MANDT
  • VIRPS405.SUNUTZA == TIV36.SUNART
Business Entity Number
  • Company Code
  • Business Entity Number
  • VIRPS405.MANDT == VIOB01.MANDT
  • VIRPS405.BUKRS == VIOB01.BUKRS
  • VIRPS405.SWENR == VIOB01.SWENR
Business Entity Number
  • Company Code
  • Business Entity Number
  • VIRPS405.MANDT == VIOB01.MANDT
  • VIRPS405.BUKRS == VIOB01.BUKRS
  • VIRPS405.SWENR_03 == VIOB01.SWENR
User field: Unit for value fields
  • VIRPS405.MANDT == TCURC.MANDT
  • VIRPS405.USRCUKY1 == TCURC.WAERS
User field: Unit for value fields
  • VIRPS405.MANDT == TCURC.MANDT
  • VIRPS405.USRCUKY2 == TCURC.WAERS
User field: Unit for quantity fields
  • VIRPS405.MANDT == T006.MANDT
  • VIRPS405.USRUNIT1 == T006.MSEHI
User field: Unit for quantity fields
  • VIRPS405.MANDT == T006.MANDT
  • VIRPS405.USRUNIT2 == T006.MSEHI
Currency Key
  • VIRPS405.MANDT == TCURC.MANDT
  • VIRPS405.WAERS == TCURC.WAERS