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	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
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
Production Planning and Control :: Material Requirements Planning :: Master Data
1	ERP EHP7	6.0	MDKP	98	2	Header Data for MRP Document	Master Data

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DTART	Type of MRP list	nvarchar	2	0	Allow NULL?
3	MATNR	Material Number	nvarchar	18	0	Allow NULL?
4	PLWRK	Plant	nvarchar	4	0	Allow NULL?
5	PLSCN	Planning Scenario of Long-Term Planning	nvarchar	3	0	Allow NULL?
6	DTNUM	Number of material requirements planning table	nvarchar	10	0	Allow NULL?
7	DSDAT	MRP date	nvarchar	8	0	Allow NULL?
8	BDBKZ	Selection indicator for processed MRP lists	char	1	0	Allow NULL?
9	SLKZ1	Selection indicator for exception groups	char	1	0	Allow NULL?
10	SLKZ2	Selection indicator for exception groups	char	1	0	Allow NULL?
11	SLKZ3	Selection indicator for exception groups	char	1	0	Allow NULL?
12	SLKZ4	Selection indicator for exception groups	char	1	0	Allow NULL?
13	SLKZ5	Selection indicator for exception groups	char	1	0	Allow NULL?
14	SLKZ6	Selection indicator for exception groups	char	1	0	Allow NULL?
15	SLKZ7	Selection indicator for exception groups	char	1	0	Allow NULL?
16	SLKZ8	Selection indicator for exception groups	char	1	0	Allow NULL?
17	VRKZ1	Processing indicator 01	char	1	0	Allow NULL?
18	VRKZ2	Processing indicator 02	char	1	0	Allow NULL?
19	VRKZ3	Processing indicator - 03	char	1	0	Allow NULL?
20	MTART	Material Type	nvarchar	4	0	Allow NULL?
21	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
22	DISST	Low-Level Code	nvarchar	3	0	Allow NULL?
23	BESKZ	Procurement Type	char	1	0	Allow NULL?
24	SOBSL	Special procurement type	nvarchar	2	0	Allow NULL?
25	SOBES	Special procurement type	char	1	0	Allow NULL?
26	WRK02	Planning/production plant	nvarchar	4	0	Allow NULL?
27	DISMM	MRP Type	nvarchar	2	0	Allow NULL?
28	DISVF	MRP procedure	char	1	0	Allow NULL?
29	DISPO	MRP Controller (Materials Planner)	nvarchar	3	0	Allow NULL?
30	PLDIS	Planning controller (no longer used)	nvarchar	3	0	Allow NULL?
31	EKGRP	Purchasing Group	nvarchar	3	0	Allow NULL?
32	MTWZT	Material replenishment lead time	decimal	3	0
33	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0
34	BEAZT	Processing time for purchase order proposal	decimal	3	0
35	FIXTR	End of planning time fence (date)	nvarchar	8	0	Allow NULL?
36	MFHKZ	Planning time fence set manually (MFXDT)	char	1	0	Allow NULL?
37	DISLS	Lot size (materials planning)	nvarchar	2	0	Allow NULL?
38	LOSVF	Lot-sizing procedure for short-term period	char	1	0	Allow NULL?
39	LOSKZ	Lot-size indicator for the short-term period	char	1	0	Allow NULL?
40	PERAZ	Number of periods for the short-term area	decimal	3	0
41	EISBE	Safety Stock	decimal	13	3
42	MINBE	Reorder Point	decimal	13	3
43	HOEBE	Maximum stock level	decimal	13	3
44	BSTMI	Minimum Lot Size	decimal	13	3
45	BSTMA	Maximum Lot Size	decimal	13	3
46	BSTFX	Fixed lot size	decimal	13	3
47	BSTRF	Rounding value for purchase order quantity	decimal	13	3
48	SUM01	Plant stock / only plant segment	decimal	13	3
49	SUM02	No longer used/do not use!!	decimal	13	3
50	SUM03	No longer used/do not use!!	decimal	13	3
51	SUM04	No longer used/do not use!!	decimal	13	3
52	SUM05	No longer used/do not use!!	decimal	13	3
53	NEGBS	Negative stock	decimal	13	3
54	MSGID	Message identification	nvarchar	20	0	Allow NULL?
55	MSGAR	Message Type	char	1	0	Allow NULL?
56	MSGNR	Message number	nvarchar	3	0	Allow NULL?
57	MSGV1	Message variable 01	nvarchar	50	0	Allow NULL?
58	MSGV2	Message variable 02	nvarchar	50	0	Allow NULL?
59	MSGV3	Message variable 03	nvarchar	50	0	Allow NULL?
60	MSGV4	Message variable 04	nvarchar	50	0	Allow NULL?
61	DISGR	MRP Group	nvarchar	4	0	Allow NULL?
62	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
63	MRPPP	PPC planning calendar	nvarchar	3	0	Allow NULL?
64	BDARF	Requirements quantity from material requirements planning	decimal	13	3
65	LFRHY	Planning cycle	nvarchar	3	0	Allow NULL?
66	RDPRF	Rounding Profile	nvarchar	4	0	Allow NULL?
67	BERW1	Stock Days' Supply Without Receipts	decimal	4	1
68	BERW2	First Receipt Days' Supply	decimal	4	1
69	KZAUS	Discontinuation indicator	char	1	0	Allow NULL?
70	AUSDT	Effective-Out Date	nvarchar	8	0	Allow NULL?
71	NFMAT	Follow-Up Material	nvarchar	18	0	Allow NULL?
72	AUSZ1	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
73	AUSZ2	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
74	AUSZ3	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
75	AUSZ4	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
76	AUSZ5	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
77	AUSZ6	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
78	AUSZ7	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
79	AUSZ8	Exception group in the MRP list	nvarchar	2	0	Allow NULL?
80	BEADA	MRP list processing date	nvarchar	8	0	Allow NULL?
81	NAUKZ	Indicator: new exception in the MRP list	char	1	0	Allow NULL?
82	SAUFT	Ind.: Repetitive mfg allowed	char	1	0	Allow NULL?
83	KZPROMO	Indicator: Material in promotion	char	1	0	Allow NULL?
84	SHFLG	Safety time indicator (with or without safety time)	char	1	0	Allow NULL?
85	SHZET	Safety time (in workdays)	nvarchar	2	0	Allow NULL?
86	FABKZ	Indicator: Item Relevant to JIT Delivery Schedules	char	1	0	Allow NULL?
87	MFXDT	Manual firming date	nvarchar	8	0	Allow NULL?
88	BSKFL	Flag whether stock correction factors exist	char	1	0	Allow NULL?
89	MAABC	ABC Indicator	char	1	0	Allow NULL?
90	CFLAG	Aggregated MRP list	char	1	0	Allow NULL?
91	GRREL	Relevant for requirements grouping for project stock	char	1	0	Allow NULL?
92	RWPRO	Range of coverage profile	nvarchar	3	0	Allow NULL?
93	SHPRO	Period Profile for Safety Time	nvarchar	3	0	Allow NULL?
94	AHDIS	MRP relevancy for dependent requirements	char	1	0	Allow NULL?
95	BERW4	Second Receipt Days' Supply	decimal	4	1
96	BADON	Indicator: BAdI is Active	char	1	0	Allow NULL?
97	SGT_STATC	Segmentation Status	char	1	0	Allow NULL?
98	HANAON	HANA Optimizations Active / Inactive	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
MDKP~0	Yes	Yes	CLUSTERED	PLSCN, PLWRK, MATNR, DTART, MANDT
MDKP~1	No	No	NONCLUSTERED	DISPO, PLWRK, MANDT

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

98 COLUMNS | 2 INDEXES | ERP 6.0 | MDKP TABLE

TOP ERP 6.0 | MDKP COLUMNS

TOP ERP 6.0 | MDKP 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

98 COLUMNS | 2 INDEXES | ERP 6.0 | MDKP TABLE

TOPERP 6.0 | MDKP COLUMNS

TOPERP 6.0 | MDKP INDEXES

TOP ERP 6.0 | MDKP COLUMNS

TOP ERP 6.0 | MDKP INDEXES