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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

B1 8.8: Top 10 requests

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

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry-Specific Component-Mining
1	ERP EHP7	6.0	S411	115	2	Mining Info structure.	Industry-Specific Component-Mining

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	CHAR	(N' ')	No		SSOUR	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	CHAR	(N' ')	No	*	VRSIO	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	NUMC	(N'000000')	No		SPMON	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	DATS	(N'00000000')	No		SPTAG	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	NUMC	(N'000000')	No		SPWOC	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	NUMC	(N'000000')	No		SPBUP	Allow NULL?
8	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	No	T001W	WERKS_D	Allow NULL?
9	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	No	MARA	MATNR	Allow NULL?
10	PERIV	Fiscal Year Variant	nvarchar	2	0	CHAR	(N' ')	No	*	PERIV	Allow NULL?
11	VWDAT	Pointer to administrative data	nvarchar	10	0	NUMC	(N'0000000000')	No		VWDAT	Allow NULL?
12	MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	LAGME	Allow NULL?
13	BASME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
14	FIELD0001	Mining planning data element 001.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0001
15	FIELD0010	Mining planning data element 0010.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0010
16	FIELD0011	Mining planning data element 0011.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0011
17	FIELD0012	Mining planning data element 0012.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0012
18	FIELD0013	Mining planning data element 0013.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0013
19	FIELD0014	Mining planning data element 0014.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0014
20	FIELD0015	Mining planning data element 0015.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0015
21	FIELD0016	Mining planning data element 0016.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0016
22	FIELD0017	Mining planning data element 0017.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0017
23	FIELD0018	Mining planning data element 0018.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0018
24	FIELD0019	Mining planning data element 0019.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0019
25	FIELD0002	Mining planning data element 002.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0002
26	FIELD0020	Mining planning data element 0020.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0020
27	FIELD0021	Mining planning data element 0021	float	15	16	FLTP	((0))	Yes		OIM_FIELD0021
28	FIELD0022	Mining planning data element 0022	float	15	16	FLTP	((0))	Yes		OIM_FIELD0022
29	FIELD0003	Mining planning data element 0003.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0003
30	FIELD0004	Mining planning data element 0004.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0004
31	FIELD0005	Mining planning data element 0005.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0005
32	FIELD0006	Mining planning data element 0006.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0006
33	FIELD0007	Mining planning data element 0007.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0007
34	FIELD0008	Mining planning data element 0008.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0008
35	FIELD0009	Mining planning data element 0009.	float	15	16	FLTP	((0))	Yes		OIM_FIELD0009
36	FIELD0023	Mining planning data element 0023	float	15	16	FLTP	((0))	Yes		OIM_FIELD0023
37	FIELD0024	Mining planning data element 0024	float	15	16	FLTP	((0))	Yes		OIM_FIELD0024
38	FIELD0025	Mining planning data element 0025	float	15	16	FLTP	((0))	Yes		OIM_FIELD0025
39	FIELD0026	Mining planning data element 0026	float	15	16	FLTP	((0))	Yes		OIM_FIELD0026
40	FIELD0027	Mining planning data element 0027	float	15	16	FLTP	((0))	Yes		OIM_FIELD0027
41	FIELD0028	Mining planning data element 0028	float	15	16	FLTP	((0))	Yes		OIM_FIELD0028
42	FIELD0029	Mining planning data element 0029	float	15	16	FLTP	((0))	Yes		OIM_FIELD0029
43	FIELD0030	Mining planning data element 0030	float	15	16	FLTP	((0))	Yes		OIM_FIELD0030
44	FIELD0031	Mining planning data element 0031	float	15	16	FLTP	((0))	Yes		OIM_FIELD0031
45	FIELD0032	Mining planning data element 0032	float	15	16	FLTP	((0))	Yes		OIM_FIELD0032
46	FIELD0033	Mining planning data element 0033	float	15	16	FLTP	((0))	Yes		OIM_FIELD0033
47	FIELD0034	Mining planning data element 0034	float	15	16	FLTP	((0))	Yes		OIM_FIELD0034
48	FIELD0035	Mining planning data element 0035	float	15	16	FLTP	((0))	Yes		OIM_FIELD0035
49	FIELD0036	Mining planning data element 0036	float	15	16	FLTP	((0))	Yes		OIM_FIELD0036
50	FIELD0037	Mining planning data element 0037	float	15	16	FLTP	((0))	Yes		OIM_FIELD0037
51	FIELD0038	Mining planning data element 0038	float	15	16	FLTP	((0))	Yes		OIM_FIELD0038
52	FIELD0039	Mining planning data element 0039	float	15	16	FLTP	((0))	Yes		OIM_FIELD0039
53	FIELD0040	Mining planning data element 0040	float	15	16	FLTP	((0))	Yes		OIM_FIELD0040
54	FIELD0041	Mining planning data element 0041	float	15	16	FLTP	((0))	Yes		OIM_FIELD0041
55	FIELD0042	Mining planning data element 0042	float	15	16	FLTP	((0))	Yes		OIM_FIELD0042
56	FIELD0043	Mining planning data element 0043	float	15	16	FLTP	((0))	Yes		OIM_FIELD0043
57	FIELD0044	Mining planning data element 0044	float	15	16	FLTP	((0))	Yes		OIM_FIELD0044
58	FIELD0045	Mining planning data element 0045	float	15	16	FLTP	((0))	Yes		OIM_FIELD0045
59	FIELD0046	Mining planning data element 0046	float	15	16	FLTP	((0))	Yes		OIM_FIELD0046
60	FIELD0047	Mining planning data element 0047	float	15	16	FLTP	((0))	Yes		OIM_FIELD0047
61	FIELD0048	Mining planning data element 0048	float	15	16	FLTP	((0))	Yes		OIM_FIELD0048
62	FIELD0049	Mining planning data element 0049	float	15	16	FLTP	((0))	Yes		OIM_FIELD0049
63	FIELD0050	Mining planning data element 0050	float	15	16	FLTP	((0))	Yes		OIM_FIELD0050
64	FIELD0051	Mining planning data element 051	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0051
65	FIELD0052	Mining planning data element 052	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0052
66	FIELD0053	Mining planning data element 053	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0053
67	FIELD0054	Mining planning data element 054	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0054
68	FIELD0055	Mining planning data element 055	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0055
69	FIELD0056	Mining planning data element 056	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0056
70	FIELD0057	Mining planning data element 057	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0057
71	FIELD0058	Mining planning data element 058	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0058
72	FIELD0059	Mining planning data element 059	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0059
73	FIELD0060	Mining planning data element 060	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0060
74	FIELD0061	Mining planning data element 061	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0061
75	FIELD0062	Mining planning data element 062	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0062
76	FIELD0063	Mining planning data element 063	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0063
77	FIELD0064	Mining planning data element 064	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0064
78	FIELD0065	Mining planning data element 065	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0065
79	FIELD0066	Mining planning data element 066	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0066
80	FIELD0067	Mining planning data element 067	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0067
81	FIELD0068	Mining planning data element 068	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0068
82	FIELD0069	Mining planning data element 069	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0069
83	FIELD0070	Mining planning data element 070	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0070
84	FIELD0071	Mining planning data element 071	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0071
85	FIELD0072	Mining planning data element 072	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0072
86	FIELD0073	Mining planning data element 073	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0073
87	FIELD0074	Mining planning data element 074	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0074
88	FIELD0075	Mining planning data element 075	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0075
89	FIELD0076	Mining planning data element 076	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0076
90	FIELD0077	Mining planning data element 077	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0077
91	FIELD0078	Mining planning data element 078	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0078
92	FIELD0079	Mining planning data element 079	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0079
93	FIELD0080	Mining planning data element 080	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0080
94	FIELD0081	Mining planning data element 081	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0081
95	FIELD0082	Mining planning data element 082	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0082
96	FIELD0083	Mining planning data element 083	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0083
97	FIELD0085	Mining planning data element 085	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0085
98	FIELD0086	Mining planning data element 086	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0086
99	FIELD0087	Mining planning data element 087	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0087
100	FIELD0088	Mining planning data element 088	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0088
101	FIELD0089	Mining planning data element 089	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0089
102	FIELD0090	Mining planning data element 090	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0090
103	FIELD0091	Mining planning data element 091	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0091
104	FIELD0092	Mining planning data element 092	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0092
105	FIELD0093	Mining planning data element 093	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0093
106	FIELD0094	Mining planning data element 094	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0094
107	FIELD0095	Mining planning data element 095	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0095
108	FIELD0096	Mining planning data element 096	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0096
109	FIELD0097	Mining planning data element 097	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0097
110	FIELD0098	Mining planning data element 098	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0098
111	FIELD0099	Mining planning data element 099	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0099
112	FIELD0100	Mining planning data element 100	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0100
113	KWMENG	Cumulative Order Quantity in Sales Units	decimal	15	3	QUAN	((0))	Yes		KWMENG
114	FIELD0084	Mining planning data element 084	decimal	13	3	QUAN	((0))	Yes		OIM_FIELD0084
115	MZUBB	Valuated stock receipts quantity	decimal	15	3	QUAN	((0))	Yes		MZUBB

Name	Primary	Unique	Type	Columns
S411~0	Yes	Yes	CLUSTERED	MATNR, WERKS, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT
S411~VAB	No	No	NONCLUSTERED	MATNR, 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

115 COLUMNS | 2 INDEXES | ERP 6.0 | S411 TABLE

TOP ERP 6.0 | S411 COLUMNS

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

115 COLUMNS | 2 INDEXES | ERP 6.0 | S411 TABLE

TOPERP 6.0 | S411 COLUMNS

TOPERP 6.0 | S411 INDEXES

TOP ERP 6.0 | S411 COLUMNS

TOP ERP 6.0 | S411 INDEXES