S406 - Rental units

Rental units information is stored in SAP table S406.
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 S406

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
SGRNR_04	Land Number for BE	X	SGRNR	CHAR	16	VIOB02
SGENR_05	Building Number	X	SGENR	CHAR	16	VIOB03
SMENR_06	Number of Rental Unit	X	SMENR	CHAR	16	VIMI01
BUKRS	Company Code		BUKRS	CHAR	8	T001
GSBER	Business Area		GSBER	CHAR	8	TGSB
SWENR	Business Entity Number		SWENR	CHAR	16	VIOB01
SGRNR	Land Number for BE		SGRNR	CHAR	16	VIOB02
SGENR	Building: number		VVSGENR	CHAR	16	VIOB03
SMENR	Rental unit: number		VVSMENR	CHAR	16	VIMI01
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
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
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
ANZME	Number of rental units		VVAME	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
FBEZUG	Reference area for calculation of amounts per area unit		VVFBEZUG	QUAN	8
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: name		VVXKOSTL	CHAR	20
DATAB	Cost center: effective from_		VVDKOSTL	DATS	16
ADRNR	Object number (virtual object)		SOBJNR	NUMC	20
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
PRCTR	Profit Center		PRCTR	CHAR	20
STTXT_EXT	Status: Set by user		VVXSTXTEXT	CHAR	80
STTXT_INT	Status: Set by system		VVXSTTXTIN	CHAR	80
XMETXT	Text for rental unit		VVXMETXT	CHAR	60
SKOART	Condition: Type		VVSKOART	NUMC	8	TZK01
BKOND	Condition: amount		VVBKOND	CURR	7
DGULTAB	Condition: effective from		VVDKOND	DATS	16
SNUNR	Rental unit external usage type		SNUNR	NUMC	8	TIV01
XNUNR	Rental unit usage type (text)		VVXNUNR	CHAR	60
SALTNR	Number of rental unit in existing real estate system		SALTNR	CHAR	40
SRAART	Room type		SRAART	NUMC	4	TIV09
BRAART	Number of rooms		VVBRAARTA	DEC	7
SMERKMA	Fixtures and Fittings Characteristics		SMERKMA	NUMC	6	TIV71
XMERKMA	Characteristic		VVXMERKMA	CHAR	60
SSTOCKW	Floor		VVSSTOCKW	NUMC	6	TIV37
XSTOCKK	Floor (short text)		VVXSTOCKK2	CHAR	8
XSTOCKW	Floor (text)		VVXSTOCKW	CHAR	30
RLGESCH	Location on Floor		RLGESCH	CHAR	4	TIV38
XLGESCH	Location in floor (text)		VVXLGESCH	CHAR	30
DBEZU	Date: First usage		VVDBEZU	DATS	16
SABRG	Apportionment unit: type		VVSABRG2	NUMC	8	TIV07
DGAB	Apportionment unit: effective from		VVDGAB2	DATS	16
BABRE	Apportionment units		VVBUMLEINH	QUAN	4
TXT04	Occupancy type: short text		VVXJ_TXT04	CHAR	8
TXT30	Occupancy type (text)		VVXJ_TXT30	CHAR	60
BELEAB	Occupancy type: effet.from		VVDBELEAB	DATS	16
BELEBIS	Occupancy type: eff. to		VVDBELEBIS	DATS	16
DBEGEH	Last access: date		VVDBEGEH	DATS	16
XBEGEH	Last inspection: by		VVXBEGEH	CHAR	30
PERHOE	Increase: percentage		VVPERHOE2	DEC	6
RPROZGRD	Increase: Reason for difference		VVRPROZGRD	CHAR	4	TIV43
XPROZGRD	Increase: Reason for difference		VVXPROZGRD	CHAR	30
SMOEBL	Furniture indicator		SMOEB	CHAR	2
AZIMM	Number of rooms		VVAZIMM	DEC	4
AHALBZI	Number of half rooms		VVAHALBZI	DEC	4
XSTANDNR	Number of garage / parking space		VVXSTANDNR	CHAR	10
JEIGWOHN	Rental Unit in Separate Ownership (COA)		VVJEIGWOHN	CHAR	2
ABNNR	Settlement firm: number		VVABNNR	CHAR	40
STECHEM	Settlement firm: Evaluation group		VVSTECHEM	CHAR	26
SSTCKBIS	For RUs with Multiple Floors: Top Floor of RU		VVSSTCKBIS	NUMC	6	TIV37
JVORSTEIG	Input tax deduction for vacancy		JVORSTEIG	CHAR	2
RFAKT	Conversion factor for fractional share of property		VVXFAKT	CHAR	12
JKONDMV	Cond.transfer RA: indicator		VVJKONDMV2	CHAR	2
PKONDMV	Cond.transfer LO: percent		VVPKONDMV2	DEC	3
DFSTRBIS	Date: Cash flow until		VVDFSTRBI2	DATS	16
JRMSCHPR	Tenant service charge settlement?		VVJRMSCHPR	CHAR	2
DHPZSAKT	CH rent adj.:Date of mort.loan rate status for current rent		VVDHPZSAK2	DATS	16
DUTBKAKT	CH rnt adj.:Dte maint./oper.costs index status for new rent		VVDUTBKAK2	DATS	16
DTEURAKT	CH rnt adj.:Dte of living stndrd index status for curr.rent		VVDTEURAK2	DATS	16
SMIETSP	Representative list of rents assignment		SMIETSP	CHAR	12	TIV20
XMIETSP	Representative list of rents: allocation		VVXMIETSP	CHAR	30
PZUABSP	Representative list of rents: surcharge/reduction		VVPZUABSP2	DEC	6
SLAGK	Location class		SLAGK	NUMC	4	TIV22
XLAGK	Representative list of rents: locat.class		VVXLAGK	CHAR	60
SAUSTKL	Fixtures and fittings category		SAUSKL	NUMC	4	TIV23
XAUSTKL	Represent. list of rents: Fixture/fitting category		VVXXAUSTKL	CHAR	30
DWTVERM	Date: Subsequent rental		DWTVERM	DATS	16
RBELBIND	Occupancy obligation key		RBELBIND	CHAR	8	TIV31
XBELBIND	Occupancy obligation: to		VVXBELBIND	CHAR	30
DBINDBIS	Occupancy obligation: until		VVDBINDBIS	DATS	16
SBWNR	Reservation application number of a rental unit		VVXBWNR	CHAR	14
SPARTNR	Partner number		SPARTNR	CHAR	20	SPRT1
XPARTNR	Name of applicant for a rental unit		VVXPARTNRB	CHAR	70
XNNPART	Last name of applicant		VVNNPART	CHAR	40
DRESAB	Date: Reserved from		DRESA	DATS	16
DRESBIS	Date: Reserved upto		DRESB	DATS	16
UMBRAUM	Cubic Volume		VVBUBRA	QUAN	6
SGEBT	Part of Building		SGEBT	CHAR	4	TIV12
XGEBT	Building: part		VVXGEBT	CHAR	30
SBASTEU	Swiss rent adj.: Base year for standard of living index		VVSBASTEU	NUMC	8
DRESTAUR	Date of reconstruction/extensive modernization		VVDRESTAUR	DATS	16
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30
BERGRP	Authorization group		VVBERGRP	CHAR	80
DFLOWFIX	Flows fixed upto		VVDFLOWFIX	DATS	16
KOEIGR	Account determination key for account determination		VVWERTN_AD	CHAR	20
SPOSINMSP	Base value for grouping RU in RLR group		VVSPOSINMSP	CHAR	2
PPOSINMSP	Percentage value for grouping RU in RLR category group		VVPPOSINMSP	DEC	3
DFRDVON	Public funding from		VVDFRDVON	DATS	16
DFRDBIS	Public funding to		VVDFRDBIS	DATS	16
BMMVALFE	Amount for each area unit for a fixtures & fittings charact.		VVBMMVALUFE	CURR	7
DMMGUELAB	Valid from date of a fixture and fitting characteristic		VVDMMGUELAB	DATS	16
SIHMA	Modernization Measure		VVSIHMA	CHAR	40
SKOTYP	Condition category		SKOTYP	NUMC	6
SGRUNDB	Land register number		SGRUNDB	NUMC	16
XGBVON	Land register district		XGBVON	CHAR	50
PAUSFW	Service charge stt. apport.loss risk percentage surcharge		VVPAUSFW2	DEC	5
.INCLUDE				VIMI01_LIS	0
DUMMYFIELD	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE				CI_VIMI01_LIS	0