	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

	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

	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

280 tablesB1 9.2

	Product	Version	Table	Columns	Indexes	Description	Module
Administration
1	Business One	9.2	AAD1	108	1	Administration Extension-Log	Administration
2	Business One	9.2	AADM	454	1	Administration - Log	Administration
3	Business One	9.2	AADP	38	1	Print Preferences	Administration
4	Business One	9.2	ABP1	4	1	Business Place Tax IDs	Administration
5	Business One	9.2	ABP2	10	1	Branch Tributary Info. Log	Administration
6	Business One	9.2	ACFP	10	2	CFOP for Nota Fiscal	Administration
7	Business One	9.2	ACRC	13	2	Credit Cards	Administration
8	Business One	9.2	ADM1	108	1	Administration Extension	Administration
9	Business One	9.2	ADM2	62	1	Administration Electronic Report	Administration
10	Business One	9.2	ADP1	49	2	Object Settings - History	Administration
11	Business One	9.2	ADP2	4	2	Report Settings - History	Administration
12	Business One	9.2	AEXD	36	1	Freight Setup	Administration
13	Business One	9.2	AFM1	7	1	Tax Formula Parameter Declaration	Administration
14	Business One	9.2	AFML	10	2	Tax Formula Master Table	Administration
15	Business One	9.2	AINF	210	1	Company Info	Administration
16	Business One	9.2	ALR1	10	2	Queue of messages to be sent	Administration
17	Business One	9.2	ALR2	4	1	Dynamic message data row	Administration
18	Business One	9.2	ALR3	6	1	Dynamic message data cells	Administration
19	Business One	9.2	ALT1	6	1	Alerts - Users	Administration
20	Business One	9.2	ANCM	7	2	NCM Code	Administration
21	Business One	9.2	AOB1	23	3	Sent Messages - User History	Administration
22	Business One	9.2	APJ1	20	1	Project Plan Steps	Administration
23	Business One	9.2	APJ2	10	1	Project Plan Steps Time Record	Administration
24	Business One	9.2	APJT	9	1	Project Plan	Administration
25	Business One	9.2	ARI1	4	1	Add-On	Administration
26	Business One	9.2	AST1	11	1	Sales Tax Codes - Rows	Administration
27	Business One	9.2	ASTC	17	1	Sales Tax Codes	Administration
28	Business One	9.2	ASTT	12	2	Sales Tax Authorities Type	Administration
29	Business One	9.2	ATC1	11	1	Attachments - Rows	Administration
30	Business One	9.2	ATSC	12	2	CST Code for Nota Fiscal	Administration
31	Business One	9.2	AUSR	101	1	Archive Users - History	Administration
32	Business One	9.2	AWEX	13	1	Workflow Engine Execution Entity	Administration
33	Business One	9.2	AWFQ	15	1	SWFQ History Table	Administration
34	Business One	9.2	AWL1	7	1	Potential Processor of Tasks	Administration
35	Business One	9.2	AWL2	9	1	Input data for tasks	Administration
36	Business One	9.2	AWL3	8	1	Task Notes	Administration
37	Business One	9.2	AWL4	8	1	Task Output Data	Administration
38	Business One	9.2	AWL5	7	1	Task Field Mapping Information	Administration
39	Business One	9.2	AWLS	33	1	Workflow - Task Details	Administration
40	Business One	9.2	AWMG	11	1	Workflow Manager	Administration
41	Business One	9.2	AWTS	16	1	Workflow Engine Task Table	Administration
42	Business One	9.2	BPL1	4	1	Branch I.E. Numbers	Administration
43	Business One	9.2	BPL2	10	1	Branch Tributary Info.	Administration
44	Business One	9.2	CDPM	9	1	Dynamic Permission	Administration
45	Business One	9.2	CDRO	5	1	Drag & Relate - Output Fields	Administration
46	Business One	9.2	CDRU	4	1	Drag & Relate User Settings	Administration
47	Business One	9.2	CHEN	3	1	Caching Update Notification	Administration
48	Business One	9.2	CHFL	9	1	Choose from List Format	Administration
49	Business One	9.2	CIF1	6	1	Country Specific Information	Administration
50	Business One	9.2	CINF	210	1	Company Info	Administration
51	Business One	9.2	CPL1	8	1	Quick Copy - Instance Log	Administration
52	Business One	9.2	CPRF	15	1	Column Preferences	Administration
53	Business One	9.2	CSHS	10	2	User-Defined Values	Administration
54	Business One	9.2	CSN1	6	1	Certificate Series - Series	Administration
55	Business One	9.2	CSPI	7	1	Solution Packager Information	Administration
56	Business One	9.2	CSTN	2	2	Workstation ID	Administration
57	Business One	9.2	CTBR	8	1	Toolbars	Administration
58	Business One	9.2	CUDC	4	2	User Display Cat.	Administration
59	Business One	9.2	CUFD	18	2	User Fields - Description	Administration
60	Business One	9.2	CULG	10	1	Company Upgrade Log	Administration
61	Business One	9.2	CUMF	5	1	Folder	Administration
62	Business One	9.2	CUMI	12	2	My Menu Items	Administration
63	Business One	9.2	CUPC	4	1	Upgrade Control	Administration
64	Business One	9.2	CUVV	3	1	User Validations	Administration
65	Business One	9.2	DADB	4	1	Data Archive DSA Balance	Administration
66	Business One	9.2	DAR1	25	1	Data Archive - Transaction Log	Administration
67	Business One	9.2	DAR2	20	1	Data Archive - Transaction Log	Administration
68	Business One	9.2	DAR3	7	2	Data Archive - Handwritten Documents	Administration
69	Business One	9.2	DATB	9	1	Data Archive Tax Balance	Administration
70	Business One	9.2	DBADM	2	1	Read-Only DB User	Administration
71	Business One	9.2	DGP1	5	1	Customer List	Administration
72	Business One	9.2	DGP2	11	1	Expanded Selection Criteria	Administration
73	Business One	9.2	DGP3	4	1	Expanded Consolidation Options	Administration
74	Business One	9.2	DGP4	5	1	Business Place List	Administration
75	Business One	9.2	DGP5	4	1	Sort By List	Administration
76	Business One	9.2	DMW1	3	1	Query List	Administration
77	Business One	9.2	EOY1	1	1	End of Year UDOs	Administration
78	Business One	9.2	ERX1	7	1	Excise Registering Number-Rows	Administration
79	Business One	9.2	FML1	7	1	Tax Formula Parameter Declaration	Administration
80	Business One	9.2	FTT1	8	1	Financial Template Import - Files	Administration
81	Business One	9.2	GFL1	8	1	Grid Filter Rules	Administration
82	Business One	9.2	GFL2	5	1	Grid Filter Name	Administration
83	Business One	9.2	GPC1	4	2	Authority Assignment	Administration
84	Business One	9.2	MAP1	8	1	Input and Output of Mapping	Administration
85	Business One	9.2	MAP2	5	1	Mapping Input and Output Relation	Administration
86	Business One	9.2	MDC1	15	1	Master Data Cleanup - Log	Administration
87	Business One	9.2	MDC2	4	1	Master Data Cleanup - MD Log	Administration
88	Business One	9.2	MLS1	8	1	Distribution Lists - Recipients	Administration
89	Business One	9.2	MLT1	3	1	Translations in user language	Administration
90	Business One	9.2	NFN1	23	2	Not a Fiscal Sequence	Administration
91	Business One	9.2	NFN2	4	2	NFSeq User Default	Administration
92	Business One	9.2	NFN3	3	2	Assigned Nota Fiscal Series	Administration
93	Business One	9.2	NFN4	12	1	Manual Nota Fiscal Number	Administration
94	Business One	9.2	NNM1	26	2	Documents Numbering - Series	Administration
95	Business One	9.2	NNM2	4	2	Series Default	Administration
96	Business One	9.2	NNM3	3	2	Documents Numbering -Belgium Series	Administration
97	Business One	9.2	NNM4	10	1	Electronic Series	Administration
98	Business One	9.2	NNM5	4	2	Document Numbering - Removed Serial Numbers	Administration
99	Business One	9.2	NNM6	6	1	Documents Numbering - Supplementary Code	Administration
100	Business One	9.2	OADF	4	2	Address Formats	Administration
101	Business One	9.2	OADM	454	1	Administration	Administration
102	Business One	9.2	OADP	38	1	Print Preferences	Administration
103	Business One	9.2	OAIB	8	4	Received Alerts	Administration
104	Business One	9.2	OALC	7	2	Loading Expenses	Administration
105	Business One	9.2	OALR	14	2	Alerts	Administration
106	Business One	9.2	OALT	24	2	Alerts Template	Administration
107	Business One	9.2	OAOB	5	2	Message Sent	Administration
108	Business One	9.2	OARI	6	1	Add-On - Company Definitions	Administration
109	Business One	9.2	OATC	1	1	Attachments	Administration
110	Business One	9.2	OBDC	16	1	B1i DI Configuration	Administration
111	Business One	9.2	OBMI	8	2	Brazilian Multi-Indexer	Administration
112	Business One	9.2	OBOI	7	2	Count Widget	Administration
113	Business One	9.2	OBSI	5	2	Brazil String Indexer	Administration
114	Business One	9.2	OCCD	9	1	Cargo Customs Declaration Numbers	Administration
115	Business One	9.2	OCDP	6	2	Closing Date Procedure	Administration
116	Business One	9.2	OCDT	23	1	Credit Card Payment	Administration
117	Business One	9.2	OCFP	10	2	CFOP for Nota Fiscal	Administration
118	Business One	9.2	OCFX	4	1	Cash Flow Forecast Object Types	Administration
119	Business One	9.2	OCHF	3	1	312	Administration
120	Business One	9.2	OCIF	6	1	Configuration of Intrastat Fields	Administration
121	Business One	9.2	OCMN	10	2	Customized Menu	Administration
122	Business One	9.2	OCNA	3	2	CNAE Code	Administration
123	Business One	9.2	OCNT	8	2	Counties	Administration
124	Business One	9.2	OCPC	3	1	Quick Copy Config.	Administration
125	Business One	9.2	OCPL	15	1	Quick Copy Log Manager	Administration
126	Business One	9.2	OCRC	13	2	Credit Cards	Administration
127	Business One	9.2	OCRN	28	2	Currency Codes	Administration
128	Business One	9.2	OCRP	11	4	Payment Methods	Administration
129	Business One	9.2	OCRY	17	1	Countries	Administration
130	Business One	9.2	OCSC	7	1	Crystal Server Configuration	Administration
131	Business One	9.2	OCSN	5	4	Certificate Series	Administration
132	Business One	9.2	OCSQ	6	1	Column Sequences	Administration
133	Business One	9.2	OCST	6	1	States	Administration
134	Business One	9.2	ODAR	32	1	Data Archiving	Administration
135	Business One	9.2	ODCI	13	2	Intrastat Configuration	Administration
136	Business One	9.2	ODCR	16	1	Checking Rule	Administration
137	Business One	9.2	ODGP	55	2	Document Generation Parameter Sets	Administration
138	Business One	9.2	ODLL	3	2	Bar Code Algorithm File	Administration
139	Business One	9.2	ODMW	11	2	Data Migration	Administration
140	Business One	9.2	ODOW	10	1	Data Ownership - Objects	Administration
141	Business One	9.2	ODOX	9	1	Data Ownership - Exceptions	Administration
142	Business One	9.2	OENC	2	1	Encryption Types	Administration
143	Business One	9.2	OEOY	124	1	End-of-Year Transfer	Administration
144	Business One	9.2	OERN	7	1	Excise Register Numbering	Administration
145	Business One	9.2	OERT	5	2	Excise Register Numbering Type	Administration
146	Business One	9.2	OERX	3	2	Excise Register Numbering Ext	Administration
147	Business One	9.2	OEXD	36	2	Freight Setup	Administration
148	Business One	9.2	OFML	10	2	Tax Formula Master Table	Administration
149	Business One	9.2	OFRM	9	2	File Format	Administration
150	Business One	9.2	OFTT	2	1	Financial Template Import	Administration
151	Business One	9.2	OGFL	5	1	Grid Filter	Administration
152	Business One	9.2	OGPC	6	2	Government Payment Code	Administration
153	Business One	9.2	OGSP	3	1	Goods Shipment	Administration
154	Business One	9.2	OIDX	5	1	CPI Codes	Administration
155	Business One	9.2	OIND	3	1	Triangular Deal	Administration
156	Business One	9.2	OJPE	3	1	Local Era Calendar	Administration
157	Business One	9.2	OLLF	15	1	Legal List Format	Administration
158	Business One	9.2	OLNG	7	2	User Language Table	Administration
159	Business One	9.2	OLTB	6	2	Location-based Tax Bal Table	Administration
160	Business One	9.2	OMAO	10	1	Mobile Add-On Setting	Administration
161	Business One	9.2	OMAP	3	1	Mapping Elements	Administration
162	Business One	9.2	OMDC	6	1	Master Data Cleanup	Administration
163	Business One	9.2	OMLS	4	2	Distribution List	Administration
164	Business One	9.2	OMLT	6	2	Multi-Language Translation	Administration
165	Business One	9.2	OMPF	4	1	Message Preferences	Administration
166	Business One	9.2	OMPS	3	2	Map Services	Administration
167	Business One	9.2	OMSG	4	1	Messaging Service Settings	Administration
168	Business One	9.2	OMTP	3	1	Material Type	Administration
169	Business One	9.2	ONCM	7	2	NCM Code	Administration
170	Business One	9.2	ONFN	6	1	Nota Fiscal Numbering	Administration
171	Business One	9.2	ONFT	4	2	Nota Fiscal Tax Category (Brazil)	Administration
172	Business One	9.2	ONNM	8	1	Document Numbering	Administration
173	Business One	9.2	ONOA	4	2	Nature of Assessee	Administration
174	Business One	9.2	OOCC	6	2	BoE Occurrence Code	Administration
175	Business One	9.2	OPCI	12	1	Process Checklist Instance	Administration
176	Business One	9.2	OPCT	4	2	Process Checklist Template	Administration
177	Business One	9.2	OPID	1	1	Period Indicator	Administration
178	Business One	9.2	OPJT	9	2	Project Plan	Administration
179	Business One	9.2	OPOS	5	1	POS Master Data	Administration
180	Business One	9.2	OPPA	11	1	Password Administration	Administration
181	Business One	9.2	OPQW	12	2	Purchase Quotation Generation: Parameter Sets	Administration
182	Business One	9.2	OPRF	17	1	Preferences	Administration
183	Business One	9.2	OPRO	9	2	Property Object	Administration
184	Business One	9.2	OPVL	5	2	Lender - Pelecard	Administration
185	Business One	9.2	ORIT	5	1	Dunning Interest Rate	Administration
186	Business One	9.2	ORLD	4	2	Reference Links Definition	Administration
187	Business One	9.2	ORMK	3	2	Remark 1	Administration
188	Business One	9.2	OSEC	4	3	Sections	Administration
189	Business One	9.2	OSHP	5	2	Delivery Types	Administration
190	Business One	9.2	OSRL	5	3	Serial Numbers	Administration
191	Business One	9.2	OSSP	3	1	Service Supply	Administration
192	Business One	9.2	OSTA	26	1	Sales Tax Authorities	Administration
193	Business One	9.2	OSTC	17	1	Sales Tax Codes	Administration
194	Business One	9.2	OSTT	12	2	Sales Tax Authorities Type	Administration
195	Business One	9.2	OSUS	6	1	Support Usage Statistics	Administration
196	Business One	9.2	OTCD	4	2	Tax Code Determination	Administration
197	Business One	9.2	OTCX	38	1	Tax Code Determination	Administration
198	Business One	9.2	OTFC	3	2	Tax Type Combination	Administration
199	Business One	9.2	OTIZ	5	1	Company Time Zone	Administration
200	Business One	9.2	OTNC	3	2	Transaction Category	Administration
201	Business One	9.2	OTNN	4	2	1099 Forms	Administration
202	Business One	9.2	OTOB	6	1	1099 Opening Balance	Administration
203	Business One	9.2	OTPA	6	2	Tax Parameter Attributes	Administration
204	Business One	9.2	OTPL	4	2	Import Template	Administration
205	Business One	9.2	OTPR	7	2	Tax Return Values	Administration
206	Business One	9.2	OTPS	3	2	Tax Parameter	Administration
207	Business One	9.2	OTRN	7	2	Multilingual Service Table	Administration
208	Business One	9.2	OTSC	12	2	CST Code for Nota Fiscal	Administration
209	Business One	9.2	OUDG	36	1	User Defaults	Administration
210	Business One	9.2	OUDO	29	2	User-Defined Object	Administration
211	Business One	9.2	OUKD	5	1	User Key Description	Administration
212	Business One	9.2	OULA	15	1	EULA	Administration
213	Business One	9.2	OUPT	9	1	User Autorization Tree	Administration
214	Business One	9.2	OUSG	16	1	Usage of Nota Fiscal	Administration
215	Business One	9.2	OUSR	101	4	Users	Administration
216	Business One	9.2	OUTB	8	1	User Tables	Administration
217	Business One	9.2	OVNM	7	1	VAT Report Numbering	Administration
218	Business One	9.2	OWEX	11	1	Workflow Engine Execution Entity	Administration
219	Business One	9.2	OWFER	12	1	Workflow Error Message	Administration
220	Business One	9.2	OWFI	10	1	Workflow - Instances	Administration
221	Business One	9.2	OWIN	11	1	Workflow Engine Information	Administration
222	Business One	9.2	OWJB	8	1	Workflow Job Entity	Administration
223	Business One	9.2	OWLS	33	1	Workflow - Task Details	Administration
224	Business One	9.2	OWMG	11	1	Workflow Manager	Administration
225	Business One	9.2	OWST	6	2	Confirmation Level	Administration
226	Business One	9.2	OWTI	15	1	Workflow Timer Definition	Administration
227	Business One	9.2	OWTJ	9	1	Workflow Timer Job	Administration
228	Business One	9.2	OWTM	7	2	Approval Templates	Administration
229	Business One	9.2	OWTS	16	1	Workflow Engine Task Table	Administration
230	Business One	9.2	PCI1	7	1	Process Checklist Element Extended Data	Administration
231	Business One	9.2	PJT1	20	1	Project Plan Steps	Administration
232	Business One	9.2	PJT2	10	1	Project Plan Steps Time Record	Administration
233	Business One	9.2	PQW1	23	1	Purchase Quotation Generation: Line Items	Administration
234	Business One	9.2	RIT1	6	1	Interest Rates	Administration
235	Business One	9.2	RLD1	6	1	Reference Links Definition	Administration
236	Business One	9.2	SDEX	8	1	Dynamic Extensions	Administration
237	Business One	9.2	SDIS	8	1	Dynamic Interface (Strings)	Administration
238	Business One	9.2	SMSG	2	1	SMSG	Administration
239	Business One	9.2	SPRG	8	1	Application Start	Administration
240	Business One	9.2	STA1	4	1	Valid Period	Administration
241	Business One	9.2	STC1	11	2	Sales Tax Codes - Rows	Administration
242	Business One	9.2	TCD1	16	2	Key Fields for Determination	Administration
243	Business One	9.2	TCD2	7	2	Key Field Values	Administration
244	Business One	9.2	TCD3	5	2	Tax Code Determination	Administration
245	Business One	9.2	TCD4	4	1	Withholding Tax Code Determination	Administration
246	Business One	9.2	TCD5	6	1	Tax Code by Usage	Administration
247	Business One	9.2	TDR1	12	1	Can Be Archive	Administration
248	Business One	9.2	TFC1	4	2	Tax Type Combination - Rows	Administration
249	Business One	9.2	TNN1	6	1	1099 Boxes	Administration
250	Business One	9.2	TPL1	5	1	Template - Records	Administration
251	Business One	9.2	TPS1	4	2	Tax Parameter Attributes	Administration
252	Business One	9.2	TPS2	3	2	Tax Parameter - Return Values	Administration
253	Business One	9.2	TRN1	8	2	Subtable of OTRN	Administration
254	Business One	9.2	TRN2	5	2	Subtable of OTRN	Administration
255	Business One	9.2	UDG1	15	1	User Defaults - Documents	Administration
256	Business One	9.2	UDG2	3	1	User Defaults - Credit Cards	Administration
257	Business One	9.2	UDO1	5	1	User-Defined Objects - Child	Administration
258	Business One	9.2	UDO2	4	1	User-Defined Objects - Find Columns	Administration
259	Business One	9.2	UDO3	6	1	User-Defined Objects - Found Columns	Administration
260	Business One	9.2	UDO4	7	1	User-Defined Objects - Child Table Columns	Administration
261	Business One	9.2	UFD1	6	1	User Fields - Values Definitions	Administration
262	Business One	9.2	UGR1	3	1	Group Authorization	Administration
263	Business One	9.2	UKD1	4	2	User Sub-Keys Description	Administration
264	Business One	9.2	UPT1	3	2	User Authorization Tree - Extended Permission	Administration
265	Business One	9.2	USR1	43	1	Short Cut	Administration
266	Business One	9.2	USR2	11	1	Run External Application	Administration
267	Business One	9.2	USR3	3	1	User Authorization	Administration
268	Business One	9.2	USR5	14	1	User Access Log	Administration
269	Business One	9.2	VIEWS	3	1	SQL Company Views	Administration
270	Business One	9.2	WLS1	7	1	Potential Processor of Tasks	Administration
271	Business One	9.2	WLS2	9	1	Input data for tasks	Administration
272	Business One	9.2	WLS3	8	1	Notes of Tasks	Administration
273	Business One	9.2	WLS4	8	1	Task Output Data	Administration
274	Business One	9.2	WLS5	7	1	Task Field Mapping Information	Administration
275	Business One	9.2	WST1	2	1	Confirmation Level - Rows	Administration
276	Business One	9.2	WTM1	2	1	Approval Templates - Producers	Administration
277	Business One	9.2	WTM2	4	1	Confirmation Templates - Stages	Administration
278	Business One	9.2	WTM3	2	1	Approval Templates - Documents	Administration
279	Business One	9.2	WTM4	4	1	Approval Templates - Terms	Administration
280	Business One	9.2	WTM5	2	1	Approval Templates - Queries	Administration

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

280 tablesB1 9.2