	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

134 columns | B1 9.3 | DOCDATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAdministration
1	OCCD	Cargo Customs Declaration Numbers	5	DocDate	Imp./Exp. Document Date	Date	8	0
TOPBanking
2	ARCT	Incoming Payment - History	7	DocDate	Posting Date	Date	8	0
3	OPDF	Payment Draft	7	DocDate	Posting Date	Date	8	0
4	ORCT	Incoming Payment	7	DocDate	Posting Date	Date	8	0
5	OVPM	Outgoing Payments	7	DocDate	Posting Date	Date	8	0
6	PEX1	Payment Results Table - Rows	12	DocDate	Document Posting Date	Date	8	0
TOPFinance
7	AFAD	Asset Document - History	7	DocDate	Document Date	Date	8	0
8	GBI7	GBI Row 7 - Accounting Vouchers	3	DocDate	Document Date	nVarChar	8	0
9	OACD	Credit Memo	7	DocDate	Document Date	Date	8	0
10	OACQ	Capitalization	7	DocDate	Document Date	Date	8	0
11	OFAR	Fixed Asset Revaluation	13	DocDate	Document Date	Date	8	0
12	OFTR	Transfer	7	DocDate	Document Date	Date	8	0
13	OJST	TDS Adjustment	2	DocDate	Posting Date	Date	8	0
14	OMDP	Manual Depreciation	7	DocDate	Document Date	Date	8	0
15	ORTI	Retirement	7	DocDate	Document Date	Date	8	0
16	OSLM	Special Ledger - Analytical Accounting Report: Material	2	DocDate	Date of Report Generation	Date	8	0
17	OSLR	Special Ledger - Analytical Accounting Report: Revenues & Expenses	2	DocDate	Date of Report Generation	Date	8	0
18	OZRD	POS Daily Summary	2	DocDate	Document Date	Date	8	0
19	VRW2	VAT Reposting Wizard - Rows 2	7	DocDate	Document Date	Date	8	0
TOPGeneral
20	AIRI	Input Service Distribution - Recipient Invoice	5	DocDate	Document Date	Date	8	0
21	AIRR	Input Service Distribution - Recipient Credit Memo	5	DocDate	Document Date	Date	8	0
22	AISC	Input Service Distribution - Credit Memo	5	DocDate	Document Date	Date	8	0
23	AISD	Input Service Distribution	7	DocDate	Document Date	Date	8	0
24	AISI	Input Service Distribution - Invoice	5	DocDate	Document Date	Date	8	0
25	APH4	Project Management - Stages - Documents - History	7	DocDate	Document Date	Date	8	0
26	APM4	Project Management - Stages - Documents - History	7	DocDate	Document Date	Date	8	0
27	OIRI	Input Service Distribution - Recipient Invoice	5	DocDate	Document Date	Date	8	0
28	OIRR	Input Service Distribution - Recipient Credit Memo	5	DocDate	Document Date	Date	8	0
29	OISC	Input Service Distribution - Credit Memo	5	DocDate	Document Date	Date	8	0
30	OISD	Input Service Distribution	7	DocDate	Document Date	Date	8	0
31	OISI	Input Service Distribution - Invoice	5	DocDate	Document Date	Date	8	0
32	PHA4	Project Management - Stages - Documents	7	DocDate	Document Date	Date	8	0
33	PMG4	Project Management - Stages - Documents	7	DocDate	Document Date	Date	8	0
TOPInventory and Production
34	AIQI	Inventory Opening Balance	6	DocDate	Posting Date	Date	8	0
35	AIQR	Inventory Posting	6	DocDate	Posting Date	Date	8	0
36	AMRV	Inventory Revaluation - History	3	DocDate	Posting Date	Date	8	0
37	IGE1	Goods Issue - Rows	33	DocDate	Posting Date	Date	8	0
38	IGN1	Goods Receipt - Rows	33	DocDate	Posting Date	Date	8	0
39	OAIM	Archive Inventory Message	19	DocDate	Document Date	Date	8	0
40	OENT	Shipping Types	6	DocDate	Posting Date	Date	8	0
41	OIGE	Goods Issue	11	DocDate	Posting Date	Date	8	0
42	OIGN	Goods Receipt	11	DocDate	Posting Date	Date	8	0
43	OILM	Inventory Log Message	24	DocDate	Doc Date	Date	8	0
44	OIOD	Inventory Opening Balance Draft	6	DocDate	Posting Date	Date	8	0
45	OIPD	Inventory Posting Draft	6	DocDate	Posting Date	Date	8	0
46	OIPF	Landed Costs	3	DocDate	Posting Date	Date	8	0
47	OIQI	Inventory Opening Balance	6	DocDate	Posting Date	Date	8	0
48	OIQR	Inventory Posting	6	DocDate	Posting Date	Date	8	0
49	OITL	Inventory Transactions Log	16	DocDate	Doc. Posting Date	Date	8	0
50	OIVL	Whse Journal	5	DocDate	Posting Date	Date	8	0
51	OMRL	Advanced Inventory Revaluation	4	DocDate	Posting Date	Date	8	0
52	OMRV	Inventory Revaluation	3	DocDate	Posting Date	Date	8	0
53	OWTQ	Inventory Transfer Request	11	DocDate	Posting Date	Date	8	0
54	OWTR	Inventory Transfer	11	DocDate	Posting Date	Date	8	0
55	SIVL	Whse Journal	5	DocDate	Posting Date	Date	8	0
56	UILM	IVI Inventory Log Message	24	DocDate	Doc Date	Date	8	0
57	UIVL	Whse Journal	5	DocDate	Posting Date	Date	8	0
58	WTQ1	Inventory Transfer Request - Rows	33	DocDate	Posting Date	Date	8	0
59	WTR1	Inventory Transfer - Rows	33	DocDate	Posting Date	Date	8	0
TOPMarketing Documents
60	ADO1	A/R Invoice (Rows) - History	33	DocDate	Posting Date	Date	8	0
61	ADOC	Invoice - History	11	DocDate	Posting Date	Date	8	0
62	ATXI	Tax Invoice - History	9	DocDate	Posting Date	Date	8	0
63	CIN1	Correction Invoice - Rows	33	DocDate	Posting Date	Date	8	0
64	CPI1	A/P Correction Invoice - Rows	33	DocDate	Posting Date	Date	8	0
65	CPV1	A/P Correction Invoice Reversal - Rows	33	DocDate	Posting Date	Date	8	0
66	CSI1	A/R Correction Invoice - Rows	33	DocDate	Posting Date	Date	8	0
67	CSV1	A/R Correction Invoice Reversal - Rows	33	DocDate	Posting Date	Date	8	0
68	DLN1	Delivery - Rows	33	DocDate	Posting Date	Date	8	0
69	DPI1	A/R Down Payment - Rows	33	DocDate	Posting Date	Date	8	0
70	DPO1	A/P Down Payment - Rows	33	DocDate	Posting Date	Date	8	0
71	DRF1	Draft - Rows	33	DocDate	Posting Date	Date	8	0
72	GPA3	Gross Profit Adjustment - JE Details	3	DocDate	Document Date	Date	8	0
73	GPA7	Product Cost Adjustment - Journal Entry Details	3	DocDate	Document Date	Date	8	0
74	IEI1	Incoming Excise Invoice - Rows	33	DocDate	Posting Date	Date	8	0
75	INV1	A/R Invoice - Rows	33	DocDate	Posting Date	Date	8	0
76	MIN1	Monthly Invoice Report Document Information	5	DocDate	Document Posting Date	Date	8	0
77	MIN2	Item Imformation of MI	4	DocDate	Document Date	Date	8	0
78	MIV1	A/P Monthly Invoice - Document	5	DocDate	Document Posting Date	Date	8	0
79	MIV2	A/P Monthly Invoice - Item	4	DocDate	Document Date	Date	8	0
80	OCIN	A/R Correction Invoice	11	DocDate	Posting Date	Date	8	0
81	OCPI	A/P Correction Invoice	11	DocDate	Posting Date	Date	8	0
82	OCPV	A/P Correction Invoice Reversal	11	DocDate	Posting Date	Date	8	0
83	OCSI	A/R Correction Invoice	11	DocDate	Posting Date	Date	8	0
84	OCSV	A/R Correction Invoice Reversal	11	DocDate	Posting Date	Date	8	0
85	ODLN	Delivery	11	DocDate	Posting Date	Date	8	0
86	ODPI	A/R Down Payment	11	DocDate	Posting Date	Date	8	0
87	ODPO	A/P Down Payment	11	DocDate	Posting Date	Date	8	0
88	ODRF	Drafts	11	DocDate	Posting Date	Date	8	0
89	OEI1	Outgoing Excise Invoice - Rows	33	DocDate	Posting Date	Date	8	0
90	OGTI	GTS Invoice	9	DocDate	Document Date	Date	8	0
91	OIEI	Incoming Excise Invoice	11	DocDate	Posting Date	Date	8	0
92	OINV	A/R Invoice	11	DocDate	Posting Date	Date	8	0
93	OOEI	Outgoing Excise Invoice	11	DocDate	Posting Date	Date	8	0
94	OPCH	A/P Invoice	11	DocDate	Posting Date	Date	8	0
95	OPDN	Goods Receipt PO	11	DocDate	Posting Date	Date	8	0
96	OPOR	Purchase Order	11	DocDate	Posting Date	Date	8	0
97	OPQN	Purchase Quotation Group	2	DocDate	Posting Date	Date	8	0
98	OPQT	Purchase Quotation	11	DocDate	Posting Date	Date	8	0
99	OPRQ	Purchase Request	11	DocDate	Posting Date	Date	8	0
100	OPRR	Goods Return Request	11	DocDate	Posting Date	Date	8	0
101	OQUT	Sales Quotation	11	DocDate	Posting Date	Date	8	0
102	ORDN	Returns	11	DocDate	Posting Date	Date	8	0
103	ORDR	Sales Order	11	DocDate	Posting Date	Date	8	0
104	ORIN	A/R Credit Memo	11	DocDate	Posting Date	Date	8	0
105	ORPC	A/P Credit Memo	11	DocDate	Posting Date	Date	8	0
106	ORPD	Goods Return	11	DocDate	Posting Date	Date	8	0
107	ORRR	Return Request	11	DocDate	Posting Date	Date	8	0
108	OSAL	Outgoing	6	DocDate	Posting Date	Date	8	0
109	OSFC	Self Credit Memo	11	DocDate	Posting Date	Date	8	0
110	OSFI	Self Invoice	11	DocDate	Posting Date	Date	8	0
111	OTPI	Purchase Tax Invoice	9	DocDate	Posting Date	Date	8	0
112	OTRA	Transition	6	DocDate	Posting Date	Date	8	0
113	OTSI	Sales Tax Invoice	9	DocDate	Posting Date	Date	8	0
114	OTXD	Tax Invoice Draft	9	DocDate	Posting Date	Date	8	0
115	OWDD	Docs. for Confirmation	6	DocDate	Posting Date	Date	8	0
116	PCH1	A/P Invoice - Rows	33	DocDate	Posting Date	Date	8	0
117	PDN1	Goods Receipt PO - Rows	33	DocDate	Posting Date	Date	8	0
118	POR1	Purchase Order - Rows	33	DocDate	Posting Date	Date	8	0
119	PQT1	Purchase Quotation - Rows	33	DocDate	Posting Date	Date	8	0
120	PRQ1	Purchase Request - Rows	33	DocDate	Posting Date	Date	8	0
121	PRR1	A/P Return Request - Rows	33	DocDate	Posting Date	Date	8	0
122	QUT1	Sales Quotation - Rows	33	DocDate	Posting Date	Date	8	0
123	RDN1	Returns - Rows	33	DocDate	Posting Date	Date	8	0
124	RDR1	Sales Order - Rows	33	DocDate	Posting Date	Date	8	0
125	RIN1	A/R Credit Memo - Rows	33	DocDate	Posting Date	Date	8	0
126	RPC1	A/P Credit Memo - Rows	33	DocDate	Posting Date	Date	8	0
127	RPD1	Goods Return - Rows	33	DocDate	Posting Date	Date	8	0
128	RRR1	A/R Return Request - Rows	33	DocDate	Posting Date	Date	8	0
129	SFC1	Self Credit Memo - Rows	33	DocDate	Posting Date	Date	8	0
130	SFI1	Self Invoice - Rows	33	DocDate	Posting Date	Date	8	0
131	VRT2	Tax Invoice Report Grid Info	6	DocDate	Doc. Date	Date	8	0
TOPMRP
132	ORCM	Recommendation Data	16	DocDate	Generation Date	Date	8	0
TOPReports
133	EML1	E-mail Log - Rows	4	DocDate	Posting Date	Date	8	0
134	SOI4	Statement of Import - Invoices	6	DocDate	Posting Date	Date	8	0

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

134 columns | B1 9.3 | DOCDATE