S408

Land registers | #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
SGRUNDB_01 FK Land register number
Column Name Description
πŸ’² Currency Key (WAERS):
BDARLEH Total amount of right registered in Section III
BAENLOE Change or deletion amount
BEFFECT Effective loan amount
BWRTMIN Net present value of law
BNOMIN Nominal loan amount
Column Name Description
πŸ“ Area Unit (FEINS):
FLAECHE Area of area type
Column Name Description
SPTAG Period to analyze - current date
DAUFLASS Date of conveyance
DBAUFL Date of approval of conveyance
DBEINTR Date of approval of entry
DBVORM Date of approval of priority notice
DATZUAB Date of entry/removal from land register
DEINTRAG Date of entry
DAENDER Change /deletion date
DAUSZGV Date: Land register extract from
DLOESCH Deletion date
DAUFLVOR Date of priority notice of conveyance
Column Name Description
JEIGENR Individual right indicator Show values
JKZLOE Indicator: Land register entry is marked as being deleted Show values
JREVAL Indicator: Revaluation permitted Show values
JZUAB Value appreciation indicator Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
XNRA3 Section 3, number of entry VVXNRGB
XORT Address: City TEXT35
XPLZ Address: Postal code PSTLZ
XSTRASSE Address: Street/house number TEXT35
RGBA2LB Type of charges and restrictions for land register type VVRGBA2LB
NBANDNR Land register volume number TEXT15
XRBELAST Type of encumbrance in section 3 of land register TEXT15
XZUATEXT Text for entry//removal from land register TEXT60
XEINTXT Charges + restrictions in Section 2 of land register TEXT60
NBLATTNR Land register page number TEXT15
SNRABT1 No. of entry in section 1 of land register NRABT1
SNRABT2 Number of entry in section 2 of land register NRABT2
SNRABT3 No. of entry in Section 3 of land register NRABT3
RFAKT Conversion factor for fractional share of property CHAR6
NFLURNR Number of Tract of Land in Land Register NFLURNR
XFLURST Parcel of Land TEXT10
XGEMARK Local subdistrict ID XTEXT12
XGLAUB Creditor XTEXT25
XGBVON Land register district XTEXT25
XPARTNR Land register: name CHAR35
XGBAMT Land registry ID XTEXT25
XGRBA Type of land register TEXT50
XEIGTLST Basis of entry TEXT60
ZGRUSCH Land charge interest rate DEC3_7
SLFDGRST Property consecutive number NEINTRAG
NALTGRST Previous number of property XTEXT7
RGRSTLST Reference to relational table properties RGRSTLST
XCOMMNT Comment about lot TEXT60
XGSLAGE Description of property location TEXT60
NLSBUCHN Real properties register number NLSBUCHN
REIGTLST Reference to relational data base table of owner REIGTLST
XGRSTLST List of properties for an entry XTEXT18
ZNEBENL Additional service interest rate DEC3_7
SNRFLST Consecutive no. of a lot on a property VVSNRFLST
SNRZUAB Number of appreciation/depreciation NEINTRAG
SNRABT2A Changes section 2 of land register, no. of entry NEINTRAG
SNRABT3A No. of change/deletion in section 3 of land register NEINTRAG
XRNA2A No. of change in section II VVXNRGB
XNRA1 Section 1, number of entry VVXNRGB
NRDARLEH Loan number NRDARLEH
XNRA3A No of change in sect. III VVXNRGB
XNRBSTD Number in property list VVXNRGB
NRANG Rank in section 3 of land register NRANG
XAEND Text for change or deletion TEXT60
XBELAST Text about charge TEXT60
PWRTMIN Percentage decrease in value DEC03_2
XWIRTART Business type TEXT60
NZUGRST Entry for property VVXNRGB
ANZGB No. of land registers DEC5
BUKRS Company Code BUKRS
SWENR Business Entity Number SWENR
SGRNR Land Number for BE SGRNR
Master Data Relations Join Conditions
Area Unit
  • S408.MANDT == T006.MANDT
  • S408.FEINS == T006.MSEHI
Area Unit
  • S408.MANDT == T006.MANDT
  • S408.FEINS_01 == T006.MSEHI
Client S408.MANDT == T000.MANDT
Business Partner Number
  • S408.MANDT == BP000.MANDT
  • S408.PARTNR == BP000.PARTNR
Type of encumbrance in section 3 of land register
  • S408.MANDT == TIV02.MANDT
  • S408.RBELAST == TIV02.SBELAST
Land register type
  • S408.MANDT == TDO6.MANDT
  • S408.SGRBA == TDO6.SGRBA
Land register number
  • Land register number
  • Client
Land register number
  • Land register number
  • Client
Currency Key
  • S408.MANDT == TCURC.MANDT
  • S408.WAERS == TCURC.WAERS