VIRPS407

Rental agreements | #transactional | Component: Real Estate Management

🔑 Keys (14)
💰 Amounts (9)
∑ Quantities (5)
📅 Dates (28)
☰ Categorical (15)
Other (56)
🔗 Relations (40)

Column Name	Description
MANDT FK	Client
SSOUR	Statistic(s) origin
VRSIO	Version number in the information structure
SPMON	Period to analyze - month
SPTAG	Period to analyze - current date
SPWOC	Period to analyze - week
SPBUP	Period to analyze - posting period
BUKRS_01 FK	Company Code
GSBER_02 FK	Business Area
SWENR_03 FK	Business Entity Number
SGRNR_04 FK	Land Number for BE
SGENR_05 FK	Building Number
SMENR_06 FK	Number of Rental Unit
SMIVE_07	Lease-Out Number

Column Name	Description
💲 User field: Unit for value fields (USRCUKY1):
USR06	User field 1 for values (length 10.3)
💲 User field: Unit for value fields (USRCUKY2):
USR07	User field 2 for values (length 10.3)
💲 Currency Key (WAERS):
BKONDQM	Currency amount per area unit
BKAUTION	Deposit: amount
BKOND	Condition Item Currency Amount
BMWST	Value-added tax amount included
BMINUMS	Sales: minimum
BUMSPROJ	Sales: plan
BZUBETR	Subsidy/allowance amount

Column Name	Description
📏 User field: Unit for quantity fields (USRUNIT1):
USR04	User field 1 for set (length 10,3)
📏 User field: Unit for quantity fields (USRUNIT2):
USR05	User field 2 for set (length 10.3)
📏 Area Unit (FEINS):
FBEZUG	Reference area for calculation of amounts per area unit
FKONDFLA	Area for condition type
📏 Base Unit of Measure (MEINS):
BABRE	Settlement units

Column Name	Description
SPTAG	Period to analyze - current date
DERSTDR	Date When the Lease-Out was First Printed
DASPVON	Adjustment block as from
DASPBIS	Adjustment block until
DBKERH	Cash deposit received on
USR08	User field 1 for date
USR09	User field 2 for date
DERZAHL	Date: 1st debit position
DAKTV	Date: Activation
DAUSZG	Date: Move-out
DEINZG	Date: Move-in
DKUEZU	Date: Notice
DMIBEG	Date: Start of rent
DMIEND	Date: rental end
DUNTBIS	Date: Provisional agreement from
DKAUFOPT	Purchase option: date
DGULTAB	Condition: effective from
DATAB	Cost center: effective from_
MADAT	Date of last dunning letter
DGABANRT44	Secondary adjustment type valid from
DBISANRT44	Secondary adjustment type valid until
DGAB	Date when the apportionment factor becomes valid
DVMUN	Contract signed by landlord
DGUELTAB	Date as from when subsidy valid
DGUELBIS	Date up to when subsidy valid
DFAELL	Subsidy due date
DAENDDR	Date When the Lease-Out was Changed and Printed Out
DMIENKUE	End Date of Lease-Out

Column Name	Description
SKUEFR	Type of notice period	Show values
SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	Show values
USR10	User field 1 indicator for evaluations	Show values
USR11	User field 2 indicator for evaluations	Show values
JBETRST	Security deposit granted	Show values
JKAUFOPT	Purchase option: indicator	Show values
JMFREI	Condition is not checked	Show values
JMAHNMSP	Dunning block indicator - no longer used!	Show values
AMELDIN	Sales reporting interval	Show values
FLG_MITARB	Employee indicator	Show values
JBKRZ	Cash deposit instalment payment	Show values
JRMSCHPR	Tenant service charge settlement?	Show values
JSKUEND	Special right of notice	Show values
JVERL	Contract renewal	Show values
ZUSP	Subsidies available, indicator	Show values

