SAP ABAP Table VIGW_R_VIMVF03 (Immobilien gew.: Mieteinheiten / Mietvertrag)

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

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

History

Last changed by/on	SAP	20110901
SAP Release Created in