SAP ABAP View VVIMI01 (View via VIMI01 with lease number from VIMI04)

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

View Type	D	Database View
Database View	VVIMI01
Short Description	View via VIMI01 with lease number from VIMI04
Root table	VIMI01	Rental unit - Master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIMI01	VIMI01
2	VIMI04

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIMI01	MANDT	JL	EQ				0	0
2	VIMI04	MANDT	JR	EQ			AND	0	0
3	VIMI01	BUKRS	JL	EQ				0	0
4	VIMI04	BUKRS	JR	EQ			AND	0	0
5	VIMI01	SWENR	JL	EQ				0	0
6	VIMI04	SWENR	JR	EQ			AND	0	0
7	VIMI01	SMENR	JL	EQ				0	0
8	VIMI04	SMENR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VIMI01	MANDT		☐	MANDT	☐	Client
2	BUKRS	VIMI01	BUKRS		☐	BUKRS	☐	Company Code
3	SWENR	VIMI01	SWENR		☐	SWENR	☐	Business Entity Number
4	SMENR	VIMI01	SMENR		☐	SMENR	☐	Number of Rental Unit
5	SMIVE	VIMI04	SMIVE		☐	SMIVE	☐	Lease-Out Number
6	SGRNR	VIMI01	SGRNR		☐	SGRNR	☐	Land Number for BE
7	SGENR	VIMI01	SGENR		☐	SGENR	☐	Building Number
8	SGEBSWENR	VIMI01	SGEBSWENR		☐	SGEBSWENR	☐	BE no.of rental unit to which the RU is linked
9	SGEBSMENR	VIMI01	SGEBSMENR		☐	SGEBSMENR	☐	RU no. of rental unit to which the RU is linked
10	SHEIZNR	VIMI01	SHEIZNR		☐	SHEIZNR	☐	Real Estate heating system number
11	SNUNR	VIMI01	SNUNR		☐	SNUNR	☐	Rental unit external usage type
12	DBEZU	VIMI01	DBEZU		☐	DBEZU	☐	Date of initial usage
13	DWTVERM	VIMI01	DWTVERM		☐	DWTVERM	☐	Date: Subsequent rental
14	UMBRAUM	VIMI01	UMBRAUM		☐	BUBRA	☐	Cubic Volume
15	AZIMM	VIMI01	AZIMM		☐	AZIMM	☐	Number of rooms
16	AHALBZI	VIMI01	AHALBZI		☐	AHALBZI	☐	Number of half rooms
17	STOCK	VIMI01	STOCK		☐	RGESCH	☐	Dummy (previously storey, replaced by VVSSTOCKW)
18	SBELART	VIMI01	SBELART		☐	SBELA	☐	Occupancy type indicator
19	SHEIZART	VIMI01	SHEIZART		☐	SHEIZ	☐	Heating type
20	DRESAB	VIMI01	DRESAB		☐	DRESA	☐	Date: Reserved from
21	DRESBIS	VIMI01	DRESBIS		☐	DRESB	☐	Date: Reserved upto
22	SGEBT	VIMI01	SGEBT		☐	SGEBT	☐	Part of Building
23	SBWNR	VIMI01	SBWNR		☐	SBWNR	☐	Application number
24	XAUSTKL	VIMI01	XAUSTKL		☐	SAUSKL	☐	Fixtures and fittings category
25	XLAGE	VIMI01	XLAGE		☐	SLAGK	☐	Location class
26	SMOEBL	VIMI01	SMOEBL		☐	SMOEB	☐	Furniture indicator
27	STECHEM	VIMI01	STECHEM		☐	STECHEM	☐	Heating expenses settlement company evaluation group
28	SALTNR	VIMI01	SALTNR		☐	SALTNR	☐	Number of rental unit in existing real estate system
29	DBEGEH	VIMI01	DBEGEH		☐	DBEGEH	☐	Date of last RU inspection
30	XBEGEH	VIMI01	XBEGEH		☐	XBEGEH	☐	Inspected by
31	JLOESCH	VIMI01	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
32	PZUABSP	VIMI01	PZUABSP		☐	PZUABSP	☐	Surcharge or reduction for representative list of rents
33	PERHOE	VIMI01	PERHOE		☐	PERHOE	☐	Percentage rate increase
34	RPROZGRD	VIMI01	RPROZGRD		☐	RPROZGRD	☐	Reason for variance in rate of percentage increase
35	DBINDBIS	VIMI01	DBINDBIS		☐	DBINDBIS	☐	Obligation period until
36	KOSTL	VIMI01	KOSTL		☐	KOSTL	☐	Cost Center
37	RBELBIND	VIMI01	RBELBIND		☐	RBELBIND	☐	Occupancy obligation key
38	RLIFT	VIMI01	RLIFT		☐	RLIFT	☐	Type of elevator installation
39	RMEDIEN	VIMI01	RMEDIEN		☐	RMEDIEN	☐	Media reception
40	RWASSER	VIMI01	RWASSER		☐	RWASSER	☐	Type of water mains connection
41	RLGESCH	VIMI01	RLGESCH		☐	RLGESCH	☐	Location on Floor
42	JVORSTEIG	VIMI01	JVORSTEIG		☐	JVORSTEIG	☐	Input tax deduction for vacancy
43	SADRME	VIMI01	SADRME		☐	SADRME	☐	Object number of rental unit for address purposes
44	SNKS	VIMI01	SNKS		☐	SNKS	☐	Service Charge Collector Number
45	IMKEY	VIMI01	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
46	RERF	VIMI01	RERF		☐	RERF	☐	Entered by
47	DERF	VIMI01	DERF		☐	DERF	☐	First Entered on
48	TERF	VIMI01	TERF		☐	TERF	☐	Time of Initial Entry
49	REHER	VIMI01	REHER		☐	REHER	☐	Source of initial entry
50	RBEAR	VIMI01	RBEAR		☐	RBEAR	☐	Employee ID
51	DBEAR	VIMI01	DBEAR		☐	DBEAR	☐	Last Edited on
52	TBEAR	VIMI01	TBEAR		☐	TBEAR	☐	Last Edited at
53	RBHER	VIMI01	RBHER		☐	RBHER	☐	Editing Source
54	ABNNR	VIMI01	ABNNR		☐	ABNNR	☐	Identification of lease-out at settlement company
55	XSTANDNR	VIMI01	XSTANDNR		☐	VVXSTANDNR	☐	Number of garage / parking space
56	JEIGWOHN	VIMI01	JEIGWOHN		☐	VVJEIGWOHN	☐	Rental Unit in Separate Ownership (COA)
57	RFAKT	VIMI01	RFAKT		☐	VVRFAKT	☐	Conversion factor for fractional share of property
58	PRCTR	VIMI01	PRCTR		☐	PRCTR	☐	Profit Center
59	PROFL	VIMI01	PROFL		☐	VVAPROF	☐	Settlement profile for costs
60	KOKRS	VIMI01	KOKRS		☐	KOKRS	☐	Controlling Area
61	SSTOCKW	VIMI01	SSTOCKW		☐	VVSSTOCKW	☐	Floor

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	S	System table, maint. only by SAP, change = modification
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in