SAP ABAP Table VREDB_VIMIMV_01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VREDB_VIMIMV_01	Table Relationship Diagram
Short Description	Generated Table for View

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	T001
3	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
4	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit	VIMI01
5	SMIVE	☑	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
6	INTRENO	☑	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
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	DUNTBIS	☐	DUNBI	DDAT	DATS	8	0	Date provisional agreement from
16	BKAUTION	☐	BKAUT	WRTV7	CURR	13	2	Security deposit amount
17	SKAUTART	☐	SKAUA	SKAUA	CHAR	1	0	Type of Rental Collateral	TIV18
18	DEINKUE	☐	DEKUE	DDAT	DATS	8	0	Date of receipt of notice
19	DKUEZU	☐	DKUZU	DDAT	DATS	8	0	Contract Notice Per
20	JMAHNSP	☐	JMASP	JANE	CHAR	1	0	Dunning block indicator - no longer used!
21	STECHEM	☐	STECHEM	STECHEM	CHAR	13	0	Heating expenses settlement company evaluation group
22	JMINDER	☐	JMINDER	JANEI	CHAR	1	0	Rent reduction indicator
23	AMELDIN	☐	AMELDIN	INTVJ	NUMC	2	0	Sales reporting interval
24	BUMSPROJ	☐	BUMSPRNUSD	WRTV7	CURR	13	2	not used (copy of BUMSPROJ)
25	BMINUMS	☐	BUMS1NUSD	WRTV7	CURR	13	2	not used (copy of BUMSATZ1)
26	PPROZ0	☐	PPROZ0	DEC3_2	DEC	5	2	Minimum percentage rate
27	DSTAEN	☐	DSTAEN	DSTAEN	DATS	8	0	Status change date
28	DAKTV	☐	DAKTV	DATUM	DATS	8	0	Contract activation
29	JLOESCH	☐	JLOESCH	JLOESCH	CHAR	1	0	Real Estate Deletion Indicator/Flag
30	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
31	JVERL	☐	JVERL	VVVERL	CHAR	1	0	Contract renewal
32	JSKUEND	☐	JSKUEND	JANEI	CHAR	1	0	Special right of notice
33	JKAUFOPT	☐	JKAUFOPT	JANEI	CHAR	1	0	Option to buy
34	DKAUFOPT	☐	DKAUFOPT	DDAT	DATS	8	0	Purchase option date
35	SNKS	☐	SNKS	J_OBJNR	CHAR	22	0	Service Charge Collector Number	ONR00
36	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
37	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
38	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
39	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
40	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
41	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
42	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
43	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
44	DKUEFR	☐	DKUEFR	NUMC2	NUMC	2	0	Notice period in months
45	ANKUEN	☐	ANKUEN	NUMC2	NUMC	2	0	Notification until (for renewal of contract)
46	DABTR	☐	DABTR	DATUM	DATS	8	0	Declaration of assignment
47	DFREIS	☐	DFREIS	DATUM	DATS	8	0	Exemption (bank)
48	DABLF	☐	DABLF	DATUM	DATS	8	0	Expiration Date
49	VERLG	☐	VERLG	NUMC3	NUMC	3	0	Contract renewal by ... months
50	ZSICH	☐	VVZSICH	JANEI	CHAR	1	0	Indicator that other collateral is available
51	JBETRST	☐	JBETRST	JANEI	CHAR	1	0	Security deposit granted
52	DBKERH	☐	DBKERH	DATUM	DATS	8	0	Cash deposit received on
53	ABNNR	☐	ABNNR	TEXT20	CHAR	20	0	Identification of lease-out at settlement company
54	ABNUNR	☐	ABNUNR	NUM3	NUMC	3	0	Customer subnumber
55	BANKKS	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
56	SKUEFR	☐	SKUEFR	SKUEFR	NUMC	1	0	Type of notice period
57	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
58	KUNNR	☐	VVRDEBIHVP	KUNNR	CHAR	10	0	Customer number main contract partner	KNA1
59	SPARTNR	☐	VVRPARTABW	SPARTNR	CHAR	10	0	Alternative payer (partner number)	SPRT1
60	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
61	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
62	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
63	JBKRZ	☐	VVJBKRZ	JANEI	CHAR	1	0	Cash deposit instalment payment
64	DEINZG	☐	VVDEINZG	DATS	DATS	8	0	Move-in date
65	DAUSZG	☐	VVDAUSZG	DATS	DATS	8	0	Move-out date
66	JANPIB	☐	VVJANPIB	JANE	CHAR	1	0	Adjustment being processed (indicator)
67	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
68	MABER	☐	VVMABER	MABER	CHAR	2	0	Dunning: area	T047M
69	PROFL	☐	VVAPROF	APROF	CHAR	6	0	Settlement profile for costs	TKB1A
70	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
71	ZUSP	☐	VVZUSP	JANE	CHAR	1	0	Subsidies available, indicator
72	REFNR	☐	VVREFNR	TEXT30	CHAR	30	0	Reference number for collateral securities
73	SBELEGNG	☐	VVSBELEGNG	VVSBELEGNG	CHAR	1	0	RU occupancy by LO (used by third-prty/private/corp.grp)
74	MANSP	☐	VVMANSP	MANSP	CHAR	1	0	Dunning: Blocking reason	T040S
75	DERSTDR	☐	VVDERSTDR	DATUM	DATS	8	0	Date When the Lease-Out was First Printed
76	DAENDDR	☐	VVDAENDDR	DATUM	DATS	8	0	Date When the Lease-Out was Changed and Printed Out
77	JMFREI	☐	VVJMFREI	JANE	CHAR	1	0	Condition is not checked
78	DVMUN	☐	VVDVMUN	DATUM	DATS	8	0	Contract signed by landlord
79	JRMSCHPR	☐	VVJRMSCHPR	XFELD	CHAR	1	0	Tenant service charge settlement?
80	TDNAME	☐	TDOBNAME	TDOBNAME	CHAR	70	0	Name
81	KBK_PARTNR	☐	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
82	GERSTD	☐	VVXGERSTD	TEXT35	CHAR	35	0	Jurisdiction
83	KONDPJ	☐	VVKONDPJ	JFLAGG	CHAR	1	0	Conditions on lease-out effective per year (display)
84	JMABGR	☐	VVJMABGR	JFLAGG	CHAR	1	0	Accrual/deferral method
85	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
86	SKUEKEY	☐	SKUEKEY	SKUEKEY	CHAR	12	0	Notice rule
87	SKUEART	☐	SMVKUEART	SMVKUEART	CHAR	1	0	Notice Type of Lease-Out
88	E_SMIVE	☐	VVESMIVE	VVSMIVE	CHAR	13	0	Contract No. of Collective Lease-Outs
89	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
90	FEHLBEL	☐	VVFEHLBEL	VVFEHLBEL	CHAR	20	0	Reference code false occupancy charges
91	R1DATUM	☐	VVR1DATUM	DATUM	DATS	8	0	1st date for vacating
92	R2DATUM	☐	VVR2DATUM	DATUM	DATS	8	0	2nd date for vacating
93	KLDATUM	☐	VVKLDATUM	DATUM	DATS	8	0	Date of complaint
94	KLAKTZEI	☐	VVKLAKTZEI	CHAR20	CHAR	20	0	Complaint reference code
95	IND_SECTOR	☐	VVMVINDSEC	BRSCH	CHAR	4	0	Industry of master tenant	T016
96	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
97	DFLOWFIX	☐	VVDFLOWFIX	DATUM	DATS	8	0	Flows fixed upto
98	KOEIGR	☐	VVWERTN_AD	VVWERTN_AD	CHAR	10	0	Account determination key for account determination	TIVC6
99	BERGRP	☐	VVBERGRP	VVBERGRP	CHAR	40	0	Authorization group
100	KONTOBV	☐	VVIKONTOBV	VVIKONTOBV	CHAR	10	0	Bank procedure account number
101	OSMIVE	☐	VVOSMIVE	VVOSMIVE	CHAR	20	0	Number of old contract
102	SDUNMOD	☐	VVRAMAHNVERF	CHAR004	CHAR	4	0	Dunning level for dunning of non-approved rent adjustments	TIVM7
103	CORRGROUP	☐	VVCORRGROUP	VVCORRGROUP	CHAR	20	0	Correspondence group	TIVCORRGRP
104	PARTFROM	☐	VVIPARTFROM	CHAR4	CHAR	4	0	Source of Prospect	TIVP1
105	PARTWHY	☐	VVIPARTWHY	CHAR4	CHAR	4	0	Reason for Acquisition	TIVP2
106	PARTWAY	☐	VVIWAY	CHAR4	CHAR	4	0	Enquiry method	TIVP3

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VREDB_VIMIMV_01	BUKRS	T001	BUKRS	KEY	1	CN
2	VREDB_VIMIMV_01	BUSAB	T001S	BUSAB	REF	1	CN
3	VREDB_VIMIMV_01	CORRGROUP	TIVCORRGRP	CORRGROUP	KEY	1	CN
4	VREDB_VIMIMV_01	GSART	TZPA	GSART	KEY	1	CN
5	VREDB_VIMIMV_01	GSBER	TGSB	GSBER	KEY	1	CN
6	VREDB_VIMIMV_01	HBKID	T012	HBKID
7	VREDB_VIMIMV_01	IND_SECTOR	T016	BRSCH
8	VREDB_VIMIMV_01	KBK_PARTNR	SPRT1	PARTNR	KEY	1	CN
9	VREDB_VIMIMV_01	KOEIGR	TIVC6	KOEIGR	KEY	1	CN
10	VREDB_VIMIMV_01	KOKRS	TKA01	KOKRS	REF	C	CN
11	VREDB_VIMIMV_01	KUNNR	KNA1	KUNNR	KEY	1	CN
12	VREDB_VIMIMV_01	MABER	T047M	MABER	KEY	1	CN
13	VREDB_VIMIMV_01	MANSP	T040S	MANSP	KEY	1	CN
14	VREDB_VIMIMV_01	PARTFROM	TIVP1	PARTFROM	KEY	1	CN
15	VREDB_VIMIMV_01	PARTWAY	TIVP3	WAY	KEY	1	CN
16	VREDB_VIMIMV_01	PARTWHY	TIVP2	PARTWHY	KEY	1	CN
17	VREDB_VIMIMV_01	PRCTR	CEPC	PRCTR	KEY	1	CN
18	VREDB_VIMIMV_01	PROFL	TKB1A	APROF	REF	C	CN
19	VREDB_VIMIMV_01	SDUNMOD	TIVM7	SDUNMOD	KEY	1	CN
20	VREDB_VIMIMV_01	SKAUTART	TIV18	SKAUTART	KEY	1	CN
21	VREDB_VIMIMV_01	SMENR	VIMI01	SMENR	KEY	1	CN
22	VREDB_VIMIMV_01	SMVANART	TIV27	SMVANART	KEY	1	CN
23	VREDB_VIMIMV_01	SMVART	TIV26	SMVART	KEY	1	CN
24	VREDB_VIMIMV_01	SNKS	ONR00	OBJNR	KEY	1	CN
25	VREDB_VIMIMV_01	SPARTNR	SPRT1	PARTNR	KEY	1	CN
26	VREDB_VIMIMV_01	SWENR	VIOB01	SWENR	KEY	1	CN
27	VREDB_VIMIMV_01	VERKT_ME	VIMI01	SMENR	KEY	1	CN
28	VREDB_VIMIMV_01	VERKT_WE	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in