S404 - Properties

Properties information is stored in SAP table S404.
It is part of development package FVVI in software component RE. This development package consists of objects that can be grouped under "R/3 appl.dev. for Financial Assets Management: Real estate".

Fields for table S404

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
BUKRS_01	Company Code	X	BUKRS	CHAR	8	T001
GSBER_01	Business Area	X	GSBER	CHAR	8	TGSB
SWENR_02	Business Entity Number	X	SWENR	CHAR	16	VIOB01
SGRNR_03	Land Number for BE	X	SGRNR	CHAR	16	VIOB02
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
USRUNIT1	User field: Unit for quantity fields		USRUNIT	UNIT	6	T006
USRUNIT2	User field: Unit for quantity fields		USRUNIT	UNIT	6	T006
USRCUKY1	User field: Unit for value fields		USRCUKY	CUKY	10	TCURC
USRCUKY2	User field: Unit for value fields		USRCUKY	CUKY	10	TCURC
FEINS	Area Unit		FEINS	UNIT	6	T006
XORT	Address: City		VVXORT	CHAR	70
XPLZ	Address: Postal code		VVXPLZ	CHAR	20
XSTRASSE	Address: Street/house number		VVXSTRASSE	CHAR	70
XNUTZGRU	Current usage of property		XNUTZGRU	CHAR	60
ANZGR	No. of properties		VVAGR	DEC	4
RBEPLAN	Development plan: Description		VVRBEPLAN	CHAR	60
USR02	User-defined field 1 for 10 characters		USRCHAR101	CHAR	20
USR03	User-defined field 2 for 10 characters		USRCHAR102	CHAR	20
USR00	User-defined field 1 for 20 characters		USRCHAR201	CHAR	40
USR01	User field 2 for 20 characters		USRCHAR202	CHAR	40
USR08	User field 1 for date		USRDATE1	DATS	16
USR09	User field 2 for date		USRDATE2	DATS	16
USR10	User field 1 indicator for evaluations		USRFLAG1	CHAR	2
USR11	User field 2 indicator for evaluations		USRFLAG2	CHAR	2
USR04	User Field 1 for Set (Length 12,3)		USRQUAN151	QUAN	8
USR05	User Field 2 for Set (Length 12,3)		USRQUAN152	QUAN	8
USR06	User field 1 for values (length 10.3)		USRCURR131	CURR	7
USR07	User field 2 for values (length 10.3)		USRCURR132	CURR	7
BDNRWERT	Land reference value: Market value determination		VVBDNRWERT	CURR	6
BDNWERT	Land Value: Market Value Determination		VVBDNWERT_2	CURR	8
BUKRS	Company Code		BUKRS	CHAR	8	T001
DBDNWERT	Land value: date		VVDBDNWERT	DATS	16
RFAKT	Conversion factor for fractional share of property		VVXFAKT	CHAR	12
FQMFLART	Area of area type		VVBFLART	QUAN	8
DSFLART	Area: effective from		VVDSFLART	DATS	16
SFLART	Area type		SFLART	NUMC	8	TIV08
SGRFRM	Property ground type		VVSGRFRM	NUMC	6	TIV58
XGRFRM	Property: Ground type		VVXGRFRM2	CHAR	40
SGRGZS	Overall condition of property		VVSGRGZS	NUMC	6	TIV59
XGRGZS	Property: Overall condition		VVXGRGZS2	CHAR	40
GSBER	Business Area		GSBER	CHAR	8	TGSB
XGBVON	Land register district		XGBVON	CHAR	50
SGRUNDB	Land register number		SGRUNDB	NUMC	16	VIGBUCH
SGRNR	Land Number for BE		SGRNR	CHAR	16	VIOB02
XGRART	Property: Type		VVXGRART2	CHAR	40
SGRART	Property type		VVSGRART	NUMC	8	TIV56
XGRTXT	Text for property		VVXGRTXT	CHAR	120
BDMQMB2	Land Price: Purchase Price		VVBDMQMB2_2	CURR	8
KOSTL	Cost Center		KOSTL	CHAR	20
XGRQAL	Property: Quality of location		VVXGRQAL2	CHAR	40
SGRQAL	Property: Quality of location		VVSGRQAL	NUMC	6	TIV57
RGRNART	Usage Type of Property According to Land Use Map		RGRNART	CHAR	4
XGRNART	Usage Type of Property According to Land Use Map		VVXGRNART	CHAR	80
ADRNR	Object number (virtual object)		SOBJNR	NUMC	20
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
DBEPLAN	Development plan: date		VVDBEPLAN	DATS	16
PRCTR	Profit Center		PRCTR	CHAR	20
STTXT_EXT	Status: Set by user		VVXSTXTEXT	CHAR	80
STTXT_INT	Status: Set by system		VVXSTTXTIN	CHAR	80
ONTBMZ	Actual usage: Construction Dimension No. (Total)		VVBNTBMZS	DEC	5
ONTGFZ	Actual usage: Amount of floor-area ratio (total)		VVBNTGFZS	DEC	5
ONTGRZ	Actual usage: Amount of floor area ratio (total)		VVBNTGRZS	DEC	5
DVERKAUF	Date: Sale		VVDVERKAU2	DATS	16
DVRKPLAN	Date: Planned sale		VVDVRKPLA2	DATS	16
BDMQMB1	Land price: market value		VVBDMQMB1	CURR	6
SWENR	Business Entity Number		SWENR	CHAR	16	VIOB01
ONZBMZ	Permitted usage: Construct.dimension no. (total)		VVBNZBMZS	DEC	5
ONZGFZ	Permitted usage: floor-area ratio (total)		VVBNZGFZS	DEC	5
ONZGRZ	Allowed Usage: Site Occupancy Index (Total)		VVBNZGRZS	DEC	5
DWIRTUB	Date: Transfer usage/charges		VVDWIRTUB2	DATS	16
XUNART	Main usage type		VVXUNART	CHAR	70
SUNUTZA	Main usage type		VVSUNART	CHAR	16	TIV36
ANLN1	Asset: main number		VVANLN1	CHAR	24
ANLN2	Asset: Subnumber		VVANLN2	CHAR	8
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30
BERGRP	Authorization group		VVBERGRP	CHAR	80
XGEMARK	Local Subdistrict		VVGEMARK	CHAR	24
NFLURNR	Number of Tract of Land in Land Register		NFLURNR	CHAR	12
XFLURST	Parcel of Land		XFLURST	CHAR	20
BRFLURST	Fractional Parcel of Land		VVBRFLURST	CHAR	8
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	2
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	16
MEINS	Base Unit of Measure		MEINS	UNIT	6
XGEMEINDE	Name of municipality		VVXGEMEINDE	CHAR	100
XKREIS	Name of district		VVXKREIS	CHAR	60
XREGIO	Name of federal state		VVXREGIO	CHAR	60
XERBBAU	Heritable building right		VVXERBBAU	CHAR	60
XLGEMARK	Explanation of sub-district		VVLGEMARK	CHAR	50
.INCLUDE				VIOB02_LIS	0
DUMMYFIELD	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE				CI_VIOB02_LIS	0
WAERS	Currency Key		WAERS	CUKY	10