SAP VIRPS407 Rental agreements Table

Overview

VIRPS407 is a standard SAP S/4HANA table that stores Rental agreements data. There are total 163 fields in the VIRPS407 table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VIRPS407 belongs to Real Estate Management (RE) module and is located in the package R/3 appl.dev. for Financial Assets Management: Real estate (FVVI).

In addition, following links provide an overview of foreign key relationships, if any, that link VIRPS407 to other SAP tables and standard CDS views available based on VIRPS407 table in S/4HANA 2020.

Techincal Settings of VIRPS407

Below are technical details of the table VIRPS407

Buffering not allowed
No buffering
Storage type is Column Store

List of VIRPS407 Fields

The following table gives you an overview of the fields available in VIRPS407

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
SSOUR	Statistic(s) origin	SSOUR		CHAR	4
VRSIO	Version number in the information structure	VRSIO	*	CHAR	3
SPMON	Period to analyze - month	SPMON		NUMC	6
SPTAG	Period to analyze - current date	SPTAG		DATS	8
SPWOC	Period to analyze - week	SPWOC		NUMC	6
SPBUP	Period to analyze - posting period	SPBUP		NUMC	6
BUKRS_01	Company Code	BUKRS	T001	CHAR	4
GSBER_02	Business Area	GSBER	TGSB	CHAR	4
SWENR_03	Business Entity Number	SWENR	VIOB01	CHAR	8
SGRNR_04	Land Number for BE	SGRNR	VIOB02	CHAR	8
SGENR_05	Building Number	SGENR	VIOB03	CHAR	8
SMENR_06	Number of Rental Unit	SMENR	VIMI01	CHAR	8
SMIVE_07	Lease-Out Number	SMIVE		CHAR	13
PERIV	Fiscal Year Variant	PERIV	T009	CHAR	2
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	TCURC	CUKY	5
FEINS	Area Unit	FEINS	T006	UNIT	3
DERSTDR	Date When the Lease-Out was First Printed	VVDERSTDR		DATS	8
PROFL	Settlement profile for costs	VVAPROF	TKB1A	CHAR	6
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	6
AZIMM	Number of rooms	VVAZIMM		DEC	6
AHALBZI	Number of half rooms	VVAHALBZI		DEC	6
SKUEFR	Type of notice period	SKUEFR		NUMC	1
SAUSTKL	Fixtures and fittings category	SAUSKL	TIV23	NUMC	2
BANKKS	Bank Keys	BANKK		CHAR	15
DBKERH	Cash deposit received on	VVDBKERH		DATS	8
MEINS	Base Unit of Measure	MEINS	T006	UNIT	3
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	T006	UNIT	3
USRCUKY2	User field: Unit for value fields	USRCUKY	TCURC	CUKY	5
USRCUKY1	User field: Unit for value fields	USRCUKY	TCURC	CUKY	5
USRUNIT2	User field: Unit for quantity fields	USRUNIT	T006	UNIT	3
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 103)	USRQUAN131		QUAN	13
USR05	User field 2 for set (length 10.3)	USRQUAN132		QUAN	13
USR06	User field 1 for values (length 10.3)	USRCURR131		CURR	13
USR07	User field 2 for values (length 10.3)	USRCURR132		CURR	13
JBETRST	Security deposit granted	JBETRST		CHAR	1
BKONDQM	Currency amount per area unit	BKONDQM		CURR	13
FBEZUG	Reference area for calculation of amounts per area unit	VVFBEZUG		QUAN	15
BUKRS	Company Code	BUKRS	T001	CHAR	4
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
ZUSPKUNNR	Customer Number	KUNNR	KNA1	CHAR	10
BABRE	Settlement units	VVBABRE		QUAN	14
PERHOE	Percentage rate increase	VVPERHOE		DEC	10
FKONDFLA	Area for condition type	VVFKONDFLA		QUAN	15
SGENR	Building Number	SGENR	VIOB03	CHAR	8
XGEBT	Building: part	VVXGEBT		CHAR	15
SGEBT	Part of Building	SGEBT	TIV12	CHAR	2
GERSTD	Jurisdiction	VVXGERSTD		CHAR	35
SSTOCKW	Floor	VVSSTOCKW	TIV37	NUMC	3
XSTOCKW	Floor (text)	VVXSTOCKW		CHAR	15
GSBER	Business Area	GSBER	TGSB	CHAR	4
XASPGRD	Reason for adjustment block (text)	VVXASPGRD		CHAR	30
XMANSP	Dunning block reason	VVXMANSP		CHAR	30
SASPGRD	Reason for adjustment block	VVSASPGRD	TIV14	NUMC	2
SGRNR	Land Number for BE	SGRNR	VIOB02	CHAR	8
KUNNR	Main tenant: Customer number	VVRDEBIHV2	KNA1	CHAR	10
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	13
JMFREI	Condition is not checked	VVJMFREI		CHAR	1
DGULTAB	Condition: effective from	VVDKOND		DATS	8
SKOART	Condition Type (Smallest Subdivision of Condition Records)	SKOART	TZK01	NUMC	4
BKOND	Condition Item Currency Amount	BKOND		CURR	13
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	6
XLGESCH	Location in floor (text)	VVXLGESCH		CHAR	15
RLGESCH	Location on Floor	RLGESCH	TIV38	CHAR	2
SLAGK	Location class	SLAGK	TIV22	NUMC	2
MANSP	Dunning Block	MANSP	T040S	CHAR	1
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	13
AMELDIN	Sales reporting interval	AMELDIN		NUMC	2
SMENR	Number of Rental Unit	SMENR	VIMI01	CHAR	8
XMBEZ	Reason for rent reduction	VVMMXMBEZ		CHAR	30
SKAUTART	Type of Rental Collateral	SKAUA	TIV18	CHAR	1
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	TIV20	CHAR	6
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	ONR00	CHAR	22
SPARTNR	Partner number	SPARTNR	SPRT1	CHAR	10
SMVANART	Rental agreement primary adjustment type	SMVAR04	TIV27	CHAR	1
PRCTR	Profit Center	PRCTR	*	CHAR	10
JBKRZ	Cash deposit instalment payment	VVJBKRZ		CHAR	1
REINS	Unit for cubic volume	REINS	T006	UNIT	3
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	TIV27	CHAR	1
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	TIV07	NUMC	4
PPROZ0	Sales: minimum percentage	VVPPROZ0		DEC	5
BMINUMS	Sales: minimum	VVBUMSATZ1		CURR	13
BUMSPROJ	Sales: plan	VVBUMSPROJ		CURR	13
DVMUN	Contract signed by landlord	VVDVMUN		DATS	8
VERLG	Contract renewal by ... months	VERLG		NUMC	3
SMVART	External Real Estate Contract Type	SMVART	TIV26	CHAR	4
JVERL	Contract renewal	JVERL		CHAR	1
SWENR	Business Entity Number	SWENR	VIOB01	CHAR	8
XGZLSCH	Payment method for credit memos	VVXGZLSCH		CHAR	30
ZLSCH	Payment Method	DZLSCH	*	CHAR	1
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	10
PROZTEIL	Subsidy percentage rate	VVPZUSP		DEC	5
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	13
XZUSPKUNNR	Subsidizer	VVXZUSPPRT		CHAR	35
ZUSP	Subsidies available indicator	VVZUSP		CHAR	1
SPARTNRABW	Alternative payer (partner number)	VVRPARTABW	SPRT1	CHAR	10
DAENDDR	Date When the Lease-Out was Changed and Printed Out	VVDAENDDR		DATS	8
DMIENKUE	End Date of Lease-Out	VVDMIENKUE		DATS	8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIRPS407

