SAP ABAP Table VMVSTAT (Generated Table for View)

Basic Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in