ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Real Estate Management
1	ERP EHP7	6.0	VIMIMV	106	7	Lease-Out	Real Estate Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
3	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
4	SMIVE	Lease-Out Number	nvarchar	13	0	Allow NULL?
5	SWENR	Site Number	nvarchar	8	0	Allow NULL?
6	SMENR	Number of Rental Unit	nvarchar	8	0	Allow NULL?
7	VERKT_MV	Lease-Out Number	nvarchar	13	0	Allow NULL?
8	VERKT_WE	Site Number	nvarchar	8	0	Allow NULL?
9	VERKT_ME	Number of Rental Unit	nvarchar	8	0	Allow NULL?
10	DMIBEG	Rental start date	nvarchar	8	0	Allow NULL?
11	DMIEND	Rental end date	nvarchar	8	0	Allow NULL?
12	DERZAHL	Date of 1st debit position	nvarchar	8	0	Allow NULL?
13	SMVART	External Real Estate contract type	nvarchar	4	0	Allow NULL?
14	SMVANART	Lease-Out Adjustment Type	char	1	0	Allow NULL?
15	DUNTBIS	Date provisional agreement from	nvarchar	8	0	Allow NULL?
16	BKAUTION	Security deposit amount	decimal	13	2
17	SKAUTART	Type of Rental Collateral	char	1	0	Allow NULL?
18	DEINKUE	Date of receipt of notice	nvarchar	8	0	Allow NULL?
19	DKUEZU	Contract Notice Per	nvarchar	8	0	Allow NULL?
20	JMAHNSP	Dunning block indicator - no longer used!	char	1	0	Allow NULL?
21	STECHEM	Heating expenses settlement company evaluation group	nvarchar	13	0	Allow NULL?
22	JMINDER	Rent reduction indicator	char	1	0	Allow NULL?
23	AMELDIN	Sales reporting interval	nvarchar	2	0	Allow NULL?
24	BUMSPROJ	not used (copy of BUMSPROJ)	decimal	13	2
25	BMINUMS	not used (copy of BUMSATZ1)	decimal	13	2
26	PPROZ0	Minimum percentage rate	decimal	5	2
27	DSTAEN	Status change date	nvarchar	8	0	Allow NULL?
28	DAKTV	Contract activation	nvarchar	8	0	Allow NULL?
29	JLOESCH	Real Estate Deletion Indicator/Flag	char	1	0	Allow NULL?
30	BUSAB	Accounting clerk	nvarchar	2	0	Allow NULL?
31	JVERL	Contract renewal	char	1	0	Allow NULL?
32	JSKUEND	Special right of notice	char	1	0	Allow NULL?
33	JKAUFOPT	Option to buy	char	1	0	Allow NULL?
34	DKAUFOPT	Purchase option date	nvarchar	8	0	Allow NULL?
35	SNKS	Service Charge Collector Number	nvarchar	22	0	Allow NULL?
36	RERF	Entered by	nvarchar	12	0	Allow NULL?
37	DERF	First Entered on	nvarchar	8	0	Allow NULL?
38	TERF	Time of Initial Entry	nvarchar	6	0	Allow NULL?
39	REHER	Source of initial entry	nvarchar	10	0	Allow NULL?
40	RBEAR	Employee ID	nvarchar	12	0	Allow NULL?
41	DBEAR	Last Edited on	nvarchar	8	0	Allow NULL?
42	TBEAR	Last Edited at	nvarchar	6	0	Allow NULL?
43	RBHER	Editing Source	nvarchar	10	0	Allow NULL?
44	DKUEFR	Notice period in months	nvarchar	2	0	Allow NULL?
45	ANKUEN	Notification until (for renewal of contract)	nvarchar	2	0	Allow NULL?
46	DABTR	Declaration of assignment	nvarchar	8	0	Allow NULL?
47	DFREIS	Exemption (bank)	nvarchar	8	0	Allow NULL?
48	DABLF	Expiration Date	nvarchar	8	0	Allow NULL?
49	VERLG	Contract renewal by ... months	nvarchar	3	0	Allow NULL?
50	ZSICH	Indicator that other collateral is available	char	1	0	Allow NULL?
51	JBETRST	Security deposit granted	char	1	0	Allow NULL?
52	DBKERH	Cash deposit received on	nvarchar	8	0	Allow NULL?
53	ABNNR	Identification of lease-out at settlement company	nvarchar	20	0	Allow NULL?
54	ABNUNR	Customer subnumber	nvarchar	3	0	Allow NULL?
55	BANKKS	Bank Keys	nvarchar	15	0	Allow NULL?
56	SKUEFR	Type of notice period	char	1	0	Allow NULL?
57	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
58	KUNNR	Customer number main contract partner	nvarchar	10	0	Allow NULL?
59	SPARTNR	Alternative payer (partner number)	nvarchar	10	0	Allow NULL?
60	GSART	Product Type	nvarchar	3	0	Allow NULL?
61	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
62	MANST	Dunning level	char	1	0	Allow NULL?
63	JBKRZ	Cash deposit instalment payment	char	1	0	Allow NULL?
64	DEINZG	Move-in date	nvarchar	8	0	Allow NULL?
65	DAUSZG	Move-out date	nvarchar	8	0	Allow NULL?
66	JANPIB	Adjustment being processed (indicator)	char	1	0	Allow NULL?
67	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
68	MABER	Dunning: area	nvarchar	2	0	Allow NULL?
69	PROFL	Settlement profile for costs	nvarchar	6	0	Allow NULL?
70	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
71	ZUSP	Subsidies available, indicator	char	1	0	Allow NULL?
72	REFNR	Reference number for collateral securities	nvarchar	30	0	Allow NULL?
73	SBELEGNG	RU occupancy by LO (used by third-prty/private/corp.grp)	char	1	0	Allow NULL?
74	MANSP	Dunning: Blocking reason	char	1	0	Allow NULL?
75	DERSTDR	Date When the Lease-Out was First Printed	nvarchar	8	0	Allow NULL?
76	DAENDDR	Date When the Lease-Out was Changed and Printed Out	nvarchar	8	0	Allow NULL?
77	JMFREI	Condition is not checked	char	1	0	Allow NULL?
78	DVMUN	Contract signed by landlord	nvarchar	8	0	Allow NULL?
79	JRMSCHPR	Tenant service charge settlement?	char	1	0	Allow NULL?
80	TDNAME	Name	nvarchar	70	0	Allow NULL?
81	KBK_PARTNR	Partner number	nvarchar	10	0	Allow NULL?
82	GERSTD	Jurisdiction	nvarchar	35	0	Allow NULL?
83	KONDPJ	Conditions on lease-out effective per year (display)	char	1	0	Allow NULL?
84	JMABGR	Accrual/deferral method	char	1	0	Allow NULL?
85	GSBER	Business Area	nvarchar	4	0	Allow NULL?
86	SKUEKEY	Notice rule	nvarchar	12	0	Allow NULL?
87	SKUEART	Notice Type of Lease-Out	char	1	0	Allow NULL?
88	E_SMIVE	Contract No. of Collective Lease-Outs	nvarchar	13	0	Allow NULL?
89	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
90	FEHLBEL	Reference code false occupancy charges	nvarchar	20	0	Allow NULL?
91	R1DATUM	1st date for vacating	nvarchar	8	0	Allow NULL?
92	R2DATUM	2nd date for vacating	nvarchar	8	0	Allow NULL?
93	KLDATUM	Date of complaint	nvarchar	8	0	Allow NULL?
94	KLAKTZEI	Complaint reference code	nvarchar	20	0	Allow NULL?
95	IND_SECTOR	Industry of master tenant	nvarchar	4	0	Allow NULL?
96	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
97	DFLOWFIX	Flows fixed upto	nvarchar	8	0	Allow NULL?
98	KOEIGR	Account determination key for account determination	nvarchar	10	0	Allow NULL?
99	BERGRP	Authorization group	nvarchar	40	0	Allow NULL?
100	KONTOBV	Bank procedure account number	nvarchar	10	0	Allow NULL?
101	OSMIVE	Number of old contract	nvarchar	20	0	Allow NULL?
102	SDUNMOD	Dunning level for dunning of non-approved rent adjustments	nvarchar	4	0	Allow NULL?
103	CORRGROUP	Correspondence group	nvarchar	20	0	Allow NULL?
104	PARTFROM	Source of Prospect	nvarchar	4	0	Allow NULL?
105	PARTWHY	Reason for Acquisition	nvarchar	4	0	Allow NULL?
106	PARTWAY	Enquiry method	nvarchar	4	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VIMIMV~0	Yes	Yes	CLUSTERED	MANDT, INTRENO
VIMIMV~1	No	No	NONCLUSTERED	MANDT, IMKEY
VIMIMV~2	No	No	NONCLUSTERED	BUKRS, SWENR, SMENR
VIMIMV~3	No	No	NONCLUSTERED	BUKRS, SMIVE
VIMIMV~4	No	No	NONCLUSTERED	SNKS
VIMIMV~EMV	No	No	NONCLUSTERED	E_SMIVE
VIMIMV~KTO	No	No	NONCLUSTERED	KONTOBV

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

106 COLUMNS | 7 INDEXES | ERP 6.0 | VIMIMV TABLE

TOP ERP 6.0 | VIMIMV COLUMNS

TOP ERP 6.0 | VIMIMV INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

106 COLUMNS | 7 INDEXES | ERP 6.0 | VIMIMV TABLE

TOPERP 6.0 | VIMIMV COLUMNS

TOPERP 6.0 | VIMIMV INDEXES

TOP ERP 6.0 | VIMIMV COLUMNS

TOP ERP 6.0 | VIMIMV INDEXES