SAP ABAP Table VIMI04 (Old. replaced in 3.0 with VIMIMV)

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

Table Category	TRANSP	Transparent table
Transparent table	VIMI04	Table Relationship Diagram
Short Description	Old. replaced in 3.0 with VIMIMV

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T001
3	SMIVE	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
4	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
5	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
6	VERKT_MV	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
7	VERKT_WE	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
8	VERKT_ME	☐	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
9	DMIBEG	☐	DMIBE	DDAT	DATS	8	0	Rental start date
10	DMIEND	☐	DMIEN	DDAT	DATS	8	0	Rental end date
11	DERZAHL	☐	DERZA	DDAT	DATS	8	0	Date of 1st debit position
12	SMVART	☐	SMVART	SMVART	CHAR	4	0	External Real Estate contract type	TIV26
13	SMVANART	☐	SMVAR	SMVAR	CHAR	1	0	Lease-Out Adjustment Type	TIV27
14	AINST	☐	AINST	DEC02	DEC	2	0	Lease-out interval status debit position
15	JMITA	☐	JMITA	JANEI	CHAR	1	0	Employee indicator
16	XMITNR	☐	XMITNR	XMBEZ	CHAR	30	0	Employee Number in Lease-Out
17	JKONZERN	☐	JKONZ	JKONZ	NUMC	2	0	Corporate group ID types	TIV28
18	DUNTBIS	☐	DUNBI	DDAT	DATS	8	0	Date provisional agreement from
19	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
20	BKAUTION	☐	BKAUT	WRTV7	CURR	13	2	Security deposit amount
21	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	TIV18
22	DEINKUE	☐	DEKUE	DDAT	DATS	8	0	Date of receipt of notice
23	DKUEZU	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
24	SKUEART	☐	SKUAR	SKUAR	CHAR	1	0	Notice Type
25	XKUEGRU	☐	XKUGR	XMBEZ	CHAR	30	0	Reason for notice
26	JMAHNSP	☐	JMASP	JANE	CHAR	1	0	Dunning block indicator - no longer used!
27	DANPS	☐	DANPS	DATUM	DATS	8	0	Adjustment block as from
28	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
29	JRECHT	☐	JRECHT	JANEI	CHAR	1	0	Court case indicator
30	ASCHLU1	☐	ASCHLU1	DEC03	DEC	3	0	Number of keys 1
31	JMINDER	☐	JMINDER	JANEI	CHAR	1	0	Rent reduction indicator
32	DMINDER	☐	DMINDER	DDAT	DATS	8	0	Date rent reduction introduced
33	DMINDAB	☐	DMINDAB	DDAT	DATS	8	0	Rent reduction as from
34	JRATEN	☐	JRATEN	JANEI	CHAR	1	0	Instalment indicator
35	BGESRATE	☐	BGESRATE	DEC8_2	DEC	10	2	Total of the instalments still to be paid for the cash bond
36	BRATE	☐	BRATE	DEC8_2	DEC	10	2	Instalment amount
37	DERSTRAT	☐	DERSTRAT	DDAT	DATS	8	0	Date of first instalment payment
38	BSUMMRAT	☐	BSUMMRAT	DEC8_2	DEC	10	2	Total of instalments paid so far
39	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
40	BUMSPROJ	☐	BUMSPROJ	WRTV7	CURR	13	2	Planned sales (Amount)
41	BMINUMS	☐	BUMSATZ1	WRTV7	CURR	13	2	Monetary minimum sales in the settlement period
42	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
43	STAMV	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
44	STALT	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
45	DSTAEN	☐	DSTAEN	DSTAEN	DATS	8	0	Status change date
46	DAKTV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
47	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
48	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
49	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
50	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
51	JKAUFOPT	☐	JKAUFOPT	JANEI	CHAR	1	0	Option to buy
52	DKAUFOPT	☐	DKAUFOPT	DDAT	DATS	8	0	Purchase option date
53	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
54	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
55	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
56	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
57	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
58	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
59	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
60	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
61	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
62	DKUEFR	☐	DKUEFR	NUMC2	NUMC	2	0	Notice period in months
63	DMIETF	☐	DMIETF	DATUM	DATS	8	0	Adjustment block until
64	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
65	DABTR	☐	DABTR	DATUM	DATS	8	0	Declaration of assignment
66	DFREIS	☐	DFREIS	DATUM	DATS	8	0	Exemption (bank)
67	DABLF	☐	DABLF	DATUM	DATS	8	0	Expiration Date
68	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
69	ZUGHK	☐	VVZUGHK	VVZUGHK	NUMC	2	0	Employee	TIV30
70	ZSICH	☐	VVZSICH	JANEI	CHAR	1	0	Indicator that other collateral is available
71	JBETRST	☐	JBETRST	JANEI	CHAR	1	0	Security deposit granted
72	DBKERH	☐	DBKERH	DATUM	DATS	8	0	Cash deposit received on
73	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
74	ABNUNR	☐	ABNUNR	NUM3	NUMC	3	0	Customer subnumber
75	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
76	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
77	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
78	KUNNR	☐	VVRDEBIHVP	KUNNR	CHAR	10	0	Customer number main contract partner	KNA1
79	SPARTNR	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	SPRT1
80	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
81	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
82	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
83	JBKRZ	☐	VVJBKRZ	JANEI	CHAR	1	0	Cash deposit instalment payment
84	DEINZG	☐	VVDEINZG	DATS	DATS	8	0	Move-in date
85	DAUSZG	☐	VVDAUSZG	DATS	DATS	8	0	Move-out date
86	JANPIB	☐	VVJANPIB	JANE	CHAR	1	0	Adjustment being processed (indicator)
87	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
88	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
89	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
90	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
91	ZUSP	☐	VVZUSP	JANE	CHAR	1	0	Subsidies available, indicator
92	REFNR	☐	VVREFNR	TEXT30	CHAR	30	0	Reference number for collateral securities
93	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
94	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
95	DERSTDR	☐	VVDERSTDR	DATUM	DATS	8	0	Date When the Lease-Out was First Printed
96	DAENDDR	☐	VVDAENDDR	DATUM	DATS	8	0	Date When the Lease-Out was Changed and Printed Out
97	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
98	DVMUN	☐	VVDVMUN	DATUM	DATS	8	0	Contract signed by landlord
99	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
100	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
101	KBK_PARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
102	GERSTD	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
103	NITRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIMI04	BRSCH	T016	BRSCH	REF	1	CN
2	VIMI04	BUKRS	T001	BUKRS	KEY	1	CN
3	VIMI04	BUSAB	T001S	BUSAB	REF	1	CN
4	VIMI04	GSART	TZPA	GSART	KEY	1	CN
5	VIMI04	JKONZERN	TIV28	JKONZERN	REF	1	CN
6	VIMI04	KBK_PARTNR	SPRT1	PARTNR	KEY	1	CN
7	VIMI04	KOKRS	TKA01	KOKRS	REF	C	CN
8	VIMI04	KUNNR	KNA1	KUNNR	KEY	1	CN
9	VIMI04	MABER	T047M	MABER	KEY	1	CN
10	VIMI04	MANSP	T040S	MANSP	KEY	1	CN
11	VIMI04	PRCTR	CEPC	PRCTR	KEY	1	CN
12	VIMI04	PROFL	TKB1A	APROF	REF	C	CN
13	VIMI04	SKAUTART	TIV18	SKAUTART	KEY	1	CN
14	VIMI04	SMENR	VIMI01	SMENR	KEY	1	CN
15	VIMI04	SMVANART	TIV27	SMVANART	KEY	1	CN
16	VIMI04	SMVART	TIV26	SMVART	KEY	1	CN
17	VIMI04	SNKS	ONR00	OBJNR	KEY	1	CN
18	VIMI04	SPARTNR	SPRT1	PARTNR	KEY	1	CN
19	VIMI04	SWENR	VIOB01	SWENR	KEY	1	CN
20	VIMI04	VERKT_ME	VIMI01	SMENR	KEY	1	CN
21	VIMI04	VERKT_WE	VIOB01	SWENR	KEY	1	CN
22	VIMI04	ZUGHK	TIV30	ZUGHK	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in