SAP ABAP Table VIRPS406 (Rental units)

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	VIRPS406	Table Relationship Diagram
Short Description	Rental units

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
16	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
17	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
18	SGENR	☐	VVSGENR	SGENR	CHAR	8	0	Building: number	VIOB03
19	SMENR	☐	VVSMENR	SMENR	CHAR	8	0	Rental unit: number	VIMI01
20	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
21	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
22	USRUNIT1	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
23	USRUNIT2	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
24	USRCUKY1	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
25	USRCUKY2	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
26	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
28	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
29	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
30	XORT	☐	VVXORT	TEXT35	CHAR	35	0	Address: City
31	XPLZ	☐	VVXPLZ	PSTLZ	CHAR	10	0	Address: Postal code
32	XSTRASSE	☐	VVXSTRASSE	TEXT35	CHAR	35	0	Address: Street/house number
33	ANZME	☐	VVAME	DEC6	DEC	6	0	Number of rental units
34	USR02	☐	USRCHAR101	USRCHAR10	CHAR	10	0	User-defined field 1 for 10 characters
35	USR03	☐	USRCHAR102	USRCHAR10	CHAR	10	0	User-defined field 2 for 10 characters
36	USR00	☐	USRCHAR201	USRCHAR20	CHAR	20	0	User-defined field 1 for 20 characters
37	USR01	☐	USRCHAR202	USRCHAR20	CHAR	20	0	User field 2 for 20 characters
38	USR08	☐	USRDATE1	USRDATE	DATS	8	0	User field 1 for date
39	USR09	☐	USRDATE2	USRDATE	DATS	8	0	User field 2 for date
40	USR10	☐	USRFLAG1	FLAG	CHAR	1	0	User field 1 indicator for evaluations
41	USR11	☐	USRFLAG2	FLAG	CHAR	1	0	User field 2 indicator for evaluations
42	USR04	☐	USRQUAN131	USRQUAN13	QUAN	13	3	User field 1 for set (length 10,3)
43	USR05	☐	USRQUAN132	USRQUAN13	QUAN	13	3	User field 2 for set (length 10.3)
44	USR06	☐	USRCURR131	USRCURR13	CURR	13	3	User field 1 for values (length 10.3)
45	USR07	☐	USRCURR132	USRCURR13	CURR	13	3	User field 2 for values (length 10.3)
46	FBEZUG	☐	VVFBEZUG	VVFBEZUG	QUAN	15	2	Reference area for calculation of amounts per area unit
47	FQMFLART	☐	VVBFLART	VVBFLART	QUAN	14	4	Area of area type
48	DSFLART	☐	VVDSFLART	DATS	DATS	8	0	Area: effective from
49	SFLART	☐	SFLART	SFLART	NUMC	4	0	Area type	TIV08
50	KOSTL	☐	VVXKOSTL	KOSTL	CHAR	10	0	Cost center: name	*
51	DATAB	☐	VVDKOSTL	DATUM	DATS	8	0	Cost center: effective from_
52	ADRNR	☐	SOBJNR	SOBJNR	NUMC	10	0	Object number (virtual object)	*
53	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
54	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
55	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
56	STTXT_EXT	☐	VVXSTXTEXT	CHAR40	CHAR	40	0	Status: Set by user
57	STTXT_INT	☐	VVXSTTXTIN	CHAR40	CHAR	40	0	Status: Set by system
58	XMETXT	☐	VVXMETXT	XMBEZ	CHAR	30	0	Text for rental unit
59	SKOART	☐	VVSKOART	SKOART	NUMC	4	0	Condition: Type	TZK01
60	BKOND	☐	VVBKOND	WRTV7	CURR	13	2	Condition: amount
61	DGULTAB	☐	VVDKOND	DDAT	DATS	8	0	Condition: effective from
62	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
63	XNUNR	☐	VVXNUNR	CHAR30	CHAR	30	0	Rental unit usage type (text)
64	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
65	SRAART	☐	SRAART	SRAART	NUMC	2	0	Room type	TIV09
66	BRAART	☐	BRAART	DEC3	DEC	3	0	Number of rooms per room type
67	SMERKMA	☐	SMERKMA	SMERKMA	NUMC	3	0	Fixtures and Fittings Characteristics	TIV71
68	XMERKMA	☐	VVXMERKMA	XTEXT30	CHAR	30	0	Characteristic
69	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
70	XSTOCKW	☐	VVXSTOCKW	CHAR15	CHAR	15	0	Floor (text)
71	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
72	XLGESCH	☐	VVXLGESCH	CHAR15	CHAR	15	0	Location in floor (text)
73	DBEZU	☐	VVDBEZU	DDAT	DATS	8	0	Date: First usage
74	SABRG	☐	VVSABRG2	SABRG	NUMC	4	0	Apportionment unit: type	TIV07
75	DGAB	☐	VVDGAB2	DDAT	DATS	8	0	Apportionment unit: effective from
76	BABRE	☐	VVBUMLEINH	VVBUMLEINH	QUAN	6	2	Apportionment units
77	TXT04	☐	VVXJ_TXT04	CHAR04	CHAR	4	0	Occupancy type: short text
78	TXT30	☐	VVXJ_TXT30	CHAR30	CHAR	30	0	Occupancy type (text)
79	BELEAB	☐	VVDBELEAB	DATUM	DATS	8	0	Occupancy type: effet.from
80	BELEBIS	☐	VVDBELEBIS	DATUM	DATS	8	0	Occupancy type: eff. to
81	DBEGEH	☐	VVDBEGEH	DDAT	DATS	8	0	Last access: date
82	XBEGEH	☐	VVXBEGEH	XKBEZ	CHAR	15	0	Last inspection: by
83	PERHOE	☐	VVPERHOE2	DEC8_2	DEC	10	2	Increase: percentage
84	RPROZGRD	☐	VVRPROZGRD	RPROZGRD	CHAR	2	0	Increase: Reason for difference	TIV43
85	XPROZGRD	☐	VVXPROZGRD	CHAR15	CHAR	15	0	Increase: Reason for difference
86	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
87	AZIMM	☐	VVAZIMM	DEC6	DEC	6	0	Number of rooms
88	AHALBZI	☐	VVAHALBZI	DEC6	DEC	6	0	Number of half rooms
89	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
90	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
91	ABNNR	☐	VVABNNR	TEXT20	CHAR	20	0	Settlement firm: number
92	STECHEM	☐	VVSTECHEM	STECHEM	CHAR	13	0	Settlement firm: Evaluation group
93	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
94	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
95	RFAKT	☐	VVXFAKT	CHAR6	CHAR	6	0	Conversion factor for fractional share of property
96	JKONDMV	☐	VVJKONDMV2	XFELD	CHAR	1	0	Cond.transfer RA: indicator
97	PKONDMV	☐	VVPKONDMV2	PRZ32	DEC	5	2	Cond.transfer LO: percent
98	DFSTRBIS	☐	VVDFSTRBI2	DATUM	DATS	8	0	Date: Cash flow until
99	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
100	DHPZSAKT	☐	VVDHPZSAK2	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
101	DUTBKAKT	☐	VVDUTBKAK2	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
102	DTEURAKT	☐	VVDTEURAK2	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
103	SMIETSP	☐	SMIETSP	SMIETSP	CHAR	6	0	Representative list of rents assignment	TIV20
104	XMIETSP	☐	VVXMIETSP	CHAR15	CHAR	15	0	Representative list of rents: allocation
105	PZUABSP	☐	VVPZUABSP2	DEC8_2	DEC	10	2	Representative list of rents: surcharge/reduction
106	SLAGK	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
107	XLAGK	☐	VVXLAGK	XMBEZ	CHAR	30	0	Representative list of rents: locat.class
108	SAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
109	XAUSTKL	☐	VVXXAUSTKL	CHAR15	CHAR	15	0	Represent. list of rents: Fixture/fitting category
110	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
111	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
112	XBELBIND	☐	VVXBELBIND	CHAR15	CHAR	15	0	Occupancy obligation: to
113	DBINDBIS	☐	VVDBINDBIS	DATUM	DATS	8	0	Occupancy obligation: until
114	SBWNR	☐	VVXBWNR	VVXBWNR	CHAR	7	0	Reservation application number of a rental unit
115	SPARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
116	XPARTNR	☐	VVXPARTNRB	CHAR35	CHAR	35	0	Name of applicant for a rental unit
117	XNNPART	☐	VVNNPART	TEXT20	CHAR	20	0	Last name of applicant
118	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
119	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
120	UMBRAUM	☐	VVBUBRA	VVBUBRA	QUAN	11	3	Cubic Volume
121	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
122	XGEBT	☐	VVXGEBT	CHAR15	CHAR	15	0	Building: part

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIRPS406	BUKRS	T001	BUKRS
2	VIRPS406	BUKRS_01	T001	BUKRS
3	VIRPS406	FEINS	T006	MSEHI
4	VIRPS406	GSBER	TGSB	GSBER
5	VIRPS406	GSBER_02	TGSB	GSBER
6	VIRPS406	MANDT	T000	MANDT
7	VIRPS406	MEINS	T006	MSEHI
8	VIRPS406	OBJNR	ONR00	OBJNR
9	VIRPS406	PERIV	T009	PERIV
10	VIRPS406	RBELBIND	TIV31	RBELBIND
11	VIRPS406	REINS	T006	MSEHI
12	VIRPS406	RLGESCH	TIV38	RLGESCH
13	VIRPS406	RPROZGRD	TIV43	RPROZGRD
14	VIRPS406	SABRG	TIV07	SABRG
15	VIRPS406	SAUSTKL	TIV23	SMKLASS
16	VIRPS406	SFLART	TIV08	SFLART
17	VIRPS406	SGEBT	TIV12	SGEBT
18	VIRPS406	SGENR	VIOB03	SGENR
19	VIRPS406	SGENR_05	VIOB03	SGENR
20	VIRPS406	SGRNR	VIOB02	SGRNR
21	VIRPS406	SGRNR_04	VIOB02	SGRNR
22	VIRPS406	SKOART	TZK01	SKOART
23	VIRPS406	SLAGK	TIV22	SLAGK
24	VIRPS406	SMENR	VIMI01	SMENR
25	VIRPS406	SMENR_06	VIMI01	SMENR
26	VIRPS406	SMERKMA	TIV71	SMERKMA
27	VIRPS406	SMIETSP	TIV20	SMIETSP
28	VIRPS406	SNUNR	TIV01	SNUNR
29	VIRPS406	SPARTNR	SPRT1	PARTNR
30	VIRPS406	SRAART	TIV09	SRAART
31	VIRPS406	SSTCKBIS	TIV37	SSTOCKW
32	VIRPS406	SSTOCKW	TIV37	SSTOCKW
33	VIRPS406	SWENR	VIOB01	SWENR
34	VIRPS406	SWENR_03	VIOB01	SWENR
35	VIRPS406	USRCUKY1	TCURC	WAERS
36	VIRPS406	USRCUKY2	TCURC	WAERS
37	VIRPS406	USRUNIT1	T006	MSEHI
38	VIRPS406	USRUNIT2	T006	MSEHI
39	VIRPS406	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in