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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in