SAP ABAP Table VIMI04_ZUS (Structure with fields from VIMI04 and addit.fields)

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	INTTAB	Structure
Structure	VIMI04_ZUS	Table Relationship Diagram
Short Description	Structure with fields from VIMI04 and addit.fields

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in