S404

Properties | #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_01 FK Business Area
SWENR_02 FK Business Entity Number
SGRNR_03 FK Land Number for BE
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):
BDNRWERT Land reference value: Market value determination
BDNWERT Land Value: Market Value Determination
BDMQMB2 Land Price: Purchase Price
BDMQMB1 Land price: market value
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
📏 Base Unit of Measure (MEINS):
ZULBAUH Permitted building height
Column Name Description
SPTAG Period to analyze - current date
USR08 User field 1 for date
USR09 User field 2 for date
DBDNWERT Land value: date
DSFLART Area: effective from
DBEPLAN Development plan: date
DVERKAUF Date: Sale
DVRKPLAN Date: Planned sale
DWIRTUB Date: Transfer usage/charges
Column Name Description
USR10 User field 1 indicator for evaluations Show values
USR11 User field 2 indicator for evaluations Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
XORT Address: City TEXT35
XPLZ Address: Postal code PSTLZ
XSTRASSE Address: Street/house number TEXT35
XNUTZGRU Current usage of property XMBEZ
ANZGR No. of properties DEC6
RBEPLAN Development plan: Description XMBEZ
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
RFAKT Conversion factor for fractional share of property CHAR6
XGRFRM Property: Ground type VVXTEXT20
XGRGZS Property: Overall condition VVXTEXT20
XGBVON Land register district XTEXT25
XGRART Property: Type VVXTEXT20
XGRTXT Text for property XLBEZ
KOSTL Cost Center KOSTL
XGRQAL Property: Quality of location VVXTEXT20
RGRNART Usage Type of Property According to Land Use Map CHAR2
XGRNART Usage Type of Property According to Land Use Map TEXT40
ADRNR Object number (virtual object) SOBJNR
PRCTR Profit Center PRCTR
STTXT_EXT Status: Set by user CHAR40
STTXT_INT Status: Set by system CHAR40
ONTBMZ Actual usage: Construction Dimension No. (Total) DEC6_2
ONTGFZ Actual usage: Amount of floor-area ratio (total) DEC6_2
ONTGRZ Actual usage: Amount of floor area ratio (total) DEC6_2
ONZBMZ Permitted usage: Construct.dimension no. (total) DEC6_2
ONZGFZ Permitted usage: floor-area ratio (total) DEC6_2
ONZGRZ Allowed Usage: Site Occupancy Index (Total) DEC6_2
XUNART Main usage type XTEXT35
ANLN1 Asset: main number ANLN1
ANLN2 Asset: Subnumber ANLN2
TXJCD Tax Jurisdiction TXJCD
BERGRP Authorization group VVBERGRP
XGEMARK Local Subdistrict VVGEMARK
NFLURNR Number of Tract of Land in Land Register NFLURNR
XFLURST Parcel of Land TEXT10
BRFLURST Fractional Parcel of Land VVBRFLURST
JERBBAU Heritable building right indicator SOBJERBBAU
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
XLGEMARK Explanation of sub-district VVLGEMARK
DUMMYFIELD Single-Character Flag CHAR1
Master Data Relations Join Conditions
Company Code
  • S404.MANDT == T001.MANDT
  • S404.BUKRS == T001.BUKRS
Company code
  • S404.MANDT == T001.MANDT
  • S404.BUKRS_01 == T001.BUKRS
Area Unit
  • S404.MANDT == T006.MANDT
  • S404.FEINS == T006.MSEHI
Business Area
  • S404.MANDT == TGSB.MANDT
  • S404.GSBER == TGSB.GSBER
Business Area
  • S404.MANDT == TGSB.MANDT
  • S404.GSBER_01 == TGSB.GSBER
Client S404.MANDT == T000.MANDT
Area type
  • S404.MANDT == TIV08.MANDT
  • S404.SFLART == TIV08.SFLART
Property type
  • S404.MANDT == TIV56.MANDT
  • S404.SGRART == TIV56.SGRART
Property ground type
  • S404.MANDT == TIV58.MANDT
  • S404.SGRFRM == TIV58.SGRFRM
Overall condition of property
  • S404.MANDT == TIV59.MANDT
  • S404.SGRGZS == TIV59.SGRGZS
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
Land Number for BE
  • Company Code
  • Land Number for BE
  • Client
  • Business Entity Number
Property: Quality of location
  • S404.MANDT == TIV57.MANDT
  • S404.SGRQAL == TIV57.SGRQAL
Land register number
  • Land register number
  • Client
Main usage type
  • S404.MANDT == TIV36.MANDT
  • S404.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
  • S404.MANDT == TCURC.MANDT
  • S404.USRCUKY1 == TCURC.WAERS
User field: Unit for value fields
  • S404.MANDT == TCURC.MANDT
  • S404.USRCUKY2 == TCURC.WAERS
User field: Unit for quantity fields
  • S404.MANDT == T006.MANDT
  • S404.USRUNIT1 == T006.MSEHI
User field: Unit for quantity fields
  • S404.MANDT == T006.MANDT
  • S404.USRUNIT2 == T006.MSEHI