SAP ABAP Table RVIMI01 (Structure for rental unit - Real estate)

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	Table Relationship Diagram
Short Description	Structure for rental unit - Real estate

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in