	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

177 columns | B1 8.82 | PROJECT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAdministration
1	AEXD	Freight Setup	35	Project	Project	nVarChar	20	0
2	OEXD	Freight Setup	35	Project	Project	nVarChar	20	0
TOPBanking
3	ABT1	Internal Bank Operation Codes - Accounts - Log	4	Project	Project	nVarChar	20	0
4	ARC4	Incoming Payment - Account List - History	14	Project	Project Code	nVarChar	20	0
5	BNK2	Bank Statement - Recommendation List	11	Project	Project	nVarChar	20	0
6	BTC1	Internal Bank Operation Codes - Accounts	4	Project	Project	nVarChar	20	0
7	OCHH	Check Register	28	Project	Project Code	nVarChar	20	0
8	OCRH	Credit Card Management	38	Project	Project Code	nVarChar	20	0
9	ODPS	Deposit	52	Project	Project Code	nVarChar	20	0
10	ODPT	Postdated Deposit	28	Project	Project Code	nVarChar	20	0
11	PDF4	Payment Draft - Account List	14	Project	Project Code	nVarChar	20	0
12	RCC4	Incoming Payment - Credit Vouchers	14	Project	Project Code	nVarChar	20	0
13	RCT4	Incoming Payment - Account List	14	Project	Project Code	nVarChar	20	0
14	VPM4	Outgoing Payments - Accounts	14	Project	Project Code	nVarChar	20	0
TOPFinance
15	AACT	G/L Account - History	43	Project	Project Code	nVarChar	20	0
16	AJD1	Journal Entry - History - Rows	27	Project	Project Code	nVarChar	20	0
17	AJDT	Journal Entry - History	19	Project	Project Code	nVarChar	20	0
18	BTF1	Journal Voucher	27	Project	Project Code	nVarChar	20	0
19	JDT1	Journal Entry - Rows	27	Project	Project Code	nVarChar	20	0
20	OACT	G/L Accounts	43	Project	Project Code	nVarChar	20	0
21	OBTF	Journal Voucher Entry	19	Project	Project Code	nVarChar	20	0
22	OJDT	Journal Entry	19	Project	Project Code	nVarChar	20	0
23	RCR1	Recurring Postings - Rows	27	Project	Project Code	nVarChar	20	0
24	TRT1	Posting Templates - Rows	25	Project	Project Code	nVarChar	20	0
TOPInventory and Production
25	AITT	Product Tree - History	24	Project	Project Code	nVarChar	20	0
26	AMR1	Inventory Revaluation - History - Rows	23	Project	Project Code	nVarChar	20	0
27	ATT1	Bill of Materials - Component Items - History	22	Project	Project Code	nVarChar	20	0
28	AWO1	Production Order (Rows) - History	20	Project	Project Code	nVarChar	20	0
29	AWOR	Production Order - History	41	Project	Project Code	nVarChar	20	0
30	IGE1	Goods Issue - Rows	43	Project	Project Code	nVarChar	20	0
31	IGE13	Goods Issue Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
32	IGE2	Goods Issue - Freight - Rows	51	Project	Project Code	nVarChar	20	0
33	IGE3	Goods Issue - Freight	59	Project	Project Code	nVarChar	20	0
34	IGN1	Goods Receipt - Rows	43	Project	Project Code	nVarChar	20	0
35	IGN13	Goods Receipt Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
36	IGN2	Goods Receipt - Freight - Rows	51	Project	Project Code	nVarChar	20	0
37	IGN3	Goods Receipt - Freight	59	Project	Project Code	nVarChar	20	0
38	IPF1	Landed Costs - Rows	67	Project	Project Code	nVarChar	20	0
39	IQI1	Inventory Initial Qty Rows	23	Project	Project Code	nVarChar	20	0
40	IQR1	Inventory Stock Posting (Reconcile) Lines	23	Project	Project Code	nVarChar	20	0
41	ITT1	Bill of Materials - Component Items	22	Project	Project Code	nVarChar	20	0
42	MRV1	Inventory Revaluation Information Array	23	Project	Project Code	nVarChar	20	0
43	OIGE	Goods Issue	136	Project	Project Code	nVarChar	20	0
44	OIGN	Goods Receipt	136	Project	Project Code	nVarChar	20	0
45	OITT	Product Tree	24	Project	Project Code	nVarChar	20	0
46	OMRL	Advanced Inventory Revaluation	32	Project	Project Code	nVarChar	20	0
47	OWOR	Production Order	41	Project	Project Code	nVarChar	20	0
48	OWTQ	Inventory Transfer Request	136	Project	Project Code	nVarChar	20	0
49	OWTR	Inventory Transfer	136	Project	Project Code	nVarChar	20	0
50	TMP1	Bill of Materials - Component Items	22	Project	Project Code	nVarChar	20	0
51	UWOR	Production Order	41	Project	Project Code	nVarChar	20	0
52	UWOR1	Production Order - Rows	20	Project	Project Code	nVarChar	20	0
53	WOR1	Production Order - Rows	20	Project	Project Code	nVarChar	20	0
54	WTQ1	Inventory Transfer Request - Rows	43	Project	Project Code	nVarChar	20	0
55	WTQ13	Inventory Transfer Request Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
56	WTQ2	Inventory Transfer Request - Freight - Rows	51	Project	Project Code	nVarChar	20	0
57	WTQ3	Inventory Transfer Request - Freight	59	Project	Drawn Total	nVarChar	20	0
58	WTR1	Inventory Transfer - Rows	43	Project	Project Code	nVarChar	20	0
59	WTR13	Inventory Transfer Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
60	WTR2	Inventory Transfer - Freight - Rows	51	Project	Project Code	nVarChar	20	0
61	WTR3	Inventory Transfer - Freight	59	Project	Project Code	nVarChar	20	0
TOPMarketing Documents
62	ADO1	A/R Invoice (Rows) - History	43	Project	Project Code	nVarChar	20	0
63	ADO13	A/R Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
64	ADO2	A/R Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
65	ADO3	A/R Invoice - Freight - History	59	Project	Project Code	nVarChar	20	0
66	ADOC	Invoice - History	136	Project	Project Code	nVarChar	20	0
67	CIN1	Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
68	CIN13	Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
69	CIN2	A/R Correction Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
70	CIN3	A/R Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
71	CPI1	A/P Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
72	CPI13	A/P Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
73	CPI2	A/P Correction Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
74	CPI3	A/P Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
75	CPV1	A/P Correction Invoice Reversal - Rows	43	Project	Project Code	nVarChar	20	0
76	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
77	CPV2	A/P Correction Invoice Reversal - Freight - Rows	51	Project	Project Code	nVarChar	20	0
78	CPV3	A/P Correction Invoice Reversal - Freight	59	Project	Project Code	nVarChar	20	0
79	CSI1	A/R Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
80	CSI13	A/R Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
81	CSI2	A/R Corr Inv - Freight - Rows	51	Project	Project Code	nVarChar	20	0
82	CSI3	A/R Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
83	CSV1	A/R Correction Invoice Reversal - Rows	43	Project	Project Code	nVarChar	20	0
84	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
85	CSV2	A/R Correction Invoice Reversal - Freight - Rows	51	Project	Project Code	nVarChar	20	0
86	CSV3	A/R Correction Invoice Reversal - Freight	59	Project	Project Code	nVarChar	20	0
87	DLN1	Delivery - Rows	43	Project	Project Code	nVarChar	20	0
88	DLN13	Delivery Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
89	DLN2	Delivery Notes - Freight - Rows	51	Project	Project Code	nVarChar	20	0
90	DLN3	Delivery Notes - Freight	59	Project	Project Code	nVarChar	20	0
91	DPI1	A/R Down Payment - Rows	43	Project	Project Code	nVarChar	20	0
92	DPI13	A/R Down Payment Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
93	DPI2	A/R Down Payment - Freight - Rows	51	Project	Project Code	nVarChar	20	0
94	DPI3	A/R Down Payment - Freight	59	Project	Project Code	nVarChar	20	0
95	DPO1	A/P Down Payment - Rows	43	Project	Project Code	nVarChar	20	0
96	DPO13	A/P Down Payment Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
97	DPO2	A/P Down Payment - Freight - Rows	51	Project	Project Code	nVarChar	20	0
98	DPO3	A/P Down Payment - Freight	59	Project	Project Code	nVarChar	20	0
99	DRF1	Draft - Rows	43	Project	Project Code	nVarChar	20	0
100	DRF13	Draft Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
101	DRF2	Draft - Freight - Rows	51	Project	Project Code	nVarChar	20	0
102	DRF3	Draft - Freight	59	Project	Project Code	nVarChar	20	0
103	IEI1	Incoming Excise Invoice - Rows	43	Project	Project Code	nVarChar	20	0
104	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
105	IEI2	Incoming Excise Invoice - Freight - History - Rows	51	Project	Project Code	nVarChar	20	0
106	IEI3	IEI - Freight	59	Project	Project Code	nVarChar	20	0
107	INV1	A/R Invoice - Rows	43	Project	Project Code	nVarChar	20	0
108	INV13	A/R Invoice Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
109	INV2	A/R Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
110	INV3	A/R Invoice - Freight	59	Project	Project Code	nVarChar	20	0
111	OCIN	A/R Correction Invoice	136	Project	Project Code	nVarChar	20	0
112	OCPI	A/P Correction Invoice	136	Project	Project Code	nVarChar	20	0
113	OCPV	A/P Correction Invoice Reversal	136	Project	Project Code	nVarChar	20	0
114	OCSI	A/R Correction Invoice	136	Project	Project Code	nVarChar	20	0
115	OCSV	A/R Correction Invoice Reversal	136	Project	Project Code	nVarChar	20	0
116	ODLN	Delivery	136	Project	Project Code	nVarChar	20	0
117	ODPI	A/R Down Payment	136	Project	Project Code	nVarChar	20	0
118	ODPO	A/P Down Payment	136	Project	Project Code	nVarChar	20	0
119	ODRF	Drafts	136	Project	Project Code	nVarChar	20	0
120	ODWZ	Dunning Wizard	24	Project	Project	nVarChar	20	0
121	OEI1	Outgoing Excise Invoice - Rows	43	Project	Project Code	nVarChar	20	0
122	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
123	OEI2	OEI - Freight Rows	51	Project	Project Code	nVarChar	20	0
124	OEI3	OEI - Freight	59	Project	Project Code	nVarChar	20	0
125	OIEI	Incoming Excise Invoice	136	Project	Project Code	nVarChar	20	0
126	OINV	A/R Invoice	136	Project	Project Code	nVarChar	20	0
127	OOEI	Outgoing Excise Invoice	136	Project	Project Code	nVarChar	20	0
128	OPCH	A/P Invoice	136	Project	Project Code	nVarChar	20	0
129	OPDN	Goods Receipt PO	136	Project	Project Code	nVarChar	20	0
130	OPOR	Purchase Order	136	Project	Project Code	nVarChar	20	0
131	OPQT	Purchase Quotation	136	Project	Project Code	nVarChar	20	0
132	OQUT	Sales Quotation	136	Project	Project Code	nVarChar	20	0
133	ORDN	Returns	136	Project	Project Code	nVarChar	20	0
134	ORDR	Sales Order	136	Project	Project Code	nVarChar	20	0
135	ORIN	A/R Credit Memo	136	Project	Project Code	nVarChar	20	0
136	ORPC	A/P Credit Memo	136	Project	Project Code	nVarChar	20	0
137	ORPD	Goods Return	136	Project	Project Code	nVarChar	20	0
138	PCH1	A/P Invoice - Rows	43	Project	Project Code	nVarChar	20	0
139	PCH13	A/P Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
140	PCH2	A/P Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
141	PCH3	A/P Invoice - Freight	59	Project	Project Code	nVarChar	20	0
142	PDN1	Goods Receipt PO - Rows	43	Project	Project Code	nVarChar	20	0
143	PDN13	Goods Receipt PO Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
144	PDN2	Goods Receipt PO - Freight - Rows	51	Project	Project Code	nVarChar	20	0
145	PDN3	Goods Receipt PO - Freight	59	Project	Project Code	nVarChar	20	0
146	POR1	Purchase Order - Rows	43	Project	Project Code	nVarChar	20	0
147	POR13	Purchase Order Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
148	POR2	Purchase Order - Freight - Rows	51	Project	Project Code	nVarChar	20	0
149	POR3	Purchase Order - Freight	59	Project	Project Code	nVarChar	20	0
150	PQT1	Purchase Quotation - Rows	43	Project	Project Code	nVarChar	20	0
151	PQT13	Purchase Quotation Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
152	PQT2	Purchase Quotation - Freight - Rows	51	Project	Project Code	nVarChar	20	0
153	PQT3	Purchase Quotation - Freight	59	Project	Project Code	nVarChar	20	0
154	QUT1	Sales Quotation - Rows	43	Project	Project Code	nVarChar	20	0
155	QUT13	Sales Quotation Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
156	QUT2	Sales Quotation - Freight - Rows	51	Project	Project Code	nVarChar	20	0
157	QUT3	Sales Quotation - Freight	59	Project	Project Code	nVarChar	20	0
158	RDN1	Returns - Rows	43	Project	Project Code	nVarChar	20	0
159	RDN13	Returns Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
160	RDN2	Return - Freight - Rows	51	Project	Project Code	nVarChar	20	0
161	RDN3	Return - Freight	59	Project	Project Code	nVarChar	20	0
162	RDR1	Sales Order - Rows	43	Project	Project Code	nVarChar	20	0
163	RDR13	Sales Order Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
164	RDR2	Sales Order - Freight - Rows	51	Project	Project Code	nVarChar	20	0
165	RDR3	Sales Order - Freight	59	Project	Project Code	nVarChar	20	0
166	RIN1	A/R Credit Memo - Rows	43	Project	Project Code	nVarChar	20	0
167	RIN13	A/R Credit Memo Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
168	RIN2	A/R Credit Memo - Freight - Rows	51	Project	Project Code	nVarChar	20	0
169	RIN3	A/R Credit Memo - Freight	59	Project	Project Code	nVarChar	20	0
170	RPC1	A/P Credit Memo - Rows	43	Project	Project Code	nVarChar	20	0
171	RPC13	A/P Credit Memo Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
172	RPC2	A/P Credit Memo Rows - Expenses	51	Project	Project Code	nVarChar	20	0
173	RPC3	A/P Credit Memo - Freight	59	Project	Project Code	nVarChar	20	0
174	RPD1	Goods Return - Rows	43	Project	Project Code	nVarChar	20	0
175	RPD13	Goods Returns Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
176	RPD2	Goods Return - Freight - Rows	51	Project	Project Code	nVarChar	20	0
177	RPD3	Goods Return - Freight	59	Project	Project Code	nVarChar	20	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

177 columns | B1 8.82 | PROJECT