S407 - Rental agreements

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

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
SMIVE_07	Lease-Out Number	X	SMIVE	CHAR	26
PERIV	Fiscal Year Variant		PERIV	CHAR	4	T009
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
USRUNIT	User field: Unit for quantity fields		USRUNIT	UNIT	6
USRCUKY	User field: Unit for value fields		USRCUKY	CUKY	10
WAERS	Currency Key		WAERS	CUKY	10	TCURC
FEINS	Area Unit		FEINS	UNIT	6	T006
DERSTDR	Date When the Lease-Out was First Printed		VVDERSTDR	DATS	16
PROFL	Settlement profile for costs		VVAPROF	CHAR	12	TKB1A
ABNNR	Settlement firm: number		VVABNNR	CHAR	40
STECHEM	Settlement firm: Evaluation group		VVSTECHEM	CHAR	26
ABNUNR	Settlement company: subnumber		VVABNUNR	NUMC	6
XNNPARTABW	Alternative payer: surname		VVNNPARTBA	CHAR	40
XPARTNRABW	Alternative payer: name		VVXPARTNRA	CHAR	70
XORT	Address: City		VVXORT	CHAR	70
XPLZ	Address: Postal code		VVXPLZ	CHAR	20
XSTRASSE	Address: Street/house number		VVXSTRASSE	CHAR	70
ANKUEN	Notification until (for renewal of contract)		ANKUEN	NUMC	4
XMVANART	Lease-out primary adjustment type		VVXMVANPPR	CHAR	30
XMVANART44	Lease-Out Secondary Adjustment Type		VVXMVANART	CHAR	30
DASPVON	Adjustment block as from		VVDASPVON	DATS	16
DASPBIS	Adjustment block until		VVDASPBIS	DATS	16
ANZMV	No. of lease-outs		VVAMV	DEC	4
AZIMM	Number of rooms		VVAZIMM	DEC	4
AHALBZI	Number of half rooms		VVAHALBZI	DEC	4
SKUEFR	Type of notice period		SKUEFR	NUMC	2
SAUSTKL	Fixtures and fittings category		SAUSKL	NUMC	4	TIV23
BANKKS	Bank Keys		BANKK	CHAR	30
DBKERH	Cash deposit received on		VVDBKERH	DATS	16
MEINS	Base Unit of Measure		MEINS	UNIT	6	T006
XBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)		VVSBELEGN2	CHAR	60
SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)		VVSBELEGNG	CHAR	2
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
USRUNIT1	User field: Unit for quantity fields		USRUNIT	UNIT	6	T006
USRCUKY2	User field: Unit for value fields		USRCUKY	CUKY	10	TCURC
USRCUKY1	User field: Unit for value fields		USRCUKY	CUKY	10	TCURC
USRUNIT2	User field: Unit for quantity fields		USRUNIT	UNIT	6	T006
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
JBETRST	Security deposit granted		JBETRST	CHAR	2
BKONDQM	Currency amount per area unit		BKONDQM	CURR	7
FBEZUG	Reference area for calculation of amounts per area unit		VVFBEZUG	QUAN	8
BUKRS	Company Code		BUKRS	CHAR	8	T001
DERZAHL	Date: 1st debit position		VVDERZA	DATS	16
DAKTV	Date: Activation		VVDAKTV	DATS	16
DAUSZG	Date: Move-out		VVDAUSZG2	DATS	16
DEINZG	Date: Move-in		VVDEINZG2	DATS	16
DKUEZU	Date: Notice		VVDKUZU2	DATS	16
DMIBEG	Date: Start of rent		VVDMIBE	DATS	16
DMIEND	Date: rental end		VVDMIEN	DATS	16
DUNTBIS	Date: Provisional agreement from		VVDUNBI	DATS	16
BABRE	Settlement units		VVBABRE	QUAN	8
PERHOE	Percentage rate increase		VVPERHOE	DEC	6
FKONDFLA	Area for condition type		VVFKONDFLA	QUAN	8
SGENR	Building Number		SGENR	CHAR	16	VIOB03
XGEBT	Building: part		VVXGEBT	CHAR	30
SGEBT	Part of Building		SGEBT	CHAR	4	TIV12
GERSTD	Jurisdiction		VVXGERSTD	CHAR	70
SSTOCKW	Floor		VVSSTOCKW	NUMC	6	TIV37
XSTOCKW	Floor (text)		VVXSTOCKW	CHAR	30
GSBER	Business Area		GSBER	CHAR	8	TGSB
XASPGRD	Reason for adjustment block (text)		VVXASPGRD	CHAR	60
XMANSP	Dunning block reason		VVXMANSP	CHAR	60
SASPGRD	Reason for adjustment block		VVSASPGRD	NUMC	4	TIV14
SGRNR	Land Number for BE		SGRNR	CHAR	16	VIOB02
KUNNR	Main tenant: Customer number		VVRDEBIHV2	CHAR	20	KNA1
XNNPART	Master tenant: last name		VVNNPARTB	CHAR	40
XPARTNR	Master tenant: name		VVXPARTNR	CHAR	70
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	26
DKAUFOPT	Purchase option: date		VVDKAUFOPT	DATS	16
JKAUFOPT	Purchase option: indicator		VVJKAUFOPT	CHAR	2
BKAUTION	Deposit: amount		VVBKAUTART	CURR	7
JMFREI	Condition is not checked		VVJMFREI	CHAR	2
DGULTAB	Condition: effective from		VVDKOND	DATS	16
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	TZK01
BKOND	Condition item currency amount		BKONDS407	CURR	8
KOSTL	Cost center: name		VVXKOSTL	CHAR	20
DATAB	Cost center: effective from_		VVDKOSTL	DATS	16
XKUEFR	Type of notice period		VVXKUEFR	CHAR	60
DKUEFR	Notice period: months		VVAKUEFR2	DEC	4
XLGESCH	Location in floor (text)		VVXLGESCH	CHAR	30
RLGESCH	Location on Floor		RLGESCH	CHAR	4	TIV38
SLAGK	Location class		SLAGK	NUMC	4	TIV22
MANSP	Dunning: Blocking reason		VVMANSP	CHAR	2	T040S
JMAHNMSP	Dunning: Block indicator		VVJMANSP	CHAR	2
MABER	Dunning: area		VVMABER	CHAR	4
MADAT	Date of last dunning letter		VVDMADAT	DATS	16
MANST	Dunning: level		VVMAHNS	NUMC	2
BMWST	Value-added tax amount included		BMWST	CURR	7
AMELDIN	Sales reporting interval		AMELDIN	NUMC	4
SMENR	Number of Rental Unit		SMENR	CHAR	16	VIMI01
XMBEZ	Reason for rent reduction		VVMMXMBEZ	CHAR	60
SKAUTART	Type of Rental Collateral		SKAUA	CHAR	2	TIV18
XKAUTART	Deposit: type		VVXKAUTART	CHAR	30
XAUSTKL	Represent. list of rents: Fixture/fitting category		VVXXAUSTKL	CHAR	30
XLAGK	Representative list of rents: locat.class		VVXLAGK	CHAR	60
XMIETSP	Representative list of rents: allocation		VVXMIETSP	CHAR	30
SMIETSP	Representative list of rents assignment		SMIETSP	CHAR	12	TIV20
SMIVE	Lease-Out Number		SMIVE	CHAR	26
XMVART	Lease out: Type		VVXMVART	CHAR	30
FLG_MITARB	Employee indicator		VVSMITARB2	CHAR	2
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
SPARTNR	Partner number		VVSPARTNR	CHAR	44
SMVANART	Rental agreement primary adjustment type		SMVAR04	CHAR	2	TIV27
PRCTR	Profit Center		PRCTR	CHAR	20
JBKRZ	Cash deposit instalment payment		VVJBKRZ	CHAR	2
REINS	Unit for cubic volume		REINS	UNIT	6	T006
JRMSCHPR	Tenant service charge settlement?		VVJRMSCHPR	CHAR	2
DGABANRT44	Secondary adjustment type valid from		VVDGABANR2	DATS	16
DBISANRT44	Secondary adjustment type valid until		VVDBISANR2	DATS	16
SMVANART44	Rental agreement secondary adjustment type		SMVAR44	CHAR	2	TIV27
SICHGEB	Guarantor		VVXSICHGEB	CHAR	60
JSKUEND	Special right of notice		JSKUEND	CHAR	2
STTXT_EXT	Status: Set by user		VVXSTXTEXT	CHAR	80
STTXT_INT	Status: Set by system		VVXSTTXTIN	CHAR	80
DGAB	Date when the apportionment factor becomes valid		VVDUMLGA	DATS	16
SABRG	Apportionment unit		SABRG	NUMC	8	TIV07
PPROZ0	Sales: minimum percentage		VVPPROZ0	DEC	3
BMINUMS	Sales: minimum		VVBUMSATZ1	CURR	7
BUMSPROJ	Sales: plan		VVBUMSPROJ	CURR	7
DVMUN	Contract signed by landlord		VVDVMUN	DATS	16
VERLG	Contract renewal by ... months		VERLG	NUMC	6
SMVART	External Real Estate Contract Type		SMVART	CHAR	8	TIV26
JVERL	Contract renewal		JVERL	CHAR	2
SWENR	Business Entity Number		SWENR	CHAR	16	VIOB01
XGZLSCH	Payment method for credit memos		VVXGZLSCH	CHAR	60
XZLSCH	Payment method		VVXZLSCH	CHAR	60
GZLSCH	Payment method for credit memos		VVGZLSCH	CHAR	2
PZUABSP	Surcharge or reduction for representative list of rents		VVPZUABSP	DEC	6
PROZTEIL	Subsidy percentage rate		VVPZUSP	DEC	3
DGUELTAB	Date as from when subsidy valid		VVDZUSPAB	DATS	16
DGUELBIS	Date up to when subsidy valid		VVDZUSPBIS	DATS	16
DFAELL	Subsidy due date		VVDZUSPFAE	DATS	16
BZUBETR	Subsidy/allowance amount		VVZUBETR	CURR	7
BMAXBETR	Subsidy/grant maximum amount		VVMAXBETR	CURR	7
XZUSPKUNNR	Subsidizer		VVXZUSPPRT	CHAR	70
SPARTNRABW	Alternative payer (partner number)		VVRPARTABW	CHAR	20
DAENDDR	Date When the Lease-Out was Changed and Printed Out		VVDAENDDR	DATS	16
DMIENKUE	End Date of Lease-Out		VVDMIENKUE	DATS	16
E_SMIVE	Contract No. of Collective Lease-Outs		VVESMIVE	CHAR	26
IND_SECTOR	Industry of master tenant		VVMVINDSEC	CHAR	8
XIND_SECT	Industry of master tenant		VVXMVINDSE	CHAR	40
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4
JVSTOPT	Input tax opting (indicator)		VVJVSTOPT	CHAR	2
SVSTSOND	Input tax opting reason		SVSTSOND	CHAR	2
XVSTSOND	Input tax opting reason		XVSTSOND	CHAR	40
SKUEKEY	Notice rule		SKUEKEY	CHAR	24
SKUEART	Notice Type of Lease-Out		SMVKUEART	CHAR	2
XKUEART	Notice Type of Lease-Out		VVXMVKUEAR	CHAR	40
HBKID	Short Key for a House Bank		HBKID	CHAR	10
FEHLBEL	Reference code false occupancy charges		VVFEHLBEL	CHAR	40
R1DATUM	1st date for vacating		VVR1DATUM	DATS	16
R2DATUM	2nd date for vacating		VVR2DATUM	DATS	16
KLDATUM	Date of complaint		VVKLDATUM	DATS	16
KLAKTZEI	Complaint reference code		VVKLAKTZEI	CHAR	40
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30
DFLOWFIX	Flows fixed upto		VVDFLOWFIX	DATS	16
KONTOBV	Bank procedure account number		VVIKONTOBV	CHAR	20
GZLSCH_DEB	Payment methods for customer credit memos		REGZWELSDEB	CHAR	20
DGUELAB	Date when the rent adjustment becomes valid		DGUELAB	DATS	16
XSTANDNR	Number of garage / parking space		VVXSTANDNR	CHAR	10
OSMIVE	Number of old contract		VVOSMIVE	CHAR	40
SDUNMOD	Dunning level for dunning of non-approved rent adjustments		VVRAMAHNVERF	CHAR	8
SKOTYP	Condition category		SKOTYP	NUMC	6
.INCLUDE				VIMIMV_LIS	0
DUMMYFIELD	Single-Character Flag		CHAR1	CHAR	2
.INCLUDE				CI_VIMIMV_LIS	0
SNUNR	Rental unit external usage type		SNUNR	NUMC	8
XNUNR	Rental unit usage type (text)		VVXNUNR	CHAR	60