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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	DSF_GUID	DSF GUID	nvarchar	32	0	Allow NULL?
3	DSF_DSTORE_ID	Data Store ID	nvarchar	40	0	Allow NULL?
4	USER_GUID	User GUID	nvarchar	32	0	Allow NULL?
5	DSF_RECORD_ID	DSF Record ID	nvarchar	10	0	Allow NULL?
6	DSF_CHANGED_BY	Last Changed By	nvarchar	12	0	Allow NULL?
7	DSF_CHANGED_TS	Changed time stamp	decimal	15	0
8	TPLNR	Functional Location	nvarchar	30	0	Allow NULL?
9	MLANG	Primary language for object texts	char	1	0	Allow NULL?
10	TPLKZ	Functional location structure indicator	nvarchar	5	0	Allow NULL?
11	FLTYP	Functional location category	char	1	0	Allow NULL?
12	TPLMA	Superior functional location	nvarchar	30	0	Allow NULL?
13	ERDAT	Date on which the object was created	nvarchar	8	0	Allow NULL?
14	ERNAM	Name of User Who Created the Object	nvarchar	12	0	Allow NULL?
15	AEDAT	Date on which the object was last changed	nvarchar	8	0	Allow NULL?
16	AENAM	Name of the user who last changed the object	nvarchar	12	0	Allow NULL?
17	DATAB	Start-up Date of the Technical Object	nvarchar	8	0	Allow NULL?
18	BEGRU	Technical object authorization group	nvarchar	4	0	Allow NULL?
19	TRPNR	Reference functional location	nvarchar	30	0	Allow NULL?
20	PSTAE	SAP Development reserve: Format CHAR, length 4	nvarchar	4	0	Allow NULL?
21	STNAM	SAP Development Reserve: Format CHAR, Length 12	nvarchar	12	0	Allow NULL?
22	LVORM	SAP Development Reserve: Format CHAR, Length 1	char	1	0	Allow NULL?
23	SUBMT	Construction type material of the object	nvarchar	18	0	Allow NULL?
24	SUBMTI	Data origin for construction type field	char	1	0	Allow NULL?
25	MAPAR	Manufacturer part number	nvarchar	30	0	Allow NULL?
26	MAPARI	SAP Development Reserve: Format CHAR, Length 1	char	1	0	Allow NULL?
27	IEQUI	Installation of equipment allowed at the functional location	char	1	0	Allow NULL?
28	IEQUII	Data origin for equip. inst. allowed field	char	1	0	Allow NULL?
29	EINZL	Single equipment installation at functional location	char	1	0	Allow NULL?
30	EINZLI	Data origin for authorization group field	char	1	0	Allow NULL?
31	IWERK	Maintenance Planning Plant	nvarchar	4	0	Allow NULL?
32	IWERKI	Data origin for planning plant field	char	1	0	Allow NULL?
33	INGRP	Planner Group for Customer Service and Plant Maintenance	nvarchar	3	0	Allow NULL?
34	INGRPI	Data origin for maintenance planner group field	char	1	0	Allow NULL?
35	PM_OBJTY	Object Type of CIM Resources for Work Center	nvarchar	2	0	Allow NULL?
36	LGWID	Object ID of the Work Center	nvarchar	8	0	Allow NULL?
37	LGWIDI	Data Origin for the Field 'Work Center'	char	1	0	Allow NULL?
38	RBNR	Catalog Profile	nvarchar	9	0	Allow NULL?
39	RBNR_I	Data origin for maintenance catalog field	char	1	0	Allow NULL?
40	ILOAN	Location and account assignment for technical object	nvarchar	12	0	Allow NULL?
41	OBJNR	Object number	nvarchar	22	0	Allow NULL?
42	POSNR	Position in superior technical object	nvarchar	4	0	Allow NULL?
43	ISTYP	Object category for Industry Solutions (IS)	char	1	0	Allow NULL?
44	PREMS	Premise	nvarchar	10	0	Allow NULL?
45	EQART	Type of Technical Object	nvarchar	10	0	Allow NULL?
46	INVNR	Inventory number	nvarchar	25	0	Allow NULL?
47	GROES	Size/dimension	nvarchar	18	0	Allow NULL?
48	BRGEW	Gross Weight	decimal	13	3
49	GEWEI	Weight Unit	nvarchar	3	0	Allow NULL?
50	ANSWT	Acquisition Value	decimal	13	2
51	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
52	ANSDT	Acquisition date	nvarchar	8	0	Allow NULL?
53	HERST	Manufacturer of asset	nvarchar	30	0	Allow NULL?
54	HERLD	Country of manufacture	nvarchar	3	0	Allow NULL?
55	BAUJJ	Year of construction	nvarchar	4	0	Allow NULL?
56	BAUMM	Month of construction	nvarchar	2	0	Allow NULL?
57	TYPBZ	Manufacturer model number	nvarchar	20	0	Allow NULL?
58	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	Allow NULL?
59	SERGE	Manufacturer serial number	nvarchar	30	0	Allow NULL?
60	HANDLE	SAP Development Reserve: Integration of Date Segment (Key)	nvarchar	22	0	Allow NULL?
61	TSEGTP	SAP Development Reserve: Integration Date Segment (Tempate)	nvarchar	10	0	Allow NULL?
62	FLLB_DUTY	Logbook Duty	char	1	0	Allow NULL?
63	FLLB_HIDE	Hide Logbook Display	char	1	0	Allow NULL?
64	IFLOT_SRTYPE	Shift Report Type for Object	nvarchar	10	0	Allow NULL?
65	IFLOT_SNTYPE	Notification Type for Shift Note for Object	nvarchar	2	0	Allow NULL?
66	ABCKZ	ABC indicator for technical object	char	1	0	Allow NULL?
67	ABCKZI	Data origin for ABC indicator field	char	1	0	Allow NULL?
68	EQFNR	Sort field	nvarchar	30	0	Allow NULL?
69	EQFNRI	Data origin for sort field	char	1	0	Allow NULL?
70	SWERK	Maintenance plant	nvarchar	4	0	Allow NULL?
71	SWERKI	Data origin for maintenance plant field	char	1	0	Allow NULL?
72	STORT	Location of maintenance object	nvarchar	10	0	Allow NULL?
73	STORTI	Data origin for location field	char	1	0	Allow NULL?
74	MSGRP	Room	nvarchar	8	0	Allow NULL?
75	MSGRPI	Data origin for room number field	char	1	0	Allow NULL?
76	BEBER	Plant section	nvarchar	3	0	Allow NULL?
77	BEBERI	Data origin for plant section field	char	1	0	Allow NULL?
78	CR_OBJTY	Object types of the CIM resource	nvarchar	2	0	Allow NULL?
79	PPSID	Object ID of PP work center	nvarchar	8	0	Allow NULL?
80	PPSIDI	Data origin for PP work center field	char	1	0	Allow NULL?
81	GSBER	Business Area	nvarchar	4	0	Allow NULL?
82	GSBERI	Data origin for business area field	char	1	0	Allow NULL?
83	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
84	KOKRSI	Data origin for controlling area field	char	1	0	Allow NULL?
85	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
86	KOSTLI	Data origin for cost center field	char	1	0	Allow NULL?
87	PROID	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
88	PROIDI	Data origin for WBS element field	char	1	0	Allow NULL?
89	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
90	BUKRSI	Data origin for company code field	char	1	0	Allow NULL?
91	ANLNR	Main Asset Number	nvarchar	12	0	Allow NULL?
92	ANLNRI	Data origin for asset main no./sub-no. fields	char	1	0	Allow NULL?
93	ANLUN	Asset Subnumber	nvarchar	4	0	Allow NULL?
94	ANLUNI	Data origin indicator	char	1	0	Allow NULL?
95	DAUFN	Standing order number	nvarchar	12	0	Allow NULL?
96	DAUFNI	Data origin of standing order number field	char	1	0	Allow NULL?
97	AUFNR	Settlement order	nvarchar	12	0	Allow NULL?
98	AUFNRI	Data origin for settlement order field	char	1	0	Allow NULL?
99	TPLNRI	Data origin for functional location field	char	1	0	Allow NULL?
100	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
101	VKORGI	Data origin for sales organization field	char	1	0	Allow NULL?
102	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
103	VTWEGI	Data origin of distribution channel field	char	1	0	Allow NULL?
104	SPART	Division	nvarchar	2	0	Allow NULL?
105	SPARTI	Data origin for division field	char	1	0	Allow NULL?
106	ADRNR	Address number	nvarchar	10	0	Allow NULL?
107	ADRNRI	Data origin for address field	char	1	0	Allow NULL?
108	OWNER	Object reference indicator	char	1	0	Allow NULL?
109	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
110	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
111	PLTXT	Description of functional location	nvarchar	40	0	Allow NULL?
112	ARBPL	Work center	nvarchar	8	0	Allow NULL?
113	ARBPL_LOC	Work center	nvarchar	8	0	Allow NULL?
114	SYSTEM_STATUS	Display lines for system status	nvarchar	40	0	Allow NULL?
115	USER_STATUS	Display lines for user status	nvarchar	40	0	Allow NULL?
116	SYST_STATUS_CODE	Text	nvarchar	50	0	Allow NULL?
117	USER_STATUS_CODE	Text	nvarchar	50	0	Allow NULL?
118	TPLNR_EXT		nvarchar	40	0	Allow NULL?
119	TPLMA_EXT		nvarchar	40	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/SMERP/STG_PM00800	No	No	NONCLUSTERED	DSF_RECORD_ID, MANDT
/SMERP/STG_PM008A0	No	No	NONCLUSTERED	DSF_DSTORE_ID, MANDT
/SMERP/STG_PM008~0	Yes	Yes	CLUSTERED	DSF_GUID, 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

119 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM008 TABLE

TOP ERP 6.0 | /SMERP/STG_PM008 COLUMNS

TOP ERP 6.0 | /SMERP/STG_PM008 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

119 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM008 TABLE

TOPERP 6.0 | /SMERP/STG_PM008 COLUMNS

TOPERP 6.0 | /SMERP/STG_PM008 INDEXES

TOP ERP 6.0 | /SMERP/STG_PM008 COLUMNS

TOP ERP 6.0 | /SMERP/STG_PM008 INDEXES