	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

219 columns | B1 9.3 | 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
3	PQW1	Purchase Quotation Generation: Line Items	20	Project	Project Code	nVarChar	20	0
TOPBanking
4	ABT1	Internal Bank Operation Codes - Accounts - Log	4	Project	Project	nVarChar	20	0
5	ARC4	Incoming Payment - Account List - History	14	Project	Project Code	nVarChar	20	0
6	BNK2	Bank Statement - Recommendation List	11	Project	Project	nVarChar	20	0
7	BTC1	Internal Bank Operation Codes - Accounts	4	Project	Project	nVarChar	20	0
8	OCHH	Check Register	28	Project	Project Code	nVarChar	20	0
9	OCRH	Credit Card Management	38	Project	Project Code	nVarChar	20	0
10	ODPS	Deposit	52	Project	Project Code	nVarChar	20	0
11	ODPT	Postdated Deposit	28	Project	Project Code	nVarChar	20	0
12	PDF4	Payment Draft - Account List	14	Project	Project Code	nVarChar	20	0
13	RCC4	Incoming Payment - Credit Vouchers	14	Project	Project Code	nVarChar	20	0
14	RCT4	Incoming Payment - Account List	14	Project	Project Code	nVarChar	20	0
15	VPM4	Outgoing Payments - Accounts	14	Project	Project Code	nVarChar	20	0
TOPBusiness Partners
16	AOA1	Blanket Agreement - Rows	29	Project	Project Code	nVarChar	20	0
17	AOAT	Blanket Agreement	48	Project	Project Code	nVarChar	20	0
18	OAT1	Blanket Agreement - Rows	29	Project	Project Code	nVarChar	20	0
19	OOAT	Blanket Agreement	48	Project	Project Code	nVarChar	20	0
TOPFinance
20	AACT	G/L Account - History	43	Project	Project Code	nVarChar	20	0
21	ACD1	Credit Memo - Rows	23	Project	Project Code	nVarChar	20	0
22	ACQ1	Capitalization - Rows	23	Project	Project Code	nVarChar	20	0
23	AFA1	Asset Document - Rows	23	Project	Project Code	nVarChar	20	0
24	AJD1	Journal Entry - History - Rows	27	Project	Project Code	nVarChar	20	0
25	AJDT	Journal Entry - History	19	Project	Project Code	nVarChar	20	0
26	BTF1	Journal Voucher - Rows	27	Project	Project Code	nVarChar	20	0
27	FTR1	Transfer - Rows	23	Project	Project Code	nVarChar	20	0
28	JDT1	Journal Entry - Rows	27	Project	Project Code	nVarChar	20	0
29	MDP1	Manual Depreciation - Rows	23	Project	Project Code	nVarChar	20	0
30	OACT	G/L Accounts	43	Project	Project Code	nVarChar	20	0
31	OBTF	Journal Voucher Entry	19	Project	Project Code	nVarChar	20	0
32	OCFL	Cash Flow Additional Trans.	4	Project	Project Code	nVarChar	20	0
33	OJDT	Journal Entry	19	Project	Project Code	nVarChar	20	0
34	RCR1	Recurring Postings - Rows	27	Project	Project Code	nVarChar	20	0
35	RTI1	Retirement - Rows	23	Project	Project Code	nVarChar	20	0
36	TRT1	Posting Templates - Rows	25	Project	Project Code	nVarChar	20	0
TOPInventory and Production
37	AIT5	Asset Item Projects - History	5	Project	Project	nVarChar	20	0
38	AITT	Product Tree - History	23	Project	Project Code	nVarChar	20	0
39	AMR1	Inventory Revaluation - History - Rows	23	Project	Project Code	nVarChar	20	0
40	AQI1	Inventory Opening Balance - Rows	23	Project	Project Code	nVarChar	20	0
41	AQR1	Inventory Posting - Rows	23	Project	Project Code	nVarChar	20	0
42	ATT1	Bill of Materials - Components - History	23	Project	Project Code	nVarChar	20	0
43	AWO1	Production Order (Rows) - History	19	Project	Project Code	nVarChar	20	0
44	AWOR	Production Order - History	40	Project	Project Code	nVarChar	20	0
45	IGE1	Goods Issue - Rows	43	Project	Project Code	nVarChar	20	0
46	IGE13	Goods Issue Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
47	IGE2	Goods Issue - Freight - Rows	51	Project	Project Code	nVarChar	20	0
48	IGE3	Goods Issue - Freight	59	Project	Project Code	nVarChar	20	0
49	IGN1	Goods Receipt - Rows	43	Project	Project Code	nVarChar	20	0
50	IGN13	Goods Receipt Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
51	IGN2	Goods Receipt - Freight - Rows	51	Project	Project Code	nVarChar	20	0
52	IGN3	Goods Receipt - Freight	59	Project	Project Code	nVarChar	20	0
53	IOD1	Inventory Opening Balance Draft - Rows	23	Project	Project Code	nVarChar	20	0
54	IPD1	Inventory Posting Draft - Rows	23	Project	Project Code	nVarChar	20	0
55	IPF1	Landed Costs - Rows	67	Project	Project Code	nVarChar	20	0
56	IQI1	Inventory Opening Balance - Rows	23	Project	Project Code	nVarChar	20	0
57	IQR1	Inventory Posting - Rows	23	Project	Project Code	nVarChar	20	0
58	ITM5	Asset Item Projects	5	Project	Project	nVarChar	20	0
59	ITT1	Bill of Materials - Components	23	Project	Project Code	nVarChar	20	0
60	MRV1	Inventory Revaluation Information Array	23	Project	Project Code	nVarChar	20	0
61	OIGE	Goods Issue	136	Project	Project Code	nVarChar	20	0
62	OIGN	Goods Receipt	136	Project	Project Code	nVarChar	20	0
63	OITT	Product Tree	23	Project	Project Code	nVarChar	20	0
64	OMRL	Advanced Inventory Revaluation	32	Project	Project Code	nVarChar	20	0
65	OWOR	Production Order	40	Project	Project Code	nVarChar	20	0
66	OWTQ	Inventory Transfer Request	136	Project	Project Code	nVarChar	20	0
67	OWTR	Inventory Transfer	136	Project	Project Code	nVarChar	20	0
68	UWOR	Production Order	40	Project	Project Code	nVarChar	20	0
69	UWOR1	Production Order - Rows	19	Project	Project Code	nVarChar	20	0
70	WOR1	Production Order - Rows	19	Project	Project Code	nVarChar	20	0
71	WTQ1	Inventory Transfer Request - Rows	43	Project	Project Code	nVarChar	20	0
72	WTQ13	Inventory Transfer Request Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
73	WTQ2	Inventory Transfer Request - Freight - Rows	51	Project	Project Code	nVarChar	20	0
74	WTQ3	Inventory Transfer Request - Freight	59	Project	Drawn Total	nVarChar	20	0
75	WTR1	Inventory Transfer - Rows	43	Project	Project Code	nVarChar	20	0
76	WTR13	Inventory Transfer Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
77	WTR2	Inventory Transfer - Freight - Rows	51	Project	Project Code	nVarChar	20	0
78	WTR3	Inventory Transfer - Freight	59	Project	Project Code	nVarChar	20	0
TOPMarketing Documents
79	ADO1	A/R Invoice (Rows) - History	43	Project	Project Code	nVarChar	20	0
80	ADO13	A/R Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
81	ADO2	A/R Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
82	ADO3	A/R Invoice - Freight - History	59	Project	Project Code	nVarChar	20	0
83	ADOC	Invoice - History	136	Project	Project Code	nVarChar	20	0
84	CIN1	Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
85	CIN13	Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
86	CIN2	A/R Correction Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
87	CIN3	A/R Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
88	CPI1	A/P Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
89	CPI13	A/P Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
90	CPI2	A/P Correction Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
91	CPI3	A/P Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
92	CPV1	A/P Correction Invoice Reversal - Rows	43	Project	Project Code	nVarChar	20	0
93	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
94	CPV2	A/P Correction Invoice Reversal - Freight - Rows	51	Project	Project Code	nVarChar	20	0
95	CPV3	A/P Correction Invoice Reversal - Freight	59	Project	Project Code	nVarChar	20	0
96	CSI1	A/R Correction Invoice - Rows	43	Project	Project Code	nVarChar	20	0
97	CSI13	A/R Correction Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
98	CSI2	A/R Corr Inv - Freight - Rows	51	Project	Project Code	nVarChar	20	0
99	CSI3	A/R Correction Invoice - Freight	59	Project	Project Code	nVarChar	20	0
100	CSV1	A/R Correction Invoice Reversal - Rows	43	Project	Project Code	nVarChar	20	0
101	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
102	CSV2	A/R Correction Invoice Reversal - Freight - Rows	51	Project	Project Code	nVarChar	20	0
103	CSV3	A/R Correction Invoice Reversal - Freight	59	Project	Project Code	nVarChar	20	0
104	DLN1	Delivery - Rows	43	Project	Project Code	nVarChar	20	0
105	DLN13	Delivery Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
106	DLN2	Delivery Notes - Freight - Rows	51	Project	Project Code	nVarChar	20	0
107	DLN3	Delivery Notes - Freight	59	Project	Project Code	nVarChar	20	0
108	DPI1	A/R Down Payment - Rows	43	Project	Project Code	nVarChar	20	0
109	DPI13	A/R Down Payment Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
110	DPI2	A/R Down Payment - Freight - Rows	51	Project	Project Code	nVarChar	20	0
111	DPI3	A/R Down Payment - Freight	59	Project	Project Code	nVarChar	20	0
112	DPO1	A/P Down Payment - Rows	43	Project	Project Code	nVarChar	20	0
113	DPO13	A/P Down Payment Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
114	DPO2	A/P Down Payment - Freight - Rows	51	Project	Project Code	nVarChar	20	0
115	DPO3	A/P Down Payment - Freight	59	Project	Project Code	nVarChar	20	0
116	DRF1	Draft - Rows	43	Project	Project Code	nVarChar	20	0
117	DRF13	Draft Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
118	DRF2	Draft - Freight - Rows	51	Project	Project Code	nVarChar	20	0
119	DRF3	Draft - Freight	59	Project	Project Code	nVarChar	20	0
120	IEI1	Incoming Excise Invoice - Rows	43	Project	Project Code	nVarChar	20	0
121	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
122	IEI2	Incoming Excise Invoice - Freight - History - Rows	51	Project	Project Code	nVarChar	20	0
123	IEI3	IEI - Freight	59	Project	Project Code	nVarChar	20	0
124	INV1	A/R Invoice - Rows	43	Project	Project Code	nVarChar	20	0
125	INV13	A/R Invoice Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
126	INV2	A/R Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
127	INV3	A/R Invoice - Freight	59	Project	Project Code	nVarChar	20	0
128	OCIN	A/R Correction Invoice	136	Project	Project Code	nVarChar	20	0
129	OCPI	A/P Correction Invoice	136	Project	Project Code	nVarChar	20	0
130	OCPV	A/P Correction Invoice Reversal	136	Project	Project Code	nVarChar	20	0
131	OCSI	A/R Correction Invoice	136	Project	Project Code	nVarChar	20	0
132	OCSV	A/R Correction Invoice Reversal	136	Project	Project Code	nVarChar	20	0
133	ODLN	Delivery	136	Project	Project Code	nVarChar	20	0
134	ODPI	A/R Down Payment	136	Project	Project Code	nVarChar	20	0
135	ODPO	A/P Down Payment	136	Project	Project Code	nVarChar	20	0
136	ODRF	Drafts	136	Project	Project Code	nVarChar	20	0
137	ODWZ	Dunning Wizard	24	Project	Project	nVarChar	20	0
138	OEI1	Outgoing Excise Invoice - Rows	43	Project	Project Code	nVarChar	20	0
139	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
140	OEI2	OEI - Freight Rows	51	Project	Project Code	nVarChar	20	0
141	OEI3	OEI - Freight	59	Project	Project Code	nVarChar	20	0
142	OIEI	Incoming Excise Invoice	136	Project	Project Code	nVarChar	20	0
143	OINV	A/R Invoice	136	Project	Project Code	nVarChar	20	0
144	OOEI	Outgoing Excise Invoice	136	Project	Project Code	nVarChar	20	0
145	OPCH	A/P Invoice	136	Project	Project Code	nVarChar	20	0
146	OPDN	Goods Receipt PO	136	Project	Project Code	nVarChar	20	0
147	OPOR	Purchase Order	136	Project	Project Code	nVarChar	20	0
148	OPQT	Purchase Quotation	136	Project	Project Code	nVarChar	20	0
149	OPRQ	Purchase Request	136	Project	Project Code	nVarChar	20	0
150	OPRR	Goods Return Request	136	Project	Project Code	nVarChar	20	0
151	OQUT	Sales Quotation	136	Project	Project Code	nVarChar	20	0
152	ORDN	Returns	136	Project	Project Code	nVarChar	20	0
153	ORDR	Sales Order	136	Project	Project Code	nVarChar	20	0
154	ORIN	A/R Credit Memo	136	Project	Project Code	nVarChar	20	0
155	ORPC	A/P Credit Memo	136	Project	Project Code	nVarChar	20	0
156	ORPD	Goods Return	136	Project	Project Code	nVarChar	20	0
157	ORRR	Return Request	136	Project	Project Code	nVarChar	20	0
158	OSFC	Self Credit Memo	136	Project	Project Code	nVarChar	20	0
159	OSFI	Self Invoice	136	Project	Project Code	nVarChar	20	0
160	PCH1	A/P Invoice - Rows	43	Project	Project Code	nVarChar	20	0
161	PCH13	A/P Invoice Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
162	PCH2	A/P Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
163	PCH3	A/P Invoice - Freight	59	Project	Project Code	nVarChar	20	0
164	PDN1	Goods Receipt PO - Rows	43	Project	Project Code	nVarChar	20	0
165	PDN13	Goods Receipt PO Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
166	PDN2	Goods Receipt PO - Freight - Rows	51	Project	Project Code	nVarChar	20	0
167	PDN3	Goods Receipt PO - Freight	59	Project	Project Code	nVarChar	20	0
168	POR1	Purchase Order - Rows	43	Project	Project Code	nVarChar	20	0
169	POR13	Purchase Order Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
170	POR2	Purchase Order - Freight - Rows	51	Project	Project Code	nVarChar	20	0
171	POR3	Purchase Order - Freight	59	Project	Project Code	nVarChar	20	0
172	PQT1	Purchase Quotation - Rows	43	Project	Project Code	nVarChar	20	0
173	PQT13	Purchase Quotation Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
174	PQT2	Purchase Quotation - Freight - Rows	51	Project	Project Code	nVarChar	20	0
175	PQT3	Purchase Quotation - Freight	59	Project	Project Code	nVarChar	20	0
176	PRQ1	Purchase Request - Rows	43	Project	Project Code	nVarChar	20	0
177	PRQ13	Purchase Request Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
178	PRQ2	Purchase Request - Freight - Rows	51	Project	Project Code	nVarChar	20	0
179	PRQ3	Purchase Request - Freight	59	Project	Project Code	nVarChar	20	0
180	PRR1	A/P Return Request - Rows	43	Project	Project Code	nVarChar	20	0
181	PRR13	A/P Return Request - Distributed Freights	59	Project	Project Code	nVarChar	20	0
182	PRR2	A/P Return Request - Freight - Rows	51	Project	Project Code	nVarChar	20	0
183	PRR3	A/P Return Request - Freight	59	Project	Project Code	nVarChar	20	0
184	QUT1	Sales Quotation - Rows	43	Project	Project Code	nVarChar	20	0
185	QUT13	Sales Quotation Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
186	QUT2	Sales Quotation - Freight - Rows	51	Project	Project Code	nVarChar	20	0
187	QUT3	Sales Quotation - Freight	59	Project	Project Code	nVarChar	20	0
188	RDN1	Returns - Rows	43	Project	Project Code	nVarChar	20	0
189	RDN13	Returns Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
190	RDN2	Return - Freight - Rows	51	Project	Project Code	nVarChar	20	0
191	RDN3	Return - Freight	59	Project	Project Code	nVarChar	20	0
192	RDR1	Sales Order - Rows	43	Project	Project Code	nVarChar	20	0
193	RDR13	Sales Order Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
194	RDR2	Sales Order - Freight - Rows	51	Project	Project Code	nVarChar	20	0
195	RDR3	Sales Order - Freight	59	Project	Project Code	nVarChar	20	0
196	RIN1	A/R Credit Memo - Rows	43	Project	Project Code	nVarChar	20	0
197	RIN13	A/R Credit Memo Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
198	RIN2	A/R Credit Memo - Freight - Rows	51	Project	Project Code	nVarChar	20	0
199	RIN3	A/R Credit Memo - Freight	59	Project	Project Code	nVarChar	20	0
200	RPC1	A/P Credit Memo - Rows	43	Project	Project Code	nVarChar	20	0
201	RPC13	A/P Credit Memo Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
202	RPC2	A/P Credit Memo Rows - Expenses	51	Project	Project Code	nVarChar	20	0
203	RPC3	A/P Credit Memo - Freight	59	Project	Project Code	nVarChar	20	0
204	RPD1	Goods Return - Rows	43	Project	Project Code	nVarChar	20	0
205	RPD13	Goods Returns Rows - Distributed Expenses	59	Project	Project Code	nVarChar	20	0
206	RPD2	Goods Return - Freight - Rows	51	Project	Project Code	nVarChar	20	0
207	RPD3	Goods Return - Freight	59	Project	Project Code	nVarChar	20	0
208	RRR1	A/R Return Request - Rows	43	Project	Project Code	nVarChar	20	0
209	RRR13	A/R Return Request - Distributed Freights	59	Project	Project Code	nVarChar	20	0
210	RRR2	A/R Return Request - Freight - Rows	51	Project	Project Code	nVarChar	20	0
211	RRR3	A/R Return Request - Freight	59	Project	Project Code	nVarChar	20	0
212	SFC1	Self Credit Memo - Rows	43	Project	Project Code	nVarChar	20	0
213	SFC13	Self Credit Memo Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
214	SFC2	Self Credit Memo - Freight - Rows	51	Project	Project Code	nVarChar	20	0
215	SFC3	Self Credit Memo - Freight	59	Project	Project Code	nVarChar	20	0
216	SFI1	Self Invoice - Rows	43	Project	Project Code	nVarChar	20	0
217	SFI13	Self Invoice Rows - Distributed Freights	59	Project	Project Code	nVarChar	20	0
218	SFI2	Self Invoice - Freight - Rows	51	Project	Project Code	nVarChar	20	0
219	SFI3	Self Invoice - 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

219 columns | B1 9.3 | PROJECT