SAP ABAP View VMVSTAT (View of VIMIMV (lease-out) with status)

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

View Type	D	Database View
Database View	VMVSTAT
Short Description	View of VIMIMV (lease-out) with status
Root table	VIMIMV	Lease-Out

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIMIMV	VIMIMV
2	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIMIMV	MANDT	JL	EQ				0	0
2	JEST	MANDT	JR	EQ			AND	0	0
3	VIMIMV	SNKS	JL	EQ				0	0
4	JEST	OBJNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VIMIMV	MANDT		☐	MANDT	☐	Client
2	INTRENO	VIMIMV	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
3	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
4	BUKRS	VIMIMV	BUKRS		☐	BUKRS	☐	Company Code
5	SMIVE	VIMIMV	SMIVE		☐	SMIVE	☐	Lease-Out Number
6	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
7	SWENR	VIMIMV	SWENR		☐	SWENR	☐	Business Entity Number
8	SMENR	VIMIMV	SMENR		☐	SMENR	☐	Number of Rental Unit
9	VERKT_MV	VIMIMV	VERKT_MV		☐	SMIVE	☐	Lease-Out Number
10	VERKT_WE	VIMIMV	VERKT_WE		☐	SWENR	☐	Business Entity Number
11	VERKT_ME	VIMIMV	VERKT_ME		☐	SMENR	☐	Number of Rental Unit
12	DMIBEG	VIMIMV	DMIBEG		☐	DMIBE	☐	Rental start date
13	DMIEND	VIMIMV	DMIEND		☐	DMIEN	☐	Rental end date
14	DERZAHL	VIMIMV	DERZAHL		☐	DERZA	☐	Date of 1st debit position
15	SMVART	VIMIMV	SMVART		☐	SMVART	☐	External Real Estate contract type
16	SMVANART	VIMIMV	SMVANART		☐	SMVAR	☐	Lease-Out Adjustment Type
17	DUNTBIS	VIMIMV	DUNTBIS		☐	DUNBI	☐	Date provisional agreement from
18	BKAUTION	VIMIMV	BKAUTION		☐	BKAUT	☐	Security deposit amount
19	SKAUTART	VIMIMV	SKAUTART		☐	SKAUA	☐	Type of Rental Collateral
20	DEINKUE	VIMIMV	DEINKUE		☐	DEKUE	☐	Date of receipt of notice
21	DKUEZU	VIMIMV	DKUEZU		☐	DKUZU	☐	Contract Notice Per
22	JMAHNSP	VIMIMV	JMAHNSP		☐	JMASP	☐	Dunning block indicator - no longer used!
23	STECHEM	VIMIMV	STECHEM		☐	STECHEM	☐	Heating expenses settlement company evaluation group
24	JMINDER	VIMIMV	JMINDER		☐	JMINDER	☐	Rent reduction indicator
25	AMELDIN	VIMIMV	AMELDIN		☐	AMELDIN	☐	Sales reporting interval
26	BUMSPROJ	VIMIMV	BUMSPROJ		☐	BUMSPRNUSD	☐	not used (copy of BUMSPROJ)
27	BMINUMS	VIMIMV	BMINUMS		☐	BUMS1NUSD	☐	not used (copy of BUMSATZ1)
28	PPROZ0	VIMIMV	PPROZ0		☐	PPROZ0	☐	Minimum percentage rate
29	DSTAEN	VIMIMV	DSTAEN		☐	DSTAEN	☐	Status change date
30	DAKTV	VIMIMV	DAKTV		☐	DAKTV	☐	Contract activation
31	JLOESCH	VIMIMV	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
32	BUSAB	VIMIMV	BUSAB		☐	BUSAB	☐	Accounting clerk
33	JVERL	VIMIMV	JVERL		☐	JVERL	☐	Contract renewal
34	JSKUEND	VIMIMV	JSKUEND		☐	JSKUEND	☐	Special right of notice
35	JKAUFOPT	VIMIMV	JKAUFOPT		☐	JKAUFOPT	☐	Option to buy
36	DKAUFOPT	VIMIMV	DKAUFOPT		☐	DKAUFOPT	☐	Purchase option date
37	SNKS	VIMIMV	SNKS		☐	SNKS	☐	Service Charge Collector Number
38	RERF	VIMIMV	RERF		☐	RERF	☐	Entered by
39	DERF	VIMIMV	DERF		☐	DERF	☐	First Entered on
40	TERF	VIMIMV	TERF		☐	TERF	☐	Time of Initial Entry
41	REHER	VIMIMV	REHER		☐	REHER	☐	Source of initial entry
42	RBEAR	VIMIMV	RBEAR		☐	RBEAR	☐	Employee ID
43	DBEAR	VIMIMV	DBEAR		☐	DBEAR	☐	Last Edited on
44	TBEAR	VIMIMV	TBEAR		☐	TBEAR	☐	Last Edited at
45	RBHER	VIMIMV	RBHER		☐	RBHER	☐	Editing Source
46	DKUEFR	VIMIMV	DKUEFR		☐	DKUEFR	☐	Notice period in months
47	ANKUEN	VIMIMV	ANKUEN		☐	ANKUEN	☐	Notification until (for renewal of contract)
48	DABTR	VIMIMV	DABTR		☐	DABTR	☐	Declaration of assignment
49	DFREIS	VIMIMV	DFREIS		☐	DFREIS	☐	Exemption (bank)
50	DABLF	VIMIMV	DABLF		☐	DABLF	☐	Expiration Date
51	VERLG	VIMIMV	VERLG		☐	VERLG	☐	Contract renewal by ... months
52	ZSICH	VIMIMV	ZSICH		☐	VVZSICH	☐	Indicator that other collateral is available
53	JBETRST	VIMIMV	JBETRST		☐	JBETRST	☐	Security deposit granted
54	DBKERH	VIMIMV	DBKERH		☐	DBKERH	☐	Cash deposit received on
55	ABNNR	VIMIMV	ABNNR		☐	ABNNR	☐	Identification of lease-out at settlement company
56	ABNUNR	VIMIMV	ABNUNR		☐	ABNUNR	☐	Customer subnumber
57	BANKKS	VIMIMV	BANKKS		☐	BANKK	☐	Bank Keys
58	SKUEFR	VIMIMV	SKUEFR		☐	SKUEFR	☐	Type of notice period
59	IMKEY	VIMIMV	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
60	KUNNR	VIMIMV	KUNNR		☐	VVRDEBIHVP	☐	Customer number main contract partner
61	SPARTNR	VIMIMV	SPARTNR		☐	VVRPARTABW	☐	Alternative payer (partner number)
62	GSART	VIMIMV	GSART		☐	VVSART	☐	Product Type
63	MADAT	VIMIMV	MADAT		☐	MADAT	☐	Date of Last Dunning Notice
64	MANST	VIMIMV	MANST		☐	MAHNS_D	☐	Dunning Level
65	JBKRZ	VIMIMV	JBKRZ		☐	VVJBKRZ	☐	Cash deposit instalment payment
66	DEINZG	VIMIMV	DEINZG		☐	VVDEINZG	☐	Move-in date
67	DAUSZG	VIMIMV	DAUSZG		☐	VVDAUSZG	☐	Move-out date
68	JANPIB	VIMIMV	JANPIB		☐	VVJANPIB	☐	Adjustment being processed (indicator)
69	PRCTR	VIMIMV	PRCTR		☐	PRCTR	☐	Profit Center
70	MABER	VIMIMV	MABER		☐	VVMABER	☐	Dunning: area
71	PROFL	VIMIMV	PROFL		☐	VVAPROF	☐	Settlement profile for costs
72	KOKRS	VIMIMV	KOKRS		☐	KOKRS	☐	Controlling Area
73	ZUSP	VIMIMV	ZUSP		☐	VVZUSP	☐	Subsidies available, indicator
74	REFNR	VIMIMV	REFNR		☐	VVREFNR	☐	Reference number for collateral securities
75	SBELEGNG	VIMIMV	SBELEGNG		☐	VVSBELEGNG	☐	RU occupancy by LO (used by third-prty/private/corp.grp)
76	MANSP	VIMIMV	MANSP		☐	VVMANSP	☐	Dunning: Blocking reason
77	DERSTDR	VIMIMV	DERSTDR		☐	VVDERSTDR	☐	Date When the Lease-Out was First Printed
78	DAENDDR	VIMIMV	DAENDDR		☐	VVDAENDDR	☐	Date When the Lease-Out was Changed and Printed Out
79	JMFREI	VIMIMV	JMFREI		☐	VVJMFREI	☐	Condition is not checked
80	DVMUN	VIMIMV	DVMUN		☐	VVDVMUN	☐	Contract signed by landlord
81	JRMSCHPR	VIMIMV	JRMSCHPR		☐	VVJRMSCHPR	☐	Tenant service charge settlement?
82	TDNAME	VIMIMV	TDNAME		☐	TDOBNAME	☐	Name
83	KBK_PARTNR	VIMIMV	KBK_PARTNR		☐	SPARTNR	☐	Partner number
84	GERSTD	VIMIMV	GERSTD		☐	VVXGERSTD	☐	Jurisdiction
85	E_SMIVE	VIMIMV	E_SMIVE		☐	VVESMIVE	☐	Contract No. of Collective Lease-Outs

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in