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
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	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	SSOUR	Statistic(s) origin	nvarchar	4	0	Allow NULL?
3	VRSIO	Version number in the information structure	nvarchar	3	0	Allow NULL?
4	SPMON	Period to analyze - month	nvarchar	6	0	Allow NULL?
5	SPTAG	Period to analyze - current date	nvarchar	8	0	Allow NULL?
6	SPWOC	Period to analyze - week	nvarchar	6	0	Allow NULL?
7	SPBUP	Period to analyze - posting period	nvarchar	6	0	Allow NULL?
8	WERKS	Plant	nvarchar	4	0	Allow NULL?
9	MATNR	Material Number	nvarchar	18	0	Allow NULL?
10	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
11	VWDAT	Pointer to administrative data	nvarchar	10	0	Allow NULL?
12	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
13	BASME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
14	FIELD0001	Mining planning data element 001.	float	15	16
15	FIELD0010	Mining planning data element 0010.	float	15	16
16	FIELD0011	Mining planning data element 0011.	float	15	16
17	FIELD0012	Mining planning data element 0012.	float	15	16
18	FIELD0013	Mining planning data element 0013.	float	15	16
19	FIELD0014	Mining planning data element 0014.	float	15	16
20	FIELD0015	Mining planning data element 0015.	float	15	16
21	FIELD0016	Mining planning data element 0016.	float	15	16
22	FIELD0017	Mining planning data element 0017.	float	15	16
23	FIELD0018	Mining planning data element 0018.	float	15	16
24	FIELD0019	Mining planning data element 0019.	float	15	16
25	FIELD0002	Mining planning data element 002.	float	15	16
26	FIELD0020	Mining planning data element 0020.	float	15	16
27	FIELD0021	Mining planning data element 0021	float	15	16
28	FIELD0022	Mining planning data element 0022	float	15	16
29	FIELD0003	Mining planning data element 0003.	float	15	16
30	FIELD0004	Mining planning data element 0004.	float	15	16
31	FIELD0005	Mining planning data element 0005.	float	15	16
32	FIELD0006	Mining planning data element 0006.	float	15	16
33	FIELD0007	Mining planning data element 0007.	float	15	16
34	FIELD0008	Mining planning data element 0008.	float	15	16
35	FIELD0009	Mining planning data element 0009.	float	15	16
36	FIELD0023	Mining planning data element 0023	float	15	16
37	FIELD0024	Mining planning data element 0024	float	15	16
38	FIELD0025	Mining planning data element 0025	float	15	16
39	FIELD0026	Mining planning data element 0026	float	15	16
40	FIELD0027	Mining planning data element 0027	float	15	16
41	FIELD0028	Mining planning data element 0028	float	15	16
42	FIELD0029	Mining planning data element 0029	float	15	16
43	FIELD0030	Mining planning data element 0030	float	15	16
44	FIELD0031	Mining planning data element 0031	float	15	16
45	FIELD0032	Mining planning data element 0032	float	15	16
46	FIELD0033	Mining planning data element 0033	float	15	16
47	FIELD0034	Mining planning data element 0034	float	15	16
48	FIELD0035	Mining planning data element 0035	float	15	16
49	FIELD0036	Mining planning data element 0036	float	15	16
50	FIELD0037	Mining planning data element 0037	float	15	16
51	FIELD0038	Mining planning data element 0038	float	15	16
52	FIELD0039	Mining planning data element 0039	float	15	16
53	FIELD0040	Mining planning data element 0040	float	15	16
54	FIELD0041	Mining planning data element 0041	float	15	16
55	FIELD0042	Mining planning data element 0042	float	15	16
56	FIELD0043	Mining planning data element 0043	float	15	16
57	FIELD0044	Mining planning data element 0044	float	15	16
58	FIELD0045	Mining planning data element 0045	float	15	16
59	FIELD0046	Mining planning data element 0046	float	15	16
60	FIELD0047	Mining planning data element 0047	float	15	16
61	FIELD0048	Mining planning data element 0048	float	15	16
62	FIELD0049	Mining planning data element 0049	float	15	16
63	FIELD0050	Mining planning data element 0050	float	15	16
64	FIELD0051	Mining planning data element 051	decimal	13	3
65	FIELD0052	Mining planning data element 052	decimal	13	3
66	FIELD0053	Mining planning data element 053	decimal	13	3
67	FIELD0054	Mining planning data element 054	decimal	13	3
68	FIELD0055	Mining planning data element 055	decimal	13	3
69	FIELD0056	Mining planning data element 056	decimal	13	3
70	FIELD0057	Mining planning data element 057	decimal	13	3
71	FIELD0058	Mining planning data element 058	decimal	13	3
72	FIELD0059	Mining planning data element 059	decimal	13	3
73	FIELD0060	Mining planning data element 060	decimal	13	3
74	FIELD0061	Mining planning data element 061	decimal	13	3
75	FIELD0062	Mining planning data element 062	decimal	13	3
76	FIELD0063	Mining planning data element 063	decimal	13	3
77	FIELD0064	Mining planning data element 064	decimal	13	3
78	FIELD0065	Mining planning data element 065	decimal	13	3
79	FIELD0066	Mining planning data element 066	decimal	13	3
80	FIELD0067	Mining planning data element 067	decimal	13	3
81	FIELD0068	Mining planning data element 068	decimal	13	3
82	FIELD0069	Mining planning data element 069	decimal	13	3
83	FIELD0070	Mining planning data element 070	decimal	13	3
84	FIELD0071	Mining planning data element 071	decimal	13	3
85	FIELD0072	Mining planning data element 072	decimal	13	3
86	FIELD0073	Mining planning data element 073	decimal	13	3
87	FIELD0074	Mining planning data element 074	decimal	13	3
88	FIELD0075	Mining planning data element 075	decimal	13	3
89	FIELD0076	Mining planning data element 076	decimal	13	3
90	FIELD0077	Mining planning data element 077	decimal	13	3
91	FIELD0078	Mining planning data element 078	decimal	13	3
92	FIELD0079	Mining planning data element 079	decimal	13	3
93	FIELD0080	Mining planning data element 080	decimal	13	3
94	FIELD0081	Mining planning data element 081	decimal	13	3
95	FIELD0082	Mining planning data element 082	decimal	13	3
96	FIELD0083	Mining planning data element 083	decimal	13	3
97	FIELD0085	Mining planning data element 085	decimal	13	3
98	FIELD0086	Mining planning data element 086	decimal	13	3
99	FIELD0087	Mining planning data element 087	decimal	13	3
100	FIELD0088	Mining planning data element 088	decimal	13	3
101	FIELD0089	Mining planning data element 089	decimal	13	3
102	FIELD0090	Mining planning data element 090	decimal	13	3
103	FIELD0091	Mining planning data element 091	decimal	13	3
104	FIELD0092	Mining planning data element 092	decimal	13	3
105	FIELD0093	Mining planning data element 093	decimal	13	3
106	FIELD0094	Mining planning data element 094	decimal	13	3
107	FIELD0095	Mining planning data element 095	decimal	13	3
108	FIELD0096	Mining planning data element 096	decimal	13	3
109	FIELD0097	Mining planning data element 097	decimal	13	3
110	FIELD0098	Mining planning data element 098	decimal	13	3
111	FIELD0099	Mining planning data element 099	decimal	13	3
112	FIELD0100	Mining planning data element 100	decimal	13	3
113	KWMENG	Cumulative Order Quantity in Sales Units	decimal	15	3
114	FIELD0084	Mining planning data element 084	decimal	13	3
115	MZUBB	Valuated stock receipts quantity	decimal	15	3

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