	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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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

195 columns | B1 9.2 | PROJECT