SAP ABAP Table VIRPS407 (Rental agreements)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VIRPS407	Table Relationship Diagram
Short Description	Rental agreements

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	BUKRS_01	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	GSBER_02	☑	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
10	SWENR_03	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
11	SGRNR_04	☑	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
12	SGENR_05	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
13	SMENR_06	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
14	SMIVE_07	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	USRUNIT	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	*
18	USRCUKY	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	*
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
21	DERSTDR	☐	VVDERSTDR	DATUM	DATS	8	0	Date When the Lease-Out was First Printed
22	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
23	ABNNR	☐	VVABNNR	TEXT20	CHAR	20	0	Settlement firm: number
24	STECHEM	☐	VVSTECHEM	STECHEM	CHAR	13	0	Settlement firm: Evaluation group
25	ABNUNR	☐	VVABNUNR	NUM3	NUMC	3	0	Settlement company: subnumber
26	XNNPARTABW	☐	VVNNPARTBA	TEXT20	CHAR	20	0	Alternative payer: surname
27	XPARTNRABW	☐	VVXPARTNRA	CHAR35	CHAR	35	0	Alternative payer: name
28	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
29	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
30	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
31	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
32	XMVANART	☐	VVXMVANPPR	CHAR15	CHAR	15	0	Lease-out primary adjustment type
33	XMVANART44	☐	VVXMVANART	XKBEZ	CHAR	15	0	Lease-Out Secondary Adjustment Type
34	DASPVON	☐	VVDASPVON	DATUM	DATS	8	0	Adjustment block as from
35	DASPBIS	☐	VVDASPBIS	DATUM	DATS	8	0	Adjustment block until
36	ANZMV	☐	VVAMV	VVDEC6	DEC	6	0	No. of lease-outs
37	AZIMM	☐	VVAZIMM	DEC6	DEC	6	0	Number of rooms
38	AHALBZI	☐	VVAHALBZI	DEC6	DEC	6	0	Number of half rooms
39	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
40	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
41	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
42	DBKERH	☐	VVDBKERH	DATUM	DATS	8	0	Cash deposit received on
43	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
44	XBELEGNG	☐	VVSBELEGN2	CHAR30	CHAR	30	0	RU occupancy by LO (used by third-prty/private/corp.grp)
45	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
46	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
47	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
48	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
49	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
50	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
51	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
52	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
53	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
54	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
55	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
56	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
57	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
58	USR04	☐	USRQUAN131	USRQUAN13	QUAN	13	3	User field 1 for set (length 10,3)
59	USR05	☐	USRQUAN132	USRQUAN13	QUAN	13	3	User field 2 for set (length 10.3)
60	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
61	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
62	JBETRST	☐	JBETRST	JANEI	CHAR	1	0	Security deposit granted
63	BKONDQM	☐	BKONDQM	WRTV7	CURR	13	2	Currency amount per area unit
64	FBEZUG	☐	VVFBEZUG	VVFBEZUG	QUAN	15	2	Reference area for calculation of amounts per area unit
65	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
66	DERZAHL	☐	VVDERZA	DDAT	DATS	8	0	Date: 1st debit position
67	DAKTV	☐	VVDAKTV	DATUM	DATS	8	0	Date: Activation
68	DAUSZG	☐	VVDAUSZG2	DATS	DATS	8	0	Date: Move-out
69	DEINZG	☐	VVDEINZG2	DATS	DATS	8	0	Date: Move-in
70	DKUEZU	☐	VVDKUZU2	DATS	DATS	8	0	Date: Notice
71	DMIBEG	☐	VVDMIBE	DDAT	DATS	8	0	Date: Start of rent
72	DMIEND	☐	VVDMIEN	DDAT	DATS	8	0	Date: rental end
73	DUNTBIS	☐	VVDUNBI	DDAT	DATS	8	0	Date: Provisional agreement from
74	ZUSPKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
75	BABRE	☐	VVBABRE	VVBABRE	QUAN	14	4	Settlement units
76	PERHOE	☐	VVPERHOE	DEC8_2	DEC	10	2	Percentage rate increase
77	FKONDFLA	☐	VVFKONDFLA	VVFKONDFLA	QUAN	15	2	Area for condition type
78	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
79	XGEBT	☐	VVXGEBT	CHAR15	CHAR	15	0	Building: part
80	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
81	GERSTD	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
82	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
83	XSTOCKW	☐	VVXSTOCKW	CHAR15	CHAR	15	0	Floor (text)
84	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
85	XASPGRD	☐	VVXASPGRD	XTEXT30	CHAR	30	0	Reason for adjustment block (text)
86	XMANSP	☐	VVXMANSP	CHAR30	CHAR	30	0	Dunning block reason
87	SASPGRD	☐	VVSASPGRD	VVSASPGRD	NUMC	2	0	Reason for adjustment block	TIV14
88	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
89	KUNNR	☐	VVRDEBIHV2	KUNNR	CHAR	10	0	Main tenant: Customer number	KNA1
90	XNNPART	☐	VVNNPARTB	TEXT20	CHAR	20	0	Master tenant: last name
91	XPARTNR	☐	VVXPARTNR	CHAR35	CHAR	35	0	Master tenant: name
92	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
93	DKAUFOPT	☐	VVDKAUFOPT	DDAT	DATS	8	0	Purchase option: date
94	JKAUFOPT	☐	VVJKAUFOPT	JANEI	CHAR	1	0	Purchase option: indicator
95	BKAUTION	☐	VVBKAUTART	WRTV7	CURR	13	2	Deposit: amount
96	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
97	DGULTAB	☐	VVDKOND	DDAT	DATS	8	0	Condition: effective from
98	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
99	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
100	KOSTL	☐	VVXKOSTL	KOSTL	CHAR	10	0	Cost center: name	*
101	DATAB	☐	VVDKOSTL	DATUM	DATS	8	0	Cost center: effective from_
102	XKUEFR	☐	VVXKUEFR	CHAR30	CHAR	30	0	Type of notice period
103	DKUEFR	☐	VVAKUEFR2	DEC06	DEC	6	0	Notice period: months
104	XLGESCH	☐	VVXLGESCH	CHAR15	CHAR	15	0	Location in floor (text)
105	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
106	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
107	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
108	JMAHNMSP	☐	JMASP	JANE	CHAR	1	0	Dunning block indicator - no longer used!
109	MABER	☐	VVMABER	MABER	CHAR	2	0	Dunning: area	*
110	MADAT	☐	VVDMADAT	DATUM	DATS	8	0	Date of last dunning letter
111	MANST	☐	VVMAHNS	MAHNS	NUMC	1	0	Dunning: level
112	BMWST	☐	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
113	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
114	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
115	XMBEZ	☐	VVMMXMBEZ	XMBEZ	CHAR	30	0	Reason for rent reduction
116	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	TIV18
117	XKAUTART	☐	VVXKAUTART	CHAR15	CHAR	15	0	Deposit: type
118	XAUSTKL	☐	VVXXAUSTKL	CHAR15	CHAR	15	0	Represent. list of rents: Fixture/fitting category
119	XLAGK	☐	VVXLAGK	XMBEZ	CHAR	30	0	Representative list of rents: locat.class
120	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
121	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
122	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
123	XMVART	☐	VVXMVART	CHAR15	CHAR	15	0	Lease out: Type
124	FLG_MITARB	☐	VVSMITARB2	XFELD	CHAR	1	0	Employee indicator
125	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
126	SPARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
127	SMVANART	☐	SMVAR04	SMVAR	CHAR	1	0	Rental agreement primary adjustment type	TIV27
128	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
129	JBKRZ	☐	VVJBKRZ	JANEI	CHAR	1	0	Cash deposit instalment payment
130	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
131	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
132	DGABANRT44	☐	VVDGABANR2	DATUM	DATS	8	0	Secondary adjustment type valid from
133	DBISANRT44	☐	VVDBISANR2	DATUM	DATS	8	0	Secondary adjustment type valid until
134	SMVANART44	☐	SMVAR44	SMVAR	CHAR	1	0	Rental agreement secondary adjustment type	TIV27
135	SICHGEB	☐	VVXSICHGEB	TEXT30	CHAR	30	0	Guarantor
136	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
137	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
138	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
139	DGAB	☐	VVDUMLGA	DDAT	DATS	8	0	Date when the apportionment factor becomes valid
140	SABRG	☐	SABRG	SABRG	NUMC	4	0	Apportionment unit	TIV07
141	PPROZ0	☐	VVPPROZ0	DEC3_2	DEC	5	2	Sales: minimum percentage
142	BMINUMS	☐	VVBUMSATZ1	WRTV7	CURR	13	2	Sales: minimum
143	BUMSPROJ	☐	VVBUMSPROJ	WRTV7	CURR	13	2	Sales: plan
144	DVMUN	☐	VVDVMUN	DATUM	DATS	8	0	Contract signed by landlord
145	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
146	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
147	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
148	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
149	XGZLSCH	☐	VVXGZLSCH	CHAR30	CHAR	30	0	Payment method for credit memos
150	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
151	XZLSCH	☐	VVXZLSCH	CHAR30	CHAR	30	0	Payment method
152	GZLSCH	☐	VVGZLSCH	ZLSCH	CHAR	1	0	Payment method for credit memos	*
153	PZUABSP	☐	VVPZUABSP	DEC8_2	DEC	10	2	Surcharge or reduction for representative list of rents
154	PROZTEIL	☐	VVPZUSP	DECV5_2	DEC	5	2	Subsidy percentage rate
155	DGUELTAB	☐	VVDZUSPAB	DATUM	DATS	8	0	Date as from when subsidy valid
156	DGUELBIS	☐	VVDZUSPBIS	DATUM	DATS	8	0	Date up to when subsidy valid
157	DFAELL	☐	VVDZUSPFAE	DATUM	DATS	8	0	Subsidy due date
158	BZUBETR	☐	VVZUBETR	WERTV7	CURR	13	2	Subsidy/allowance amount
159	XZUSPKUNNR	☐	VVXZUSPPRT	CHAR35	CHAR	35	0	Subsidizer
160	ZUSP	☐	VVZUSP	JANE	CHAR	1	0	Subsidies available, indicator
161	SPARTNRABW	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	SPRT1
162	DAENDDR	☐	VVDAENDDR	DATUM	DATS	8	0	Date When the Lease-Out was Changed and Printed Out
163	DMIENKUE	☐	VVDMIENKUE	DATS	DATS	8	0	End Date of Lease-Out

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIRPS407	BUKRS	T001	BUKRS
2	VIRPS407	BUKRS_01	T001	BUKRS	KEY	1	CN
3	VIRPS407	FEINS	T006	MSEHI
4	VIRPS407	GSBER	TGSB	GSBER
5	VIRPS407	GSBER_02	TGSB	GSBER
6	VIRPS407	KUNNR	KNA1	KUNNR
7	VIRPS407	MANDT	T000	MANDT
8	VIRPS407	MANSP	T040S	MANSP
9	VIRPS407	MEINS	T006	MSEHI
10	VIRPS407	OBJNR	ONR00	OBJNR
11	VIRPS407	PERIV	T009	PERIV
12	VIRPS407	PROFL	TKB1A	APROF
13	VIRPS407	REINS	T006	MSEHI
14	VIRPS407	RLGESCH	TIV38	RLGESCH
15	VIRPS407	SABRG	TIV07	SABRG
16	VIRPS407	SASPGRD	TIV14	SASPGRD
17	VIRPS407	SAUSTKL	TIV23	SMKLASS
18	VIRPS407	SGEBT	TIV12	SGEBT
19	VIRPS407	SGENR	VIOB03	SGENR
20	VIRPS407	SGENR_05	VIOB03	SGENR
21	VIRPS407	SGRNR	VIOB02	SGRNR
22	VIRPS407	SGRNR_04	VIOB02	SGRNR
23	VIRPS407	SKAUTART	TIV18	SKAUTART
24	VIRPS407	SKOART	TZK01	SKOART
25	VIRPS407	SLAGK	TIV22	SLAGK
26	VIRPS407	SMENR	VIMI01	SMENR
27	VIRPS407	SMENR_06	VIMI01	SMENR
28	VIRPS407	SMIETSP	TIV20	SMIETSP
29	VIRPS407	SMVANART	TIV27	SMVANART
30	VIRPS407	SMVANART44	TIV27	SMVANART
31	VIRPS407	SMVART	TIV26	SMVART
32	VIRPS407	SPARTNR	SPRT1	PARTNR
33	VIRPS407	SPARTNRABW	SPRT1	PARTNR
34	VIRPS407	SSTOCKW	TIV37	SSTOCKW
35	VIRPS407	SWENR	VIOB01	SWENR
36	VIRPS407	SWENR_03	VIOB01	SWENR
37	VIRPS407	USRCUKY1	TCURC	WAERS
38	VIRPS407	USRCUKY2	TCURC	WAERS
39	VIRPS407	USRUNIT1	T006	MSEHI
40	VIRPS407	USRUNIT2	T006	MSEHI
41	VIRPS407	WAERS	TCURC	WAERS
42	VIRPS407	ZUSPKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20130529
SAP Release Created in