SAP ABAP Table VIGW_R_VIMI01 (Immobilien gew.: Struktur Reporting Mieteinheiten)

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

Table Category	INTTAB	Structure
Structure	VIGW_R_VIMI01	Table Relationship Diagram
Short Description	Immobilien gew.: Struktur Reporting Mieteinheiten

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	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
2	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
3	SGEBSWENR	☐	SGEBSWENR	SWENR	CHAR	8	0	BE no.of rental unit to which the RU is linked	*
4	SGEBSMENR	☐	SGEBSMENR	SMENR	CHAR	8	0	RU no. of rental unit to which the RU is linked	*
5	SHEIZNR	☐	SHEIZNR	SHEIZNR	NUMC	4	0	Real Estate heating system number
6	SNUNR	☐	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
7	DBEZU	☐	DBEZU	DDAT	DATS	8	0	Date of initial usage
8	DWTVERM	☐	DWTVERM	DATUM	DATS	8	0	Date: Subsequent rental
9	UMBRAUM	☐	BUBRA	DEC8_3	DEC	11	3	Cubic Volume
10	AZIMM	☐	AZIMM	DEC3	DEC	3	0	Number of rooms
11	AHALBZI	☐	AHALBZI	DEC2	DEC	2	0	Number of half rooms
12	STOCK	☐	RGESCH	CHAR2	CHAR	2	0	Dummy (previously storey, replaced by VVSSTOCKW)
13	SBELART	☐	SBELA	SBELA	NUMC	1	0	Occupancy type indicator
14	SHEIZART	☐	SHEIZ	SHEIZ	CHAR	1	0	Heating type
15	DRESAB	☐	DRESA	DDAT	DATS	8	0	Date: Reserved from
16	DRESBIS	☐	DRESB	DDAT	DATS	8	0	Date: Reserved upto
17	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
18	SBWNR	☐	SBWNR	SBWNR	NUMC	7	0	Application number	VIMI11
19	XAUSTKL	☐	SAUSKL	SAUSKL	NUMC	2	0	Fixtures and fittings category	*
20	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	*
21	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
22	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
23	DBEGEH	☐	DBEGEH	DDAT	DATS	8	0	Date of last RU inspection
24	XBEGEH	☐	XBEGEH	XKBEZ	CHAR	15	0	Inspected by
25	PZUABSP	☐	PZUABSP	PZUABSP	DEC	4	2	Surcharge or reduction for representative list of rents
26	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
27	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
28	DBINDBIS	☐	DBINDBIS	DATUM	DATS	8	0	Obligation period until
29	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
30	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
31	RLIFT	☐	RLIFT	RLIFT	NUMC	2	0	Type of elevator installation	TIV32
32	RMEDIEN	☐	RMEDIEN	RMEDIEN	NUMC	3	0	Media reception	TIV33
33	RWASSER	☐	RWASSER	RWASSER	NUMC	2	0	Type of water mains connection	TIV34
34	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
35	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
36	SADRME	☐	SADRME	SOBJNR	NUMC	10	0	Object number of rental unit for address purposes	*
37	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
38	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
39	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
40	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
41	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
42	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
43	DFSTRBIS	☐	VVDFSTRBIS	DATUM	DATS	8	0	Date up to when the rental unit cash flow is created
44	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
45	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
46	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
47	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
48	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
49	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
50	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
51	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit
52	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*
53	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGW_R_VIMI01	RBELBIND	TIV31	RBELBIND
2	VIGW_R_VIMI01	RLGESCH	TIV38	RLGESCH
3	VIGW_R_VIMI01	RLIFT	TIV32	RLIFT
4	VIGW_R_VIMI01	RMEDIEN	TIV33	RMEDIEN
5	VIGW_R_VIMI01	RPROZGRD	TIV43	RPROZGRD
6	VIGW_R_VIMI01	RWASSER	TIV34	RWASSER
7	VIGW_R_VIMI01	SBWNR	VIMI11	SBWNR
8	VIGW_R_VIMI01	SGEBT	TIV12	SGEBT
9	VIGW_R_VIMI01	SNUNR	TIV01	SNUNR		1	CN
10	VIGW_R_VIMI01	SSTCKBIS	TIV37	SSTOCKW
11	VIGW_R_VIMI01	SSTOCKW	TIV37	SSTOCKW

History

Last changed by/on	SAP	20110901
SAP Release Created in