Column Name	Description	Domain name
VWDAT	Pointer to administrative data	VWDAT
ABNNR	Settlement firm: number	TEXT20
STECHEM	Settlement firm: Evaluation group	STECHEM
ABNUNR	Settlement company: subnumber	NUM3
XNNPARTABW	Alternative payer: surname	TEXT20
XPARTNRABW	Alternative payer: name	CHAR35
XORT	Address: City	TEXT35
XPLZ	Address: Postal code	PSTLZ
XSTRASSE	Address: Street/house number	TEXT35
ANKUEN	Notification until (for renewal of contract)	NUMC2
XMVANART	Lease-out primary adjustment type	CHAR15
XMVANART44	Lease-Out Secondary Adjustment Type	XKBEZ
ANZMV	No. of lease-outs	VVDEC6
AZIMM	Number of rooms	DEC6
AHALBZI	Number of half rooms	DEC6
BANKKS	Bank Keys	BANKK
XBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	CHAR30
USR02	User-defined field 1 for 10 characters	USRCHAR10
USR03	User-defined field 2 for 10 characters	USRCHAR10
USR00	User-defined field 1 for 20 characters	USRCHAR20
USR01	User field 2 for 20 characters	USRCHAR20
PERHOE	Percentage rate increase	DEC8_2
XGEBT	Building: part	CHAR15
GERSTD	Jurisdiction	TEXT35
XSTOCKW	Floor (text)	CHAR15
XASPGRD	Reason for adjustment block (text)	XTEXT30
XMANSP	Dunning block reason	CHAR30
XNNPART	Master tenant: last name	TEXT20
XPARTNR	Master tenant: name	CHAR35
INTRENO	Internal Real Estate Master Data Code	VVINTRENO
KOSTL	Cost center: name	KOSTL
XKUEFR	Type of notice period	CHAR30
DKUEFR	Notice period: months	DEC06
XLGESCH	Location in floor (text)	CHAR15
MABER	Dunning: area	MABER
MANST	Dunning: level	MAHNS
XMBEZ	Reason for rent reduction	XMBEZ
XKAUTART	Deposit: type	CHAR15
XAUSTKL	Represent. list of rents: Fixture/fitting category	CHAR15
XLAGK	Representative list of rents: locat.class	XMBEZ
XMIETSP	Representative list of rents: allocation	CHAR15
SMIVE	Lease-Out Number	VVSMIVE
XMVART	Lease out: Type	CHAR15
PRCTR	Profit Center	PRCTR
SICHGEB	Guarantor	TEXT30
STTXT_EXT	Status: Set by user	CHAR40
STTXT_INT	Status: Set by system	CHAR40
PPROZ0	Sales: minimum percentage	DEC3_2
VERLG	Contract renewal by ... months	NUMC3
XGZLSCH	Payment method for credit memos	CHAR30
ZLSCH	Payment Method	ZLSCH
XZLSCH	Payment method	CHAR30
GZLSCH	Payment method for credit memos	ZLSCH
PZUABSP	Surcharge or reduction for representative list of rents	DEC8_2
PROZTEIL	Subsidy percentage rate	DECV5_2
XZUSPKUNNR	Subsidizer	CHAR35

