S405 - Building

Building information is stored in SAP table S405.
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 S405

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_02	Business Area	X	GSBER	CHAR	8	TGSB
SWENR_03	Business Entity Number	X	SWENR	CHAR	16	VIOB01
SGENR_04	Building Number	X	SGENR	CHAR	16	VIOB03
BUKRS	Company Code		BUKRS	CHAR	8	T001
GSBER	Business Area		GSBER	CHAR	8	TGSB
SWENR	Business Entity Number		SWENR	CHAR	16	VIOB01
SGENR	Building Number		SGENR	CHAR	16	VIOB03
PERIV	Fiscal Year Variant		PERIV	CHAR	4	T009
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
WAERS	Currency Key		WAERS	CUKY	10	TCURC
FEINS	Area Unit		FEINS	UNIT	6	T006
REINS	Unit for cubic volume		REINS	UNIT	6	T006
XORT	Address: City		VVXORT	CHAR	70
XPLZ	Address: Postal code		VVXPLZ	CHAR	20
XSTRASSE	Address: Street/house number		VVXSTRASSE	CHAR	70
ANZGE	No. of buildings		VVAGE	DEC	4
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
FQMFLART	Area of area type		VVBFLART	QUAN	8
DSFLART	Area: effective from		VVDSFLART	DATS	16
SFLART	Area type		SFLART	NUMC	8	TIV08
KOSTL	Cost Center		KOSTL	CHAR	20
ADRNR	Object number (virtual object)		SOBJNR	NUMC	20
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
PRCTR	Profit Center		PRCTR	CHAR	20
STTXT_EXT	Status: Set by user		VVXSTXTEXT	CHAR	80
STTXT_INT	Status: Set by system		VVXSTTXTIN	CHAR	80
DVERKAUF	Date: Sale		VVDVERKAU2	DATS	16
DVRKPLAN	Date: Planned sale		VVDVRKPLA2	DATS	16
XUNART	Main usage type		VVXUNART	CHAR	70
SUNUTZA	Main usage type		VVSUNART	CHAR	16	TIV36
RGEBART	Type of building		RGEBART	NUMC	4	TIV5A
XGEBART	Building: Building type		VVXGEBART	CHAR	100
JERBBAU	Heritable building right indicator		JERBBAU	CHAR	2
RGEBZUST	General condition of building		RGEBZUST	NUMC	4	TIV83
XGEBZUST	Condition: general condition		VVXGEBZUST	CHAR	100
YBAUJAHR	Year: construction year		VVYBAUJAH2	DATS	16
YMODERN	Year: modernization		VVYMODERN2	DATS	16
YAUFBAU	Year: reconstruction		VVYAUFBAU2	DATS	16
DBAUBEGI	Date: building start		VVDBAUBEGI	DATS	16
BBAUW13	Value: Building value 1913		VVBBAUW13	CURR	8
BBAUWAKT	Value: current building value		VVBBAUWAKT	CURR	8
BBETRIEB	Value: facilities		VVBBETRIE2	CURR	8
BAUSSEN	Value: Grounds		VVBAUSSEN	CURR	8
BSCHADEN	Value: Structural damage		VVBSCHADEN	CURR	8
BREPSTAU	Value: Repair backlog		VVBREPSTAU	CURR	8
BDMCBMRA	Amount per volume unit		BDMCBMRA	CURR	6
DBAUGENE	Building permit: date		VVDBAUGENE	DATS	16
XBAUGENE	Building permit: note		VVXBAUGENE	CHAR	60
DBEZUGSF	Date: Ready for occupancy		VVDBEZUGSF	DATS	16
DFERTIG	Date: Completion		VVDFERTIG	DATS	16
DSCHLUSS	Date: final inspection		VVDSCHLUS2	DATS	16
FDACHFL	Attic space		FDACHFL	DEC	5
RDAZUST	Condition of roof		RDAZUST	NUMC	4	TIV83
XDAZUST	Condition: roof		VVXDAZUST	CHAR	60
RFAZUST	Condition of facade		RFAZUST	NUMC	4	TIV83
XFAZUST	Condition: facade		VVXFAZUST	CHAR	60
BUBRA	Cubic Volume		BUBRA12	DEC	8
JDENKMAL	Protection of Historical Sites		JDENKMAL	CHAR	2
AUGESCH	Number of basements		AUGESCH	DEC	2
DAKTBEST	Date active in portfolio		DAKTBEST	DATS	16
DBAUVOR	Date: Planning inquiry		VVDBAUVOR	DATS	16
DVORBES	Date: prior notice		VVDVORBES	DATS	16
DANTBAU	Date: Building permit application		VVDANTBAU	DATS	16
SGRUNDB	Land register number		SGRUNDB	NUMC	16	VIGBUCH
XGBVON	Land register district		XGBVON	CHAR	50
XGETXT	Building text		XGETXT	CHAR	120
BEINHEITW	Assessed value: value		VVBEINHW2	CURR	8
NEINHEITW	Assessed value: base year		VVNEINHW	NUMC	8
BVERSWRT	Insurable value: amount		VVBVERSWRT	CURR	8
RVERSWRT	Type of insurance value		RVERSWRT	NUMC	2
XVERSWRT	Insurance value type		VVXVERSWRT	CHAR	50
SMIETSP	Representative list of rents assignment		SMIETSP	CHAR	12	TIV20
XMIETSP	Representative list of rents: allocation		VVXMIETSP	CHAR	30
SLAGK	Location class		SLAGK	NUMC	4	TIV22
XLAGK	Representative list of rents: locat.class		VVXLAGK	CHAR	60
RFAKT	Conversion factor for fractional share of property		VVXFAKT	CHAR	12
JNURJAHR	Indicator: Only regard construction date in terms of years		VVJNURJ	CHAR	2
DWIRTUB	Date: Transfer usage/charges		VVDWIRTUB2	DATS	16
PROFL	Settlement Profile		APROF	CHAR	12	TKB1A
DNUTZEND	Date: end of usage		VVDNUTZEN2	DATS	16
DFRDVON	Date: Public funding from		VVDFRDVON2	DATS	16
DFRDBIS	Date: Public funding to		VVDFRDBIS2	DATS	16
NSTCKLFT	Number of highest floor reached by elevator		VVNSTCKLF2	CHAR	6
BANZGE	Number of floors		VVBANZGE2	DEC	4
RPGENR	Building no. of hierarchical superior building part		VVRPGENR	CHAR	16	VIOB03
SMERKMA	Fixtures and Fittings Characteristics		SMERKMA	NUMC	6	TIV71
XMERKMA	Characteristic		VVXMERKMA	CHAR	60
ANLN1	Asset: main number		VVANLN1	CHAR	24	ANLH
ANLN2	Asset: Subnumber		VVANLN2	CHAR	8	ANLA
JANLHIE	Indicator: Asset allocation valid for subordin. building		VVJANLHIE	CHAR	2
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30
VVSAOGR	Group of object characteristics		VVSAOGR	NUMC	6
VVXAOGR	Group of object characteristics		VVXAOGR	CHAR	60
VVSAOB	Number of Object Characteristic		VVSAOB	NUMC	6
VVXAOB	Number of Object Characteristic		VVXAOB	CHAR	60
VVSAUSP	Number of object characteristic value		VVSAUSP	NUMC	6
VVXAUSP	Number of object characteristic value		VVXAUSP	CHAR	60
BERGRP	Authorization group		VVBERGRP	CHAR	80
GEMEINDE	Municipality key		VVGEMEINDE	CHAR	16
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
.INCLUDE				VIOB03_LIS	0
DUMMYFIELD	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE				CI_VIOB03_LIS	0