SAP ABAP View VIGW_V_MEFL (View of Rental Unit to Areas/Room Zones)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

View Type	D	Database View
Database View	VIGW_V_MEFL
Short Description	View of Rental Unit to Areas/Room Zones
Root table	VIMI01	Rental unit - Master data

Table

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

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	VIGWOBJZU	MANDT	JR	EQ			AND	0	0
3	VIMI01	INTRENO	JL	EQ				0	0
4	VIGWOBJZU	INTRENO2	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	SGRNR	VIMI01	SGRNR		☐	SGRNR	☐	Land Number for BE
6	SGENR	VIMI01	SGENR		☐	SGENR	☐	Building Number
7	SGEBSWENR	VIMI01	SGEBSWENR		☐	SGEBSWENR	☐	BE no.of rental unit to which the RU is linked
8	SGEBSMENR	VIMI01	SGEBSMENR		☐	SGEBSMENR	☐	RU no. of rental unit to which the RU is linked
9	SHEIZNR	VIMI01	SHEIZNR		☐	SHEIZNR	☐	Real Estate heating system number
10	SNUNR	VIMI01	SNUNR		☐	SNUNR	☐	Rental unit external usage type
11	DBEZU	VIMI01	DBEZU		☐	DBEZU	☐	Date of initial usage
12	DWTVERM	VIMI01	DWTVERM		☐	DWTVERM	☐	Date: Subsequent rental
13	UMBRAUM	VIMI01	UMBRAUM		☐	BUBRA	☐	Cubic Volume
14	AZIMM	VIMI01	AZIMM		☐	AZIMM	☐	Number of rooms
15	AHALBZI	VIMI01	AHALBZI		☐	AHALBZI	☐	Number of half rooms
16	STOCK	VIMI01	STOCK		☐	RGESCH	☐	Dummy (previously storey, replaced by VVSSTOCKW)
17	SBELART	VIMI01	SBELART		☐	SBELA	☐	Occupancy type indicator
18	SHEIZART	VIMI01	SHEIZART		☐	SHEIZ	☐	Heating type
19	DRESAB	VIMI01	DRESAB		☐	DRESA	☐	Date: Reserved from
20	DRESBIS	VIMI01	DRESBIS		☐	DRESB	☐	Date: Reserved upto
21	SGEBT	VIMI01	SGEBT		☐	SGEBT	☐	Part of Building
22	SBWNR	VIMI01	SBWNR		☐	SBWNR	☐	Application number
23	XAUSTKL	VIMI01	XAUSTKL		☐	SAUSKL	☐	Fixtures and fittings category
24	XLAGE	VIMI01	XLAGE		☐	SLAGK	☐	Location class
25	SMOEBL	VIMI01	SMOEBL		☐	SMOEB	☐	Furniture indicator
26	STECHEM	VIMI01	STECHEM		☐	STECHEM	☐	Heating expenses settlement company evaluation group
27	SALTNR	VIMI01	SALTNR		☐	SALTNR	☐	Number of rental unit in existing real estate system
28	DBEGEH	VIMI01	DBEGEH		☐	DBEGEH	☐	Date of last RU inspection
29	XBEGEH	VIMI01	XBEGEH		☐	XBEGEH	☐	Inspected by
30	JLOESCH	VIMI01	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
31	PZUABSP	VIMI01	PZUABSP		☐	PZUABSP	☐	Surcharge or reduction for representative list of rents
32	PERHOE	VIMI01	PERHOE		☐	PERHOE	☐	Percentage rate increase
33	RPROZGRD	VIMI01	RPROZGRD		☐	RPROZGRD	☐	Reason for variance in rate of percentage increase
34	DBINDBIS	VIMI01	DBINDBIS		☐	DBINDBIS	☐	Obligation period until
35	KOSTL	VIMI01	KOSTL		☐	KOSTL	☐	Cost Center
36	RBELBIND	VIMI01	RBELBIND		☐	RBELBIND	☐	Occupancy obligation key
37	RLIFT	VIMI01	RLIFT		☐	RLIFT	☐	Type of elevator installation
38	RMEDIEN	VIMI01	RMEDIEN		☐	RMEDIEN	☐	Media reception
39	RWASSER	VIMI01	RWASSER		☐	RWASSER	☐	Type of water mains connection
40	RLGESCH	VIMI01	RLGESCH		☐	RLGESCH	☐	Location on Floor
41	JVORSTEIG	VIMI01	JVORSTEIG		☐	JVORSTEIG	☐	Input tax deduction for vacancy
42	SADRME	VIMI01	SADRME		☐	SADRME	☐	Object number of rental unit for address purposes
43	SNKS	VIMI01	SNKS		☐	SNKS	☐	Service Charge Collector Number
44	IMKEY	VIMI01	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
45	RERF	VIMI01	RERF		☐	RERF	☐	Entered by
46	DERF	VIMI01	DERF		☐	DERF	☐	First Entered on
47	TERF	VIMI01	TERF		☐	TERF	☐	Time of Initial Entry
48	REHER	VIMI01	REHER		☐	REHER	☐	Source of initial entry
49	RBEAR	VIMI01	RBEAR		☐	RBEAR	☐	Employee ID
50	DBEAR	VIMI01	DBEAR		☐	DBEAR	☐	Last Edited on
51	TBEAR	VIMI01	TBEAR		☐	TBEAR	☐	Last Edited at
52	RBHER	VIMI01	RBHER		☐	RBHER	☐	Editing Source
53	ABNNR	VIMI01	ABNNR		☐	ABNNR	☐	Identification of lease-out at settlement company
54	XSTANDNR	VIMI01	XSTANDNR		☐	VVXSTANDNR	☐	Number of garage / parking space
55	JEIGWOHN	VIMI01	JEIGWOHN		☐	VVJEIGWOHN	☐	Rental Unit in Separate Ownership (COA)
56	RFAKT	VIMI01	RFAKT		☐	VVRFAKT	☐	Conversion factor for fractional share of property
57	PRCTR	VIMI01	PRCTR		☐	PRCTR	☐	Profit Center
58	PROFL	VIMI01	PROFL		☐	VVAPROF	☐	Settlement profile for costs
59	KOKRS	VIMI01	KOKRS		☐	KOKRS	☐	Controlling Area
60	SSTOCKW	VIMI01	SSTOCKW		☐	VVSSTOCKW	☐	Floor
61	JKONDMV	VIMI01	JKONDMV		☐	VVJKONDMV	☐	Transfer conditions to RU when lease-out expires?
62	PKONDMV	VIMI01	PKONDMV		☐	VVPKONDMV	☐	Percentage rate for transfer of terms from LO to RU
63	DFSTRBIS	VIMI01	DFSTRBIS		☐	VVDFSTRBIS	☐	Date up to when the rental unit cash flow is created
64	SSTCKBIS	VIMI01	SSTCKBIS		☐	VVSSTCKBIS	☐	For RUs with Multiple Floors: Top Floor of RU
65	JRMSCHPR	VIMI01	JRMSCHPR		☐	VVJRMSCHPR	☐	Tenant service charge settlement?
66	DHPZSAKT	VIMI01	DHPZSAKT		☐	VVDHPZSAKT	☐	CH rent adj.:Date of mort.loan rate status for current rent
67	DUTBKAKT	VIMI01	DUTBKAKT		☐	VVDUTBKAKT	☐	CH rnt adj.:Dte maint./oper.costs index status for new rent
68	DTEURAKT	VIMI01	DTEURAKT		☐	VVDTEURAKT	☐	CH rnt adj.:Dte of living stndrd index status for curr.rent
69	BRDBRTZZ	VIMI01	BRDBRTZZ		☐	VVBRDBRTZZ	☐	CH rent adj: Actual gross yield earned
70	BRDBRTKD	VIMI01	BRDBRTKD		☐	VVBRDBRTKD	☐	Marginal Gross Yield
71	INTRENO	VIMI01	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
72	XMETXT	VIMI01	XMETXT		☐	VVXMETXT2	☐	Text for rental unit
73	SBASTEU	VIMI01	SBASTEU		☐	VVSBASTEU	☐	Swiss rent adj.: Base year for standard of living index
74	GSBER	VIMI01	GSBER		☐	GSBER	☐	Business Area
75	DRESTAUR	VIMI01	DRESTAUR		☐	VVDRESTAUR	☐	Date of reconstruction/extensive modernization
76	TXJCD	VIMI01	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
77	DFLOWFIX	VIMI01	DFLOWFIX		☐	VVDFLOWFIX	☐	Flows fixed upto
78	INTRENO_FL	VIGWOBJZU	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
79	DGUELBIS	VIGWOBJZU	DGUELBIS		☐	VIGWZUBIS	☐
80	VERSION	VIGWOBJZU	VERSION		☐	VIGWSVERSION	☐	Version Indicator
81	DGUELAB	VIGWOBJZU	DGUELAB		☐	VIGWZUAB	☐

Maintenance Status

Access

☑   read only

☐   read and change

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

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in