SAP ABAP Table RVIMI01_ZS (RE: Rental Unit - Master Data and Additional Fields)

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	INTTAB	Structure
Structure	RVIMI01_ZS	Table Relationship Diagram
Short Description	RE: Rental Unit - Master Data and Additional Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Structure with fields from VIMI01 and addit. fields
2	.INCLUDE	☐				0	0	Rental unit - Master data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
7	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
8	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
9	SGEBSWENR	☐	SGEBSWENR	SWENR	CHAR	8	0	BE no.of rental unit to which the RU is linked	VIOB01
10	SGEBSMENR	☐	SGEBSMENR	SMENR	CHAR	8	0	RU no. of rental unit to which the RU is linked	VIMI01
11	SHEIZNR	☐	SHEIZNR	SHEIZNR	NUMC	4	0	Real Estate heating system number
12	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
13	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
14	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
15	UMBRAUM	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
16	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
17	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
18	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
19	SBELART	☐	SBELA	SBELA	NUMC	1	0	Occupancy type indicator
20	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
21	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
22	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
23	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
24	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
25	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	TIV23
26	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	TIV22
27	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
28	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
29	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
30	DBEGEH	☐	DBEGEH	DDAT	DATS	8	0	Date of last RU inspection
31	XBEGEH	☐	XBEGEH	XKBEZ	CHAR	15	0	Inspected by
32	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
33	PZUABSP	☐	PZUABSP	PZUABSP	DEC	4	2	Surcharge or reduction for representative list of rents
34	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
35	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
36	DBINDBIS	☐	DBINDBIS	DATUM	DATS	8	0	Obligation period until
37	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
38	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
39	RLIFT	☐	RLIFT	RLIFT	NUMC	2	0	Type of elevator installation	TIV32
40	RMEDIEN	☐	RMEDIEN	RMEDIEN	NUMC	3	0	Media reception	TIV33
41	RWASSER	☐	RWASSER	RWASSER	NUMC	2	0	Type of water mains connection	TIV34
42	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
43	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
44	SADRME	☐	SADRME	SOBJNR	NUMC	10	0	Object number of rental unit for address purposes	SANO1
45	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
46	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
47	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
48	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
49	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
50	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
51	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
52	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
53	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
54	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
55	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
56	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
57	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
58	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
59	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
60	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
61	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
62	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
63	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
64	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
65	DFSTRBIS	☐	VVDFSTRBIS	DATUM	DATS	8	0	Date up to when the rental unit cash flow is created
66	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
67	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
68	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
69	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
70	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
71	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
72	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
73	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
74	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit
75	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*
76	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
77	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
78	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
79	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
80	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination	TIVC6
81	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
82	SPOSINMSP	☐	VVSPOSINMSP	VVSADJBASE	CHAR	1	0	Base value for grouping RU in RLR group
83	PPOSINMSP	☐	VVPPOSINMSP	DECV3_2	DEC	5	2	Percentage value for grouping RU in RLR category group
84	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
85	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
86	SGRUNDB	☐	SGRUNDB	SGRUNDB	NUMC	8	0	Land register number	VIGBUCH
87	PAUSFW	☐	VVPAUSFW	DEC3_2	DEC	5	2	Service charge stt. apport.loss risk percentage surcharge
88	RESADXEYECATCH	☐	RESADXEYECATCH	RESADXEYECATCH	CHAR	85	0	Short Description of Real Estate Object on Offer
89	RESADJINTERNET	☐	RESADJINTERNET	XFELD	CHAR	1	0	Indicator Internet Release
90	REFANG	☐	VVREFANG	RANL	CHAR	13	0	Reference offer	VIMI33
91	.INCLUDE	☐				0	0
92	.INCLU--AP	☐				0	0	OBSOLETE: Rental Object Append Fields
93	.INCLUDE	☐				0	0	OBSOLETE: Rental Object Append Fields
94	ROTYPE	☐	REBDROTYPE	REBDROTYPE	CHAR	2	0	Rental Object Type
95	ROTYPEEX	☐	REBDROTYPEEX	REBDROTYPEEX	CHAR	1	0	OBSOLETE: Type of Rental Object (External)
96	FLID	☐	REBDALTROID	REBDALTROID	CHAR	13	0	OBSOLETE: Alternative ID for Rental Object (from CRE)
97	CANBECOMMON	☐	REBDCANBECOMMON	RECABOOL	CHAR	1	0	Common Usage Possible
98	FIRSTPOSTING	☐	REBDFIRSTPOSTING	RECADATE	DATS	8	0	Obsolete: Date of First Posting
99	.INCLUDE	☐				0	0	OBSOLETE: Shared Master Data Fields: Append Fields
100	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
101	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
102	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
103	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	*
104	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	*
105	CFARCHIVEDTO	☐	RECDCFARCHIVEDTO	RECADATE	DATS	8	0	Date Up to Which the Cash Flow Is Archived
106	CFLOCKEDTO	☐	RECDCFLOCKEDTO	RECADATE	DATS	8	0	Date Until Which the Cash Flow Is Locked
107	XNUNRK	☐	XNUNRK	XKBEZ	CHAR	15	0	Short description of external usage type of rental unit
108	XNUNRM	☐	XNUNRM	XMBEZ	CHAR	30	0	Description of external usage type of rental unit
109	XBELA	☐	XBELA	AS4TEXT	CHAR	60	0	Description of occupancy type of rental unit
110	XHEIZ	☐	XHEIZ	AS4TEXT	CHAR	60	0	Description of heating type of rental unit
111	XGEBK	☐	XGEBK	XKBEZ	CHAR	15	0	Short name for parts of building
112	XGEBM	☐	XGEBM	XMBEZ	CHAR	30	0	Building parts long text
113	BBASI	☐	FVVIBBAS	WERTV6	CURR	11	2	Base amount
114	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
115	XAUSTKLL	☐	XAUSTKLL	XTEXT50	CHAR	50	0	Long text of fixture and fitting category
116	XLAGKM	☐	XLAGKM	XMBEZ	CHAR	30	0	Description of location class acc.to rep.list of rents
117	XMOEB	☐	XMOEB	AS4TEXT	CHAR	60	0	Description of furnished extent of rental unit
118	XKBELBEZ	☐	XKBELBEZ	XKBEZ	CHAR	15	0	Occupancy obligation short text
119	XMBELBEZ	☐	XMBELBEZ	XMBEZ	CHAR	30	0	Occupancy obligation name
120	XKMED	☐	XKMED	XKBEZ	CHAR	15	0	Media reception
121	XMMED	☐	XMMED	XMBEZ	CHAR	30	0	Media reception
122	XKWASSER	☐	XKWASSER	XKBEZ	CHAR	15	0	Short name: Type of water mains connection
123	XMWASSER	☐	XMWASSER	XMBEZ	CHAR	30	0	Long name: Type of water mains connection
124	XSTOCKK	☐	VVXSTOCKK	VVXSTOCKK	CHAR	4	0	Short name of floor
125	XSTOCKM	☐	XGKBEZ	XKBEZ	CHAR	15	0	Short Description for Floor
126	XSTOCKL	☐	XGMBEZ	XMBEZ	CHAR	30	0	Long Description for Floor
127	XKLGESCH	☐	XKLGESCH	XKBEZ	CHAR	15	0	Location in floor short name
128	XMLGESCH	☐	XMLGESCH	XMBEZ	CHAR	30	0	Location in floor long description
129	XSTOCKBISK	☐	XSTOCKBISK	VVXSTOCKK	CHAR	4	0	Short description of highest storey of RU
130	XSTOCKBISM	☐	XSTOCKBISM	XKBEZ	CHAR	15	0	Description of highest storey of RU
131	XSTOCKBISL	☐	XSTOCKBISL	XMBEZ	CHAR	30	0	Long text of highest storey in RU
132	SNUNRINT	☐	SNUNRINT	SNUNRINT	NUMC	2	0	Internal usage type	*
133	.INCLUDE	☐				0	0	Land Register Data Fields Part 1a
134	PARTNR	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	*
135	XGBVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
136	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
137	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
138	.INCLUDE	☐				0	0	Land Register Data Fields Part 1c
139	SGRBA	☐	SGRBA	SGRBA	NUMC	2	0	Land register type	*
140	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	*
141	.INCLUDE	☐				0	0	Land Register Data Fields Part 3
142	XGBAMT	☐	XGBAMT	XTEXT25	CHAR	25	0	Land registry ID
143	.INCLUDE	☐				0	0	Land Register Text Fields
144	XGRBAK	☐	XGRBAK	XKBEZ	CHAR	15	0	Short description of land register type
145	XGRBAM	☐	XGRBAM	XMBEZ	CHAR	30	0	Description of land register type
146	XGRBAL	☐	XGRBAL	XTEXT50	CHAR	50	0	Long Description of Land Register Type
147	XFEINSK	☐	XFEINSK	TEXT10	CHAR	10	0	Description of area unit
148	XFEINSL	☐	XFEINSL	TEXT30	CHAR	30	0	Description of area unit
149	.INCLUDE	☐				0	0	Structure with addit. fields for VIMI01 for corresp. in CH
150	DHPZSFROM	☐	VVDHPZSFRM	DATUM	DATS	8	0	Rent adj. CH: Valid-from date mortg.loan rate for curr.rent
151	PHPZSAKT	☐	VVPHPZSAKT	DEC2_3	DEC	5	3	Interest rate of mortgage loan on a specific date
152	DUTBKFROM	☐	VVDUTBKFRM	DATUM	DATS	8	0	Rent ad.CH: Valid-from date maintenance/OC index curr.rent
153	PUTBKAKT	☐	VVPUTBKAKT	DEC5_3	DEC	8	3	Change in maint./operating costs index in percentage points
154	DTEURFROM	☐	VVDTEURFRM	DATUM	DATS	8	0	Rent adj.CH: Valid-from date st.of living index current rent
155	PTEURAKT	☐	VVPTEURAKT	DEC5_3	DEC	8	3	Standard of living index point status on a date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RVIMI01_ZS	BUKRS	T001	BUKRS	KEY	1	CN
2	RVIMI01_ZS	GSBER	TGSB	GSBER	KEY	1	CN
3	RVIMI01_ZS	KOEIGR	TIVC6	KOEIGR
4	RVIMI01_ZS	KOKRS	TKA01	KOKRS	REF	C	CN
5	RVIMI01_ZS	PRCTR	CEPC	PRCTR	KEY	1	CN
6	RVIMI01_ZS	PROFL	TKB1A	APROF	REF	C	CN
7	RVIMI01_ZS	RBELBIND	TIV31	RBELBIND	KEY	1	CN
8	RVIMI01_ZS	REFANG	VIMI33	SMVANG	KEY	1	1
9	RVIMI01_ZS	RLGESCH	TIV38	RLGESCH	KEY	1	CN
10	RVIMI01_ZS	RLIFT	TIV32	RLIFT	KEY	1	CN
11	RVIMI01_ZS	RMEDIEN	TIV33	RMEDIEN	KEY	1	CN
12	RVIMI01_ZS	RPROZGRD	TIV43	RPROZGRD	KEY	1	CN
13	RVIMI01_ZS	RWASSER	TIV34	RWASSER	KEY	1	CN
14	RVIMI01_ZS	SADRME	SANO1	OBJNR	KEY	1	C
15	RVIMI01_ZS	SBWNR	VIMI11	SBWNR	KEY	1	CN
16	RVIMI01_ZS	SGEBSMENR	VIMI01	SMENR	KEY	1	CN
17	RVIMI01_ZS	SGEBSWENR	VIOB01	SWENR	KEY	1	CN
18	RVIMI01_ZS	SGEBT	TIV12	SGEBT	KEY	1	CN
19	RVIMI01_ZS	SGENR	VIOB03	SGENR	KEY	1	CN
20	RVIMI01_ZS	SGRNR	VIOB02	SGRNR	KEY	1	CN
21	RVIMI01_ZS	SGRUNDB	VIGBUCH	SGRUNDB	KEY	1	CN
22	RVIMI01_ZS	SNKS	ONR00	OBJNR	KEY	1	CN
23	RVIMI01_ZS	SNUNR	TIV01	SNUNR	REF	1	CN
24	RVIMI01_ZS	SSTCKBIS	TIV37	SSTOCKW	KEY	1	C
25	RVIMI01_ZS	SSTOCKW	TIV37	SSTOCKW	KEY	1	C
26	RVIMI01_ZS	SWENR	VIOB01	SWENR	KEY	1	CN
27	RVIMI01_ZS	XAUSTKL	TIV23	SMKLASS	KEY	1	CN
28	RVIMI01_ZS	XLAGE	TIV22	SLAGK	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in