VIRPS407 - Rental agreements

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

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	3	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	4
VRSIO	Version number in the information structure	X	VRSIO	CHAR	3	*
SPMON	Period to analyze - month	X	SPMON	NUMC	6
SPTAG	Period to analyze - current date	X	SPTAG	DATS	8
SPWOC	Period to analyze - week	X	SPWOC	NUMC	6
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	6
BUKRS_01	Company Code	X	BUKRS	CHAR	4	T001
GSBER_02	Business Area	X	GSBER	CHAR	4	TGSB
SWENR_03	Business Entity Number	X	SWENR	CHAR	8	VIOB01
SGRNR_04	Land Number for BE	X	SGRNR	CHAR	8	VIOB02
SGENR_05	Building Number	X	SGENR	CHAR	8	VIOB03
SMENR_06	Number of Rental Unit	X	SMENR	CHAR	8	VIMI01
SMIVE_07	Lease-Out Number	X	SMIVE	CHAR	13
PERIV	Fiscal Year Variant		PERIV	CHAR	2	T009
VWDAT	Pointer to administrative data		VWDAT	NUMC	10
USRUNIT	User field: Unit for quantity fields		USRUNIT	UNIT	3	*
USRCUKY	User field: Unit for value fields		USRCUKY	CUKY	5	*
WAERS	Currency Key		WAERS	CUKY	5	TCURC
FEINS	Area Unit		FEINS	UNIT	3	T006
DERSTDR	Date When the Lease-Out was First Printed		VVDERSTDR	DATS	8
PROFL	Settlement profile for costs		VVAPROF	CHAR	6	TKB1A
ABNNR	Settlement firm: number		VVABNNR	CHAR	20
STECHEM	Settlement firm: Evaluation group		VVSTECHEM	CHAR	13
ABNUNR	Settlement company: subnumber		VVABNUNR	NUMC	3
XNNPARTABW	Alternative payer: surname		VVNNPARTBA	CHAR	20
XPARTNRABW	Alternative payer: name		VVXPARTNRA	CHAR	35
XORT	Address: City		VVXORT	CHAR	35
XPLZ	Address: Postal code		VVXPLZ	CHAR	10
XSTRASSE	Address: Street/house number		VVXSTRASSE	CHAR	35
ANKUEN	Notification until (for renewal of contract)		ANKUEN	NUMC	2
XMVANART	Lease-out primary adjustment type		VVXMVANPPR	CHAR	15
XMVANART44	Lease-Out Secondary Adjustment Type		VVXMVANART	CHAR	15
DASPVON	Adjustment block as from		VVDASPVON	DATS	8
DASPBIS	Adjustment block until		VVDASPBIS	DATS	8
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	1
SAUSTKL	Fixtures and fittings category		SAUSKL	NUMC	2	TIV23
BANKKS	Bank Keys		BANKK	CHAR	15
DBKERH	Cash deposit received on		VVDBKERH	DATS	8
MEINS	Base Unit of Measure		MEINS	UNIT	3	T006
XBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)		VVSBELEGN2	CHAR	30
SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)		VVSBELEGNG	CHAR	1
USR02	User-defined field 1 for 10 characters		USRCHAR101	CHAR	10
USR03	User-defined field 2 for 10 characters		USRCHAR102	CHAR	10
USR00	User-defined field 1 for 20 characters		USRCHAR201	CHAR	20
USR01	User field 2 for 20 characters		USRCHAR202	CHAR	20
USR08	User field 1 for date		USRDATE1	DATS	8
USR09	User field 2 for date		USRDATE2	DATS	8
USRUNIT1	User field: Unit for quantity fields		USRUNIT	UNIT	3	T006
USRCUKY2	User field: Unit for value fields		USRCUKY	CUKY	5	TCURC
USRCUKY1	User field: Unit for value fields		USRCUKY	CUKY	5	TCURC
USRUNIT2	User field: Unit for quantity fields		USRUNIT	UNIT	3	T006
USR10	User field 1 indicator for evaluations		USRFLAG1	CHAR	1
USR11	User field 2 indicator for evaluations		USRFLAG2	CHAR	1
USR04	User field 1 for set (length 10,3)		USRQUAN131	QUAN	7
USR05	User field 2 for set (length 10.3)		USRQUAN132	QUAN	7
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	1
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	4	T001
DERZAHL	Date: 1st debit position		VVDERZA	DATS	8
DAKTV	Date: Activation		VVDAKTV	DATS	8
DAUSZG	Date: Move-out		VVDAUSZG2	DATS	8
DEINZG	Date: Move-in		VVDEINZG2	DATS	8
DKUEZU	Date: Notice		VVDKUZU2	DATS	8
DMIBEG	Date: Start of rent		VVDMIBE	DATS	8
DMIEND	Date: rental end		VVDMIEN	DATS	8
DUNTBIS	Date: Provisional agreement from		VVDUNBI	DATS	8
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	8	VIOB03
XGEBT	Building: part		VVXGEBT	CHAR	15
SGEBT	Part of Building		SGEBT	CHAR	2	TIV12
GERSTD	Jurisdiction		VVXGERSTD	CHAR	35
SSTOCKW	Floor		VVSSTOCKW	NUMC	3	TIV37
XSTOCKW	Floor (text)		VVXSTOCKW	CHAR	15
GSBER	Business Area		GSBER	CHAR	4	TGSB
XASPGRD	Reason for adjustment block (text)		VVXASPGRD	CHAR	30
XMANSP	Dunning block reason		VVXMANSP	CHAR	30
SASPGRD	Reason for adjustment block		VVSASPGRD	NUMC	2	TIV14
SGRNR	Land Number for BE		SGRNR	CHAR	8	VIOB02
KUNNR	Main tenant: Customer number		VVRDEBIHV2	CHAR	10	KNA1
XNNPART	Master tenant: last name		VVNNPARTB	CHAR	20
XPARTNR	Master tenant: name		VVXPARTNR	CHAR	35
INTRENO	Internal Real Estate Master Data Code		VVINTRENO	CHAR	13
DKAUFOPT	Purchase option: date		VVDKAUFOPT	DATS	8
JKAUFOPT	Purchase option: indicator		VVJKAUFOPT	CHAR	1
BKAUTION	Deposit: amount		VVBKAUTART	CURR	7
JMFREI	Condition is not checked		VVJMFREI	CHAR	1
DGULTAB	Condition: effective from		VVDKOND	DATS	8
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	4	TZK01
BKOND	Condition Item Currency Amount		BKOND	CURR	7
KOSTL	Cost center: name		VVXKOSTL	CHAR	10	*
DATAB	Cost center: effective from_		VVDKOSTL	DATS	8
XKUEFR	Type of notice period		VVXKUEFR	CHAR	30
DKUEFR	Notice period: months		VVAKUEFR2	DEC	4
XLGESCH	Location in floor (text)		VVXLGESCH	CHAR	15
RLGESCH	Location on Floor		RLGESCH	CHAR	2	TIV38
SLAGK	Location class		SLAGK	NUMC	2	TIV22
MANSP	Dunning Block		MANSP	CHAR	1	T040S
JMAHNMSP	Dunning block indicator - no longer used!		JMASP	CHAR	1
MABER	Dunning: area		VVMABER	CHAR	2	*
MADAT	Date of last dunning letter		VVDMADAT	DATS	8
MANST	Dunning: level		VVMAHNS	NUMC	1
BMWST	Value-added tax amount included		BMWST	CURR	7
AMELDIN	Sales reporting interval		AMELDIN	NUMC	2
SMENR	Number of Rental Unit		SMENR	CHAR	8	VIMI01
XMBEZ	Reason for rent reduction		VVMMXMBEZ	CHAR	30
SKAUTART	Type of Rental Collateral		SKAUA	CHAR	1	TIV18
XKAUTART	Deposit: type		VVXKAUTART	CHAR	15
XAUSTKL	Represent. list of rents: Fixture/fitting category		VVXXAUSTKL	CHAR	15
XLAGK	Representative list of rents: locat.class		VVXLAGK	CHAR	30
XMIETSP	Representative list of rents: allocation		VVXMIETSP	CHAR	15
SMIETSP	Representative list of rents assignment		SMIETSP	CHAR	6	TIV20
SMIVE	Lease-Out Number		SMIVE	CHAR	13
XMVART	Lease out: Type		VVXMVART	CHAR	15
FLG_MITARB	Employee indicator		VVSMITARB2	CHAR	1
OBJNR	Object number		J_OBJNR	CHAR	22	ONR00
SPARTNR	Partner number		SPARTNR	CHAR	10	SPRT1
SMVANART	Rental agreement primary adjustment type		SMVAR04	CHAR	1	TIV27
PRCTR	Profit Center		PRCTR	CHAR	10	*
JBKRZ	Cash deposit instalment payment		VVJBKRZ	CHAR	1
REINS	Unit for cubic volume		REINS	UNIT	3	T006
JRMSCHPR	Tenant service charge settlement?		VVJRMSCHPR	CHAR	1
DGABANRT44	Secondary adjustment type valid from		VVDGABANR2	DATS	8
DBISANRT44	Secondary adjustment type valid until		VVDBISANR2	DATS	8
SMVANART44	Rental agreement secondary adjustment type		SMVAR44	CHAR	1	TIV27
SICHGEB	Guarantor		VVXSICHGEB	CHAR	30
JSKUEND	Special right of notice		JSKUEND	CHAR	1
STTXT_EXT	Status: Set by user		VVXSTXTEXT	CHAR	40
STTXT_INT	Status: Set by system		VVXSTTXTIN	CHAR	40
DGAB	Date when the apportionment factor becomes valid		VVDUMLGA	DATS	8
SABRG	Apportionment unit		SABRG	NUMC	4	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	8
VERLG	Contract renewal by ... months		VERLG	NUMC	3
SMVART	External Real Estate Contract Type		SMVART	CHAR	4	TIV26
JVERL	Contract renewal		JVERL	CHAR	1
SWENR	Business Entity Number		SWENR	CHAR	8	VIOB01
XGZLSCH	Payment method for credit memos		VVXGZLSCH	CHAR	30
XZLSCH	Payment method		VVXZLSCH	CHAR	30
GZLSCH	Payment method for credit memos		VVGZLSCH	CHAR	1	*
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	8
DGUELBIS	Date up to when subsidy valid		VVDZUSPBIS	DATS	8
DFAELL	Subsidy due date		VVDZUSPFAE	DATS	8
BZUBETR	Subsidy/allowance amount		VVZUBETR	CURR	7
XZUSPKUNNR	Subsidizer		VVXZUSPPRT	CHAR	35
SPARTNRABW	Alternative payer (partner number)		VVRPARTABW	CHAR	10	SPRT1
DAENDDR	Date When the Lease-Out was Changed and Printed Out		VVDAENDDR	DATS	8
DMIENKUE	End Date of Lease-Out		VVDMIENKUE	DATS	8