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	EQUNR	Equipment Number	nvarchar	18	0	Allow NULL?
9	ERDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
10	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
11	EQASP	Language in Which the Piece of Equipment was Entered	char	1	0	Allow NULL?
12	AEDAT	Changed On	nvarchar	8	0	Allow NULL?
13	AENAM	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
14	BEGRU	Technical object authorization group	nvarchar	4	0	Allow NULL?
15	EQTYP	Equipment category	char	1	0	Allow NULL?
16	EQART	Type of Technical Object	nvarchar	10	0	Allow NULL?
17	LVORM	SAP Development Reserve: Format CHAR, Length 1	char	1	0	Allow NULL?
18	INVNR	Inventory number	nvarchar	25	0	Allow NULL?
19	GROES	Size/dimension	nvarchar	18	0	Allow NULL?
20	BRGEW	Weight of object	decimal	13	3
21	GEWEI	Unit of weight	nvarchar	3	0	Allow NULL?
22	ANSDT	Acquisition date	nvarchar	8	0	Allow NULL?
23	ANSWT	Acquisition Value	decimal	13	2
24	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
25	ELIEF	Vendor number	nvarchar	10	0	Allow NULL?
26	GWLEN	Date on which the warranty ends	nvarchar	8	0	Allow NULL?
27	GWLDT	Warranty Date	nvarchar	8	0	Allow NULL?
28	WDBWT	Equipment replacement value	decimal	13	2
29	HERST	Manufacturer of asset	nvarchar	30	0	Allow NULL?
30	HERLD	Country of manufacture	nvarchar	3	0	Allow NULL?
31	HZEIN	Manufacturer drawing number	nvarchar	30	0	Allow NULL?
32	SERGE	Manufacturer serial number	nvarchar	30	0	Allow NULL?
33	TYPBZ	Manufacturer model number	nvarchar	20	0	Allow NULL?
34	BAUJJ	Year of construction	nvarchar	4	0	Allow NULL?
35	BAUMM	Month of construction	nvarchar	2	0	Allow NULL?
36	APLKZ	Indicator: Task List Exists	char	1	0	Allow NULL?
37	AULDT	First delivery date of the equipment	nvarchar	8	0	Allow NULL?
38	INBDT	Start-up Date of the Technical Object	nvarchar	8	0	Allow NULL?
39	GERNR	Serial Number	nvarchar	18	0	Allow NULL?
40	GWLDV	Warranty date for Sales and Distribution	nvarchar	8	0	Allow NULL?
41	EQDAT	Date, intended for SAP internal use	nvarchar	8	0	Allow NULL?
42	EQBER	Technical information, intended for SAP internal use	nvarchar	30	0	Allow NULL?
43	EQNUM	Numerical field, intended for SAP internal use	nvarchar	9	0	Allow NULL?
44	OBJNR	Object number	nvarchar	22	0	Allow NULL?
45	EQSNR	EQSE Number	nvarchar	18	0	Allow NULL?
46	CUOBJ	Configuration (internal object number)	nvarchar	18	0	Allow NULL?
47	KRFKZ	Referenced Configuration	char	1	0	Allow NULL?
48	KMATN	Configurable Material	nvarchar	18	0	Allow NULL?
49	MATNR	Material Number	nvarchar	18	0	Allow NULL?
50	SERNR	Serial Number	nvarchar	18	0	Allow NULL?
51	WERK	Plant	nvarchar	4	0	Allow NULL?
52	LAGER	Storage Location	nvarchar	4	0	Allow NULL?
53	CHARGE	Batch Number	nvarchar	10	0	Allow NULL?
54	KUNDE	Customer to Whom Serial Number was Delivered	nvarchar	10	0	Allow NULL?
55	WARPL	Maintenance Plan	nvarchar	12	0	Allow NULL?
56	IMRC_POINT	Measuring Point	nvarchar	12	0	Allow NULL?
57	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
58	MGANR	Master warranty number	nvarchar	20	0	Allow NULL?
59	BEGRUI	Data origin for authorization group field	char	1	0	Allow NULL?
60	S_EQUI	Equipment data exists	char	1	0	Allow NULL?
61	S_SERIAL	Serial data when maintaining equipment	char	1	0	Allow NULL?
62	S_KONFI	Configuration supported	char	1	0	Allow NULL?
63	S_SALE	Sales equipment	char	1	0	Allow NULL?
64	S_FHM	Equip. category relevant to production resources and tools	char	1	0	Allow NULL?
65	S_ELSE	Indicator: Other Data Active	char	1	0	Allow NULL?
66	S_ISU	IS-U data	char	1	0	Allow NULL?
67	S_EQBS	EQSI Exists	char	1	0	Allow NULL?
68	S_FLEET	Indicator: Fleet object active	char	1	0	Allow NULL?
69	BSTVP	Stock Check for Serial Numbers	char	1	0	Allow NULL?
70	SPARTE	Division	nvarchar	2	0	Allow NULL?
71	HANDLE	SAP Development Reserve: Integration of Date Segment (Key)	nvarchar	22	0	Allow NULL?
72	TSEGTP	SAP Development Reserve: Integration Date Segment (Tempate)	nvarchar	10	0	Allow NULL?
73	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	Allow NULL?
74	ACT_CHANGE_AA	Change Equipment Master when Changing Asset	char	1	0	Allow NULL?
75	S_CC	Configuration Control Data	char	1	0	Allow NULL?
76	DATLWB	Date of Last Goods Movement	nvarchar	8	0	Allow NULL?
77	DATBI	Valid To Date	nvarchar	8	0	Allow NULL?
78	EQLFN	Consecutive numbering of EquipUsagePeriods on same day	nvarchar	3	0	Allow NULL?
79	EQUZN	Number of next EquipUsagePeriod on same day	nvarchar	3	0	Allow NULL?
80	TIMBI	Equipment usage period time stamp	nvarchar	6	0	Allow NULL?
81	ESTAI	SAP Development Reserve: Format CHAR, Length 1	char	1	0	Allow NULL?
82	ESTAE	SAP Development reserve: Format CHAR, length 4	nvarchar	4	0	Allow NULL?
83	STNAM	SAP Development Reserve: Format CHAR, Length 12	nvarchar	12	0	Allow NULL?
84	DATAB	Valid-From Date	nvarchar	8	0	Allow NULL?
85	IWERK	Maintenance Planning Plant	nvarchar	4	0	Allow NULL?
86	IWERKI	Data origin indicator	char	1	0	Allow NULL?
87	SUBMT	Construction type material of the object	nvarchar	18	0	Allow NULL?
88	MAPAR	Manufacturer part number	nvarchar	30	0	Allow NULL?
89	HEQUI	Superordinate Equipment	nvarchar	18	0	Allow NULL?
90	HEQNR	Equipment position at InstallLoc (Superior Equip./FunctLoc)	nvarchar	4	0	Allow NULL?
91	INGRP	Planner Group for Customer Service and Plant Maintenance	nvarchar	3	0	Allow NULL?
92	INGRPI	Data origin indicator	char	1	0	Allow NULL?
93	PM_OBJTY	Object Type of CIM Resources for Work Center	nvarchar	2	0	Allow NULL?
94	GEWRK	Object ID of the Work Center	nvarchar	8	0	Allow NULL?
95	GEWRKI	Data origin indicator	char	1	0	Allow NULL?
96	TIDNR	Technical identification number	nvarchar	25	0	Allow NULL?
97	TIDNRI	Data origin indicator	char	1	0	Allow NULL?
98	ILOAN	Location and account assignment for technical object	nvarchar	12	0	Allow NULL?
99	KUND1	Customer number	nvarchar	10	0	Allow NULL?
100	KUND2	End customer number	nvarchar	10	0	Allow NULL?
101	KUND3	Operator	nvarchar	10	0	Allow NULL?
102	LIZNR	Equipment license number	nvarchar	20	0	Allow NULL?
103	RBNR	Catalog Profile	nvarchar	9	0	Allow NULL?
104	EZDAT	Date, intended for SAP internal use	nvarchar	8	0	Allow NULL?
105	EZBER	Technical information, intended for SAP internal use	nvarchar	30	0	Allow NULL?
106	EZNUM	Numerical field, intended for SAP internal use	nvarchar	9	0	Allow NULL?
107	RBNR_I	Data origin indicator	char	1	0	Allow NULL?
108	IBLNR	Physical Inventory Document	nvarchar	10	0	Allow NULL?
109	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
110	PVS_FOCUS	Internal Identification for PVS Objects	varbinary	16	0
111	PPEGUID	Internal Identification for PVS Objects	varbinary	16	0
112	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	Allow NULL?
113	FUNCID	Function Identifier	nvarchar	40	0	Allow NULL?
114	FRCFIT	Indicator: Forced Installation/Dismantling	char	1	0	Allow NULL?
115	FRCRMV	Force Dismantling Flag	char	1	0	Allow NULL?
116	SPRAS	Language Key	char	1	0	Allow NULL?
117	EQKTX	Description of technical object	nvarchar	40	0	Allow NULL?
118	KZLTX	Long Text Indicator	char	1	0	Allow NULL?
119	TXASP	Primary language indicator for text segment	char	1	0	Allow NULL?
120	EQKTU	Equipment description in capital letters	nvarchar	40	0	Allow NULL?
121	TPLNR	Functional Location	nvarchar	30	0	Allow NULL?
122	ABCKZ	ABC indicator for technical object	char	1	0	Allow NULL?
123	ABCKZI	Data origin for ABC indicator field	char	1	0	Allow NULL?
124	EQFNR	Sort field	nvarchar	30	0	Allow NULL?
125	EQFNRI	Data origin for sort field	char	1	0	Allow NULL?
126	SWERK	Maintenance plant	nvarchar	4	0	Allow NULL?
127	SWERKI	Data origin for maintenance plant field	char	1	0	Allow NULL?
128	STORT	Location of maintenance object	nvarchar	10	0	Allow NULL?
129	STORTI	Data origin for location field	char	1	0	Allow NULL?
130	MSGRP	Room	nvarchar	8	0	Allow NULL?
131	MSGRPI	Data origin for room number field	char	1	0	Allow NULL?
132	BEBER	Plant section	nvarchar	3	0	Allow NULL?
133	BEBERI	Data origin for plant section field	char	1	0	Allow NULL?
134	CR_OBJTY	Object types of the CIM resource	nvarchar	2	0	Allow NULL?
135	PPSID	Object ID of PP work center	nvarchar	8	0	Allow NULL?
136	PPSIDI	Data origin for PP work center field	char	1	0	Allow NULL?
137	GSBER	Business Area	nvarchar	4	0	Allow NULL?
138	GSBERI	Data origin for business area field	char	1	0	Allow NULL?
139	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
140	KOKRSI	Data origin for controlling area field	char	1	0	Allow NULL?
141	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
142	KOSTLI	Data origin for cost center field	char	1	0	Allow NULL?
143	PROID	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
144	PROIDI	Data origin for WBS element field	char	1	0	Allow NULL?
145	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
146	BUKRSI	Data origin for company code field	char	1	0	Allow NULL?
147	ANLNR	Main Asset Number	nvarchar	12	0	Allow NULL?
148	ANLNRI	Data origin for asset main no./sub-no. fields	char	1	0	Allow NULL?
149	ANLUN	Asset Subnumber	nvarchar	4	0	Allow NULL?
150	ANLUNI	Data origin indicator	char	1	0	Allow NULL?
151	DAUFN	Standing order number	nvarchar	12	0	Allow NULL?
152	DAUFNI	Data origin of standing order number field	char	1	0	Allow NULL?
153	AUFNR	Settlement order	nvarchar	12	0	Allow NULL?
154	AUFNRI	Data origin for settlement order field	char	1	0	Allow NULL?
155	TPLNRI	Data origin for functional location field	char	1	0	Allow NULL?
156	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
157	VKORGI	Data origin for sales organization field	char	1	0	Allow NULL?
158	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
159	VTWEGI	Data origin of distribution channel field	char	1	0	Allow NULL?
160	SPART	Division	nvarchar	2	0	Allow NULL?
161	SPARTI	Data origin for division field	char	1	0	Allow NULL?
162	ADRNR	Address number	nvarchar	10	0	Allow NULL?
163	ADRNRI	Data origin for address field	char	1	0	Allow NULL?
164	OWNER	Object reference indicator	char	1	0	Allow NULL?
165	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
166	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
167	LVORZ	SAP Development Reserve: Format CHAR, Length 1	char	1	0	Allow NULL?
168	ERNAZ	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
169	ERDAZ	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
170	AENAZ	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
171	AEDAZ	Changed On	nvarchar	8	0	Allow NULL?
172	ARBPL_LOC	Work center	nvarchar	8	0	Allow NULL?
173	ARBPL_LOC_TEXT	Short description	nvarchar	40	0	Allow NULL?
174	ARBPL	Work center	nvarchar	8	0	Allow NULL?
175	ARBPL_TEXT	Short description	nvarchar	40	0	Allow NULL?
176	TYPTX	Equipment category description	nvarchar	30	0	Allow NULL?
177	EARTX	Text for Object Type	nvarchar	20	0	Allow NULL?
178	STORT_TEXT	Text, length 40	nvarchar	40	0	Allow NULL?
179	BEBER_TEXT	Text, length 40	nvarchar	40	0	Allow NULL?
180	SYSTEM_STATUS	Display lines for system status	nvarchar	40	0	Allow NULL?
181	USER_STATUS	Display lines for user status	nvarchar	40	0	Allow NULL?
182	SYST_STATUS_CODE	Text	nvarchar	50	0	Allow NULL?
183	USER_STATUS_CODE	Text	nvarchar	50	0	Allow NULL?
184	TPLNR_EXT		nvarchar	40	0	Allow NULL?
185	LBBSA	Stock Type of Goods Movement (Primary Posting)	nvarchar	2	0	Allow NULL?
186	B_WERK	Plant	nvarchar	4	0	Allow NULL?
187	B_LAGER	Storage Location	nvarchar	4	0	Allow NULL?
188	B_CHARGE	Batch Number	nvarchar	10	0	Allow NULL?
189	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
190	KUNNR	Customer account number	nvarchar	10	0	Allow NULL?
191	LIFNR	Account number of the vendor	nvarchar	10	0	Allow NULL?
192	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
193	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
194	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
195	DISUB_OWNER	Owner of stock	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
/SMERP/STG_PM00100	No	No	NONCLUSTERED	DSF_RECORD_ID, MANDT
/SMERP/STG_PM001A0	No	No	NONCLUSTERED	DSF_DSTORE_ID, MANDT
/SMERP/STG_PM001~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

195 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM001 TABLE

TOP ERP 6.0 | /SMERP/STG_PM001 COLUMNS

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

195 COLUMNS | 3 INDEXES | ERP 6.0 | /SMERP/STG_PM001 TABLE

TOPERP 6.0 | /SMERP/STG_PM001 COLUMNS

TOPERP 6.0 | /SMERP/STG_PM001 INDEXES

TOP ERP 6.0 | /SMERP/STG_PM001 COLUMNS

TOP ERP 6.0 | /SMERP/STG_PM001 INDEXES