SAP ABAP Table VVIMI01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VVIMI01	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
4	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit
5	SMIVE	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in