Table Name	Field	Cardinality	Check Table
VIRPS407	BUKRS	:	T001
VIRPS407	BUKRS_01	1: CN	T001
VIRPS407	FEINS	:	T006
VIRPS407	GSBER	:	TGSB
VIRPS407	GSBER_02	:	TGSB
VIRPS407	KUNNR	:	KNA1
VIRPS407	MANDT	:	T000
VIRPS407	MANSP	:	T040S
VIRPS407	MEINS	:	T006
VIRPS407	OBJNR	:	ONR00
VIRPS407	PERIV	:	T009
VIRPS407	PROFL	:	TKB1A
VIRPS407	REINS	:	T006
VIRPS407	RLGESCH	:	TIV38
VIRPS407	SABRG	:	TIV07
VIRPS407	SASPGRD	:	TIV14
VIRPS407	SAUSTKL	:	TIV23
VIRPS407	SGEBT	:	TIV12
VIRPS407	SGENR	:	VIOB03
VIRPS407	SGENR_05	:	VIOB03
VIRPS407	SGRNR	:	VIOB02
VIRPS407	SGRNR_04	:	VIOB02
VIRPS407	SKAUTART	:	TIV18
VIRPS407	SKOART	:	TZK01
VIRPS407	SLAGK	:	TIV22
VIRPS407	SMENR	:	VIMI01
VIRPS407	SMENR_06	:	VIMI01
VIRPS407	SMIETSP	:	TIV20
VIRPS407	SMVANART	:	TIV27
VIRPS407	SMVANART44	:	TIV27
VIRPS407	SMVART	:	TIV26
VIRPS407	SPARTNR	:	SPRT1
VIRPS407	SPARTNRABW	:	SPRT1
VIRPS407	SSTOCKW	:	TIV37
VIRPS407	SWENR	:	VIOB01
VIRPS407	SWENR_03	:	VIOB01
VIRPS407	USRCUKY1	:	TCURC
VIRPS407	USRCUKY2	:	TCURC
VIRPS407	USRUNIT1	:	T006
VIRPS407	USRUNIT2	:	T006
VIRPS407	WAERS	:	TCURC
VIRPS407	ZUSPKUNNR	:	KNA1

SAP VIRPS407 Rental agreements Table

Overview

Techincal Settings of VIRPS407

List of VIRPS407 Fields

Foreign Key Relationships

Other References