SAP ABAP Table VIGW_R_VIMVF (Immobilien gew.: Reporting Mieteinheiten/Mietvertrag Sticht.)

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_VIMVF	Table Relationship Diagram
Short Description	Immobilien gew.: Reporting Mieteinheiten/Mietvertrag Sticht.

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	*
3	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
4	SMENR	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
5	.INCLUDE	☐				0	0	Immobilien gew.: Struktur Reporting Mieteinheiten
6	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	*
7	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	*
8	SGEBSWENR	☐	SGEBSWENR	SWENR	CHAR	8	0	BE no.of rental unit to which the RU is linked	*
9	SGEBSMENR	☐	SGEBSMENR	SMENR	CHAR	8	0	RU no. of rental unit to which the RU is linked	*
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	*
25	XLAGE	☐	SLAGK	SLAGK	NUMC	2	0	Location class	*
26	SMOEBL	☐	SMOEB	SMOEB	CHAR	1	0	Furniture indicator
27	SALTNR	☐	SALTNR	SALTNR	CHAR	20	0	Number of rental unit in existing real estate system
28	DBEGEH	☐	DBEGEH	DDAT	DATS	8	0	Date of last RU inspection
29	XBEGEH	☐	XBEGEH	XKBEZ	CHAR	15	0	Inspected by
30	PZUABSP	☐	PZUABSP	PZUABSP	DEC	4	2	Surcharge or reduction for representative list of rents
31	PERHOE	☐	PERHOE	DEC3_2	DEC	5	2	Percentage rate increase
32	RPROZGRD	☐	RPROZGRD	RPROZGRD	CHAR	2	0	Reason for variance in rate of percentage increase	TIV43
33	DBINDBIS	☐	DBINDBIS	DATUM	DATS	8	0	Obligation period until
34	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
35	RBELBIND	☐	RBELBIND	RBELBIND	CHAR	4	0	Occupancy obligation key	TIV31
36	RLIFT	☐	RLIFT	RLIFT	NUMC	2	0	Type of elevator installation	TIV32
37	RMEDIEN	☐	RMEDIEN	RMEDIEN	NUMC	3	0	Media reception	TIV33
38	RWASSER	☐	RWASSER	RWASSER	NUMC	2	0	Type of water mains connection	TIV34
39	RLGESCH	☐	RLGESCH	RLGESCH	CHAR	2	0	Location on Floor	TIV38
40	JVORSTEIG	☐	JVORSTEIG	OPTIERT	CHAR	1	0	Input tax deduction for vacancy
41	SADRME	☐	SADRME	SOBJNR	NUMC	10	0	Object number of rental unit for address purposes	*
42	XSTANDNR	☐	VVXSTANDNR	VVXSTANDNR	CHAR	5	0	Number of garage / parking space
43	JEIGWOHN	☐	VVJEIGWOHN	JANE	CHAR	1	0	Rental Unit in Separate Ownership (COA)
44	RFAKT	☐	VVRFAKT	VVRFAKT	NUMC	6	0	Conversion factor for fractional share of property
45	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
46	JKONDMV	☐	VVJKONDMV	XFELD	CHAR	1	0	Transfer conditions to RU when lease-out expires?
47	PKONDMV	☐	VVPKONDMV	PRZ32	DEC	5	2	Percentage rate for transfer of terms from LO to RU
48	DFSTRBIS	☐	VVDFSTRBIS	DATUM	DATS	8	0	Date up to when the rental unit cash flow is created
49	SSTCKBIS	☐	VVSSTCKBIS	VVSSTOCKW	NUMC	3	0	For RUs with Multiple Floors: Top Floor of RU	TIV37
50	DHPZSAKT	☐	VVDHPZSAKT	DATUM	DATS	8	0	CH rent adj.:Date of mort.loan rate status for current rent
51	DUTBKAKT	☐	VVDUTBKAKT	DATUM	DATS	8	0	CH rnt adj.:Dte maint./oper.costs index status for new rent
52	DTEURAKT	☐	VVDTEURAKT	DATUM	DATS	8	0	CH rnt adj.:Dte of living stndrd index status for curr.rent
53	BRDBRTZZ	☐	VVBRDBRTZZ	DECV3_7	DEC	10	7	CH rent adj: Actual gross yield earned
54	BRDBRTKD	☐	VVBRDBRTKD	DECV3_7	DEC	10	7	Marginal Gross Yield
55	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
56	XMETXT	☐	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit
57	SBASTEU	☐	VVSBASTEU	BASJHR	NUMC	4	0	Swiss rent adj.: Base year for standard of living index	*
58	DRESTAUR	☐	VVDRESTAUR	DATUM	DATS	8	0	Date of reconstruction/extensive modernization
59	.INCLUDE	☐				0	0	Immobilien gew.: VIMIMV
60	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
61	VERKT_MV	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
62	VERKT_WE	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	*
63	VERKT_ME	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	*
64	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
65	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
66	DERZAHL	☐	DERZA	DDAT	DATS	8	0	Date of 1st debit position
67	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
68	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
69	DUNTBIS	☐	DUNBI	DDAT	DATS	8	0	Date provisional agreement from
70	BKAUTION	☐	BKAUT	WRTV7	CURR	13	2	Security deposit amount
71	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	TIV18
72	DEINKUE	☐	DEKUE	DDAT	DATS	8	0	Date of receipt of notice
73	DKUEZU	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
74	JMAHNSP	☐	JMASP	JANE	CHAR	1	0	Dunning block indicator - no longer used!
75	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
76	JMINDER	☐	JMINDER	JANEI	CHAR	1	0	Rent reduction indicator
77	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
78	BUMSPROJ	☐	BUMSPRNUSD	WRTV7	CURR	13	2	not used (copy of BUMSPROJ)
79	BMINUMS	☐	BUMS1NUSD	WRTV7	CURR	13	2	not used (copy of BUMSATZ1)
80	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
81	DSTAEN	☐	DSTAEN	DSTAEN	DATS	8	0	Status change date
82	DAKTV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
83	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
84	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
85	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
86	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
87	JKAUFOPT	☐	JKAUFOPT	JANEI	CHAR	1	0	Option to buy
88	DKAUFOPT	☐	DKAUFOPT	DDAT	DATS	8	0	Purchase option date
89	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	*
90	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
91	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
92	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
93	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
94	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
95	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
96	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
97	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
98	DKUEFR	☐	DKUEFR	NUMC2	NUMC	2	0	Notice period in months
99	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
100	DABTR	☐	DABTR	DATUM	DATS	8	0	Declaration of assignment
101	DFREIS	☐	DFREIS	DATUM	DATS	8	0	Exemption (bank)
102	DABLF	☐	DABLF	DATUM	DATS	8	0	Expiration Date
103	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
104	ZSICH	☐	VVZSICH	JANEI	CHAR	1	0	Indicator that other collateral is available
105	JBETRST	☐	JBETRST	JANEI	CHAR	1	0	Security deposit granted
106	DBKERH	☐	DBKERH	DATUM	DATS	8	0	Cash deposit received on
107	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
108	ABNUNR	☐	ABNUNR	NUM3	NUMC	3	0	Customer subnumber
109	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
110	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
111	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
112	KUNNR	☐	VVRDEBIHVP	KUNNR	CHAR	10	0	Customer number main contract partner	KNA1
113	SPARTNR	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	SPRT1
114	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
115	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
116	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
117	JBKRZ	☐	VVJBKRZ	JANEI	CHAR	1	0	Cash deposit instalment payment
118	DEINZG	☐	VVDEINZG	DATS	DATS	8	0	Move-in date
119	DAUSZG	☐	VVDAUSZG	DATS	DATS	8	0	Move-out date
120	JANPIB	☐	VVJANPIB	JANE	CHAR	1	0	Adjustment being processed (indicator)
121	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
122	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
123	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
124	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
125	ZUSP	☐	VVZUSP	JANE	CHAR	1	0	Subsidies available, indicator
126	REFNR	☐	VVREFNR	TEXT30	CHAR	30	0	Reference number for collateral securities
127	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
128	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
129	DERSTDR	☐	VVDERSTDR	DATUM	DATS	8	0	Date When the Lease-Out was First Printed
130	DAENDDR	☐	VVDAENDDR	DATUM	DATS	8	0	Date When the Lease-Out was Changed and Printed Out
131	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
132	DVMUN	☐	VVDVMUN	DATUM	DATS	8	0	Contract signed by landlord
133	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
134	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
135	KBK_PARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
136	GERSTD	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
137	KONDPJ	☐	VVKONDPJ	JFLAGG	CHAR	1	0	Conditions on lease-out effective per year (display)
138	JMABGR	☐	VVJMABGR	JFLAGG	CHAR	1	0	Accrual/deferral method
139	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
140	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
141	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
142	E_SMIVE	☐	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
143	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
144	FEHLBEL	☐	VVFEHLBEL	VVFEHLBEL	CHAR	20	0	Reference code false occupancy charges
145	R1DATUM	☐	VVR1DATUM	DATUM	DATS	8	0	1st date for vacating
146	R2DATUM	☐	VVR2DATUM	DATUM	DATS	8	0	2nd date for vacating
147	KLDATUM	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
148	KLAKTZEI	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
149	IND_SECTOR	☐	VVMVINDSEC	BRSCH	CHAR	4	0	Industry of master tenant	T016
150	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
151	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
152	.INCLUDE	☐				0	0	Immobilien gew.: VIGWOBJZU (Teil)
153	INTRENO_MFL	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
154	DGUELAB	☐	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
155	DGUELBIS	☐	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
156	FLG_LME	☐	VIGWFLGLME	JANE	CHAR	1	0	Flag zugeordnete Mieteinheit ist eine Leerstands-ME
157	GFLFAK	☐	VIGWGFLNUFAK	VIGWGFLNUFAK	QUAN	12	2	Nutzungsanteil(%%) je Mieter bei Gemeinsch.Räumen u.-Flächen
158	GFAKEH	☐	VIGWGFNFAKEH	VIGWQPROMILLE	UNIT	2	0
159	AUTOTYP	☐	VIGWGFAUTOTYP	VIGWZUAUTOTYP	CHAR	1	0	Rolle der Zuordnung bei autom. Kalkulation Nutzungsfaktoren

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIGW_R_VIMVF	GSART	TZPA	GSART
2	VIGW_R_VIMVF	GSBER	TGSB	GSBER
3	VIGW_R_VIMVF	IND_SECTOR	T016	BRSCH
4	VIGW_R_VIMVF	KBK_PARTNR	SPRT1	PARTNR
5	VIGW_R_VIMVF	KOKRS	TKA01	KOKRS
6	VIGW_R_VIMVF	KUNNR	KNA1	KUNNR
7	VIGW_R_VIMVF	MANSP	T040S	MANSP
8	VIGW_R_VIMVF	PRCTR	CEPC	PRCTR
9	VIGW_R_VIMVF	PROFL	TKB1A	APROF
10	VIGW_R_VIMVF	RBELBIND	TIV31	RBELBIND
11	VIGW_R_VIMVF	RLGESCH	TIV38	RLGESCH
12	VIGW_R_VIMVF	RLIFT	TIV32	RLIFT
13	VIGW_R_VIMVF	RMEDIEN	TIV33	RMEDIEN
14	VIGW_R_VIMVF	RPROZGRD	TIV43	RPROZGRD
15	VIGW_R_VIMVF	RWASSER	TIV34	RWASSER
16	VIGW_R_VIMVF	SBWNR	VIMI11	SBWNR
17	VIGW_R_VIMVF	SGEBT	TIV12	SGEBT
18	VIGW_R_VIMVF	SKAUTART	TIV18	SKAUTART
19	VIGW_R_VIMVF	SMVANART	TIV27	SMVANART
20	VIGW_R_VIMVF	SMVART	TIV26	SMVART
21	VIGW_R_VIMVF	SNUNR	TIV01	SNUNR		1	CN
22	VIGW_R_VIMVF	SPARTNR	SPRT1	PARTNR
23	VIGW_R_VIMVF	SSTCKBIS	TIV37	SSTOCKW
24	VIGW_R_VIMVF	SSTOCKW	TIV37	SSTOCKW

History

Last changed by/on	SAP	20110901
SAP Release Created in