Master Data Relations	Join Conditions
Company Code	`VIRPS407.MANDT == T001.MANDT` `VIRPS407.BUKRS == T001.BUKRS`
Company code	`VIRPS407.MANDT == T001.MANDT` `VIRPS407.BUKRS_01 == T001.BUKRS`
Area Unit	`VIRPS407.MANDT == T006.MANDT` `VIRPS407.FEINS == T006.MSEHI`
Business Area	`VIRPS407.MANDT == TGSB.MANDT` `VIRPS407.GSBER == TGSB.GSBER`
Business Area	`VIRPS407.MANDT == TGSB.MANDT` `VIRPS407.GSBER_02 == TGSB.GSBER`
Main tenant: Customer number	`VIRPS407.MANDT == KNA1.MANDT` `VIRPS407.KUNNR == KNA1.KUNNR`
Client	`VIRPS407.MANDT == T000.MANDT`
Dunning Block	`VIRPS407.MANDT == T040S.MANDT` `VIRPS407.MANSP == T040S.MANSP`
Base Unit of Measure	`VIRPS407.MANDT == T006.MANDT` `VIRPS407.MEINS == T006.MSEHI`
Fiscal Year Variant Fiscal Year Variant Client	`VIRPS407.PERIV == T009.PERIV` `VIRPS407.MANDT == T009.MANDT`
Settlement profile for costs Settlement profile for costs Client	`VIRPS407.PROFL == TKB1A.APROF` `VIRPS407.MANDT == TKB1A.MANDT`
Unit for cubic volume	`VIRPS407.MANDT == T006.MANDT` `VIRPS407.REINS == T006.MSEHI`
Location on Floor	`VIRPS407.MANDT == TIV38.MANDT` `VIRPS407.RLGESCH == TIV38.RLGESCH`
Apportionment unit	`VIRPS407.MANDT == TIV07.MANDT` `VIRPS407.SABRG == TIV07.SABRG`
Reason for adjustment block	`VIRPS407.MANDT == TIV14.MANDT` `VIRPS407.SASPGRD == TIV14.SASPGRD`
Fixtures and fittings category Fixtures and fittings category Client Representative list of rents assignment	`VIRPS407.SAUSTKL == TIV23.SMKLASS` `VIRPS407.MANDT == TIV23.MANDT` `VIRPS407.SMIETSP == TIV23.SMIETSP`
Part of Building	`VIRPS407.MANDT == TIV12.MANDT` `VIRPS407.SGEBT == TIV12.SGEBT`
Building Number Building Number Company Code Business Entity Number	`VIRPS407.MANDT == VIOB03.MANDT` `VIRPS407.SGENR == VIOB03.SGENR` `VIRPS407.BUKRS == VIOB03.BUKRS` `VIRPS407.SWENR == VIOB03.SWENR`
Building Number Building Number Company Code Business Entity Number	`VIRPS407.MANDT == VIOB03.MANDT` `VIRPS407.SGENR_05 == VIOB03.SGENR` `VIRPS407.BUKRS == VIOB03.BUKRS` `VIRPS407.SWENR == VIOB03.SWENR`
Land Number for BE Company Code Land Number for BE Client Business Entity Number	`VIRPS407.BUKRS == VIOB02.BUKRS` `VIRPS407.SGRNR == VIOB02.SGRNR` `VIRPS407.MANDT == VIOB02.MANDT` `VIRPS407.SWENR == VIOB02.SWENR`
Land Number for BE Company Code Land Number for BE Client Business Entity Number	`VIRPS407.BUKRS == VIOB02.BUKRS` `VIRPS407.SGRNR_04 == VIOB02.SGRNR` `VIRPS407.MANDT == VIOB02.MANDT` `VIRPS407.SWENR == VIOB02.SWENR`
Type of Rental Collateral Type of Rental Collateral Client	`VIRPS407.SKAUTART == TIV18.SKAUTART` `VIRPS407.MANDT == TIV18.MANDT`
Condition Type (Smallest Subdivision of Condition Records) Condition Type (Smallest Subdivision of Condition Records) ?	`VIRPS407.MANDT == TZK01.MANDT` `VIRPS407.SKOART == TZK01.SKOART` `VIRPS407.[column in domain "RANTYP"] == TZK01.RANTYP`
Location class Representative list of rents assignment Client Location class	`VIRPS407.SMIETSP == TIV22.SMIETSP` `VIRPS407.MANDT == TIV22.MANDT` `VIRPS407.SLAGK == TIV22.SLAGK`
Number of Rental Unit Company Code Business Entity Number Number of Rental Unit	`VIRPS407.MANDT == VIMI01.MANDT` `VIRPS407.BUKRS == VIMI01.BUKRS` `VIRPS407.SWENR == VIMI01.SWENR` `VIRPS407.SMENR == VIMI01.SMENR`
Number of Rental Unit Company Code Business Entity Number Number of Rental Unit	`VIRPS407.MANDT == VIMI01.MANDT` `VIRPS407.BUKRS == VIMI01.BUKRS` `VIRPS407.SWENR == VIMI01.SWENR` `VIRPS407.SMENR_06 == VIMI01.SMENR`
Representative list of rents assignment	`VIRPS407.MANDT == TIV20.MANDT` `VIRPS407.SMIETSP == TIV20.SMIETSP`
Rental agreement primary adjustment type	`VIRPS407.MANDT == TIV27.MANDT` `VIRPS407.SMVANART == TIV27.SMVANART`
Rental agreement secondary adjustment type	`VIRPS407.MANDT == TIV27.MANDT` `VIRPS407.SMVANART44 == TIV27.SMVANART`
External Real Estate Contract Type	`VIRPS407.MANDT == TIV26.MANDT` `VIRPS407.SMVART == TIV26.SMVART`
Floor	`VIRPS407.MANDT == TIV37.MANDT` `VIRPS407.SSTOCKW == TIV37.SSTOCKW`
Business Entity Number Company Code Business Entity Number	`VIRPS407.MANDT == VIOB01.MANDT` `VIRPS407.BUKRS == VIOB01.BUKRS` `VIRPS407.SWENR == VIOB01.SWENR`
Business Entity Number Company Code Business Entity Number	`VIRPS407.MANDT == VIOB01.MANDT` `VIRPS407.BUKRS == VIOB01.BUKRS` `VIRPS407.SWENR_03 == VIOB01.SWENR`
User field: Unit for value fields	`VIRPS407.MANDT == TCURC.MANDT` `VIRPS407.USRCUKY1 == TCURC.WAERS`
User field: Unit for value fields	`VIRPS407.MANDT == TCURC.MANDT` `VIRPS407.USRCUKY2 == TCURC.WAERS`
User field: Unit for quantity fields	`VIRPS407.MANDT == T006.MANDT` `VIRPS407.USRUNIT1 == T006.MSEHI`
User field: Unit for quantity fields	`VIRPS407.MANDT == T006.MANDT` `VIRPS407.USRUNIT2 == T006.MSEHI`
Currency Key	`VIRPS407.MANDT == TCURC.MANDT` `VIRPS407.WAERS == TCURC.WAERS`
Customer Number	`VIRPS407.MANDT == KNA1.MANDT` `VIRPS407.ZUSPKUNNR == KNA1.KUNNR`