S405

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 Value: Building value 1913
BBAUWAKT Value: current building value
BBETRIEB Value: facilities
BAUSSEN Value: Grounds
BSCHADEN Value: Structural damage
BREPSTAU Value: Repair backlog
BDMCBMRA Amount per volume unit
BEINHEITW Assessed value: value
BVERSWRT Insurable value: amount
Column Name Description
📏 User field: Unit for quantity fields (USRUNIT1):
USR04 User Field 1 for Set (Length 12,3)
📏 User field: Unit for quantity fields (USRUNIT2):
USR05 User Field 2 for Set (Length 12,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 Year: construction year
YMODERN Year: modernization
YAUFBAU Year: reconstruction
DBAUBEGI Date: building start
DBAUGENE Building permit: date
DBEZUGSF Date: Ready for occupancy
DFERTIG Date: Completion
DSCHLUSS Date: final inspection
DAKTBEST Date active in portfolio
DBAUVOR Date: Planning inquiry
DVORBES Date: prior notice
DANTBAU Date: Building permit application
DWIRTUB Date: Transfer usage/charges
DNUTZEND Date: end of usage
DFRDVON Date: Public funding from
DFRDBIS Date: 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
JANLHIE Indicator: Asset allocation valid for subordin. building 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 Building: Building type XTEXT50
JERBBAU Heritable building right indicator SOBJERBBAU
XGEBZUST Condition: general condition XTEXT50
XBAUGENE Building permit: note XMBEZ
FDACHFL Attic space DEC6_2
XDAZUST Condition: roof CHAR30
XFAZUST Condition: facade CHAR30
BUBRA Cubic Volume REDEC12_3
AUGESCH Number of basements DEC2
XGBVON Land register district XTEXT25
XGETXT Building text XLBEZ
NEINHEITW Assessed value: base year GJAHR
XVERSWRT Insurance value type TEXT25
XMIETSP Representative list of rents: allocation CHAR15
XLAGK Representative list of rents: locat.class XMBEZ
RFAKT Conversion factor for fractional share of property CHAR6
NSTCKLFT Number of highest floor reached by elevator CHAR3
BANZGE Number of floors DEC5_1
XMERKMA Characteristic XTEXT30
TXJCD Tax Jurisdiction TXJCD
VVSAOGR Group of object characteristics VVSAOGR
VVXAOGR Group of object characteristics XTEXT30
VVSAOB Number of Object Characteristic VVSAOB
VVXAOB Number of Object Characteristic XTEXT30
VVSAUSP Number of object characteristic value VVSAUSP
VVXAUSP Number of object characteristic value XTEXT30
BERGRP Authorization group VVBERGRP
GEMEINDE Municipality key VVGEMEINDE
XGEMEINDE Name of municipality VVXGEMEINDE
XKREIS Name of district VVXKREIS
XREGIO Name of federal state VVXREGIO
XERBBAU Heritable building right XTEXT30
DUMMYFIELD Single-Character Flag CHAR1
Master Data Relations Join Conditions
Asset: Subnumber
  • Asset: Subnumber
  • Company Code
  • Asset: main number
  • S405.MANDT == ANLA.MANDT
  • S405.ANLN2 == ANLA.ANLN2
  • S405.BUKRS == ANLA.BUKRS
  • S405.ANLN1 == ANLA.ANLN1
Company Code
  • S405.MANDT == T001.MANDT
  • S405.BUKRS == T001.BUKRS
Company Code
  • S405.MANDT == T001.MANDT
  • S405.BUKRS_01 == T001.BUKRS
Area Unit
  • S405.MANDT == T006.MANDT
  • S405.FEINS == T006.MSEHI
Business Area
  • S405.MANDT == TGSB.MANDT
  • S405.GSBER == TGSB.GSBER
Business Area
  • S405.MANDT == TGSB.MANDT
  • S405.GSBER_02 == TGSB.GSBER
Client S405.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S405.PERIV == T009.PERIV
  • S405.MANDT == T009.MANDT
Settlement Profile
  • Settlement Profile
  • Client
  • S405.PROFL == TKB1A.APROF
  • S405.MANDT == TKB1A.MANDT
Condition of roof
  • S405.MANDT == TIV83.MANDT
  • S405.RDAZUST == TIV83.RZUSTAND
Unit for cubic volume
  • S405.MANDT == T006.MANDT
  • S405.REINS == T006.MSEHI
Condition of facade
  • S405.MANDT == TIV83.MANDT
  • S405.RFAZUST == TIV83.RZUSTAND
Type of building
  • S405.MANDT == TIV5A.MANDT
  • S405.RGEBART == TIV5A.SOBJART
General condition of building
  • S405.MANDT == TIV83.MANDT
  • S405.RGEBZUST == TIV83.RZUSTAND
Building no. of hierarchical superior building part
  • Building no. of hierarchical superior building part
  • Company Code
  • Business Entity Number
Area type
  • S405.MANDT == TIV08.MANDT
  • S405.SFLART == TIV08.SFLART
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
Building Number
  • Building Number
  • Company Code
  • Business Entity Number
Land register number
  • Land register number
  • Client
Location class
  • Representative list of rents assignment
  • Client
  • Location class
  • S405.SMIETSP == TIV22.SMIETSP
  • S405.MANDT == TIV22.MANDT
  • S405.SLAGK == TIV22.SLAGK
Fixtures and Fittings Characteristics
  • Fixtures and Fittings Characteristics
  • Client
  • S405.SMERKMA == TIV71.SMERKMA
  • S405.MANDT == TIV71.MANDT
Representative list of rents assignment
  • S405.MANDT == TIV20.MANDT
  • S405.SMIETSP == TIV20.SMIETSP
Main usage type
  • S405.MANDT == TIV36.MANDT
  • S405.SUNUTZA == TIV36.SUNART
Business Entity Number
  • Company Code
  • Business Entity Number
Business Entity Number
  • Company Code
  • Business Entity Number
User field: Unit for value fields
  • S405.MANDT == TCURC.MANDT
  • S405.USRCUKY1 == TCURC.WAERS
User field: Unit for value fields
  • S405.MANDT == TCURC.MANDT
  • S405.USRCUKY2 == TCURC.WAERS
User field: Unit for quantity fields
  • S405.MANDT == T006.MANDT
  • S405.USRUNIT1 == T006.MSEHI
User field: Unit for quantity fields
  • S405.MANDT == T006.MANDT
  • S405.USRUNIT2 == T006.MSEHI
Currency Key
  • S405.MANDT == TCURC.MANDT
  • S405.WAERS == TCURC.WAERS