	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

172 columns | B1 8.8 | ITEMCODE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAdministration
1	DADB	Data Archive DSA Balance	2	ItemCode	Item Number	nVarChar	20	0
2	OSRL	Serial Numbers	1	ItemCode	Item No.	nVarChar	20	0
TOPBusiness Partners
3	OSCN	Customer/Vendor Cat. No.	1	ItemCode	Item No.	nVarChar	20	0
TOPFinance
4	IWZ3	Items Last Revaluation Data	2	ItemCode	Item Number	nVarChar	20	0
TOPInventory and Production
5	AIT1	Item - Prices - History	1	ItemCode	Item Number	nVarChar	20	0
6	AITM	Items - History	1	ItemCode	Item Number	nVarChar	20	0
7	AITW	Items - Warehouse - History	1	ItemCode	Item No.	nVarChar	20	0
8	AMR1	Inventory Revaluation - History - Rows	3	ItemCode	Item Code	nVarChar	20	0
9	AWO1	Production Order (Rows) - History	3	ItemCode	Item No.	nVarChar	20	0
10	AWOR	Production Order - History	4	ItemCode	Product No.	nVarChar	20	0
11	ENT1	Entry - Rows	13	ItemCode	Item No.	nVarChar	20	0
12	IGE1	Goods Issue - Rows	10	ItemCode	Item No.	nVarChar	20	0
13	IGE8	Items in Package - Goods Issue	3	ItemCode	Item Code	nVarChar	20	0
14	IGN1	Goods Receipt - Rows	10	ItemCode	Item No.	nVarChar	20	0
15	IGN8	Goods Receipt - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
16	ILM1	Srl & Batch Det of Inv Log Msg	2	ItemCode	Item Code	nVarChar	20	0
17	IPF1	Landed Costs - Rows	5	ItemCode	Item No.	nVarChar	20	0
18	IQI1	Inventory Initial Qty Rows	3	ItemCode	Item No.	nVarChar	20	0
19	IQR1	Inventory Stock Posting (Reconcile) Lines	3	ItemCode	Item No.	nVarChar	20	0
20	ITL1	Srl & Batch Details in Transac	2	ItemCode	Item Code	nVarChar	20	0
21	ITM1	Items - Prices	1	ItemCode	Item No.	nVarChar	20	0
22	ITW1	Item Count Alert	1	ItemCode	Item No.	nVarChar	20	0
23	MRV1	Inventory Revaluation Information Array	3	ItemCode	Item Code	nVarChar	20	0
24	OAIM	Archive Inventory Message	18	ItemCode	Item Code	nVarChar	20	0
25	OBTN	Batch Numbers Master Data	1	ItemCode	Item No.	nVarChar	20	0
26	OBTQ	Batch No. Quantities	1	ItemCode	Item Code	nVarChar	20	0
27	OBTW	Batch Attributes in Location	1	ItemCode	Item Code	nVarChar	20	0
28	ODBN	Bat. Nos - Draft - Master Data	1	ItemCode	Item No.	nVarChar	20	0
29	ODBW	Batch Draft Attribs in Locat.	1	ItemCode	Item Code	nVarChar	20	0
30	ODSN	SNs - Draft - Master Data	1	ItemCode	Item No.	nVarChar	20	0
31	ODSW	SN Draft Attribs in Location	1	ItemCode	Item Code	nVarChar	20	0
32	OIBT	Batch No. for Item	1	ItemCode	Item No.	nVarChar	20	0
33	OILM	Inventory Log Message	22	ItemCode	Item Code	nVarChar	20	0
34	OINM	Whse Journal	15	ItemCode	Item No.	nVarChar	20	0
35	OITL	Inventory Transactions Log	3	ItemCode	Item Code	nVarChar	20	0
36	OITM	Items	1	ItemCode	Item No.	nVarChar	20	0
37	OITW	Items - Warehouse	1	ItemCode	Item No.	nVarChar	20	0
38	OIVE	FIFO Based Sales Return	11	ItemCode	Item Code	nVarChar	20	0
39	OIVL	Whse Journal	7	ItemCode	Item No.	nVarChar	20	0
40	OIVQ	FIFO Queue Working Table	9	ItemCode	Item Code	nVarChar	20	0
41	OSPP	Special Prices	1	ItemCode	Item No.	nVarChar	20	0
42	OSRI	Serial Numbers for Items	1	ItemCode	Item No.	nVarChar	20	0
43	OSRN	Serial Numbers Master Data	1	ItemCode	Item No.	nVarChar	20	0
44	OSRQ	Serial No. Quantities	1	ItemCode	Item Code	nVarChar	20	0
45	OSRW	Serial No. Attribs in Location	1	ItemCode	Item Code	nVarChar	20	0
46	OWOR	Production Order	4	ItemCode	Product No.	nVarChar	20	0
47	SPP1	Special Prices - Data Areas	1	ItemCode	Item No.	nVarChar	20	0
48	SPP2	Special Prices - Quantity Areas	1	ItemCode	Item No.	nVarChar	20	0
49	UILM	IVI Inventory Log Message	22	ItemCode	Item Code	nVarChar	20	0
50	UILM1	Srl & Batch Det of Inv Log Msg	2	ItemCode	Item Code	nVarChar	20	0
51	UITM	Items	1	ItemCode	Item No.	nVarChar	20	0
52	UITW	Items - Warehouse	1	ItemCode	Item No.	nVarChar	20	0
53	UIVE	FIFO Based Sales Return	11	ItemCode	Item Code	nVarChar	20	0
54	UIVL	Whse Journal	7	ItemCode	Item No.	nVarChar	20	0
55	UIVQ	FIFO Queue Working Table	9	ItemCode	Item Code	nVarChar	20	0
56	UWKO1	Production Instructions - Rows	3	ItemCode	Item No.	nVarChar	20	0
57	UWOR	Production Order	4	ItemCode	Product No.	nVarChar	20	0
58	UWOR1	Production Order - Rows	3	ItemCode	Item No.	nVarChar	20	0
59	WKO1	Production Instructions - Rows	3	ItemCode	Item No.	nVarChar	20	0
60	WOR1	Production Order - Rows	3	ItemCode	Item No.	nVarChar	20	0
61	WTR1	Inventory Transfer - Rows	10	ItemCode	Item Code	nVarChar	20	0
62	WTR8	Inventory Transfer - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
TOPMarketing Documents
63	ADO1	A/R Invoice (Rows) - History	10	ItemCode	Item No.	nVarChar	20	0
64	ADO14	Invoice - Assembly - Rows - History	4	ItemCode	Item no.	nVarChar	20	0
65	ADO16	Draft - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
66	ADO8	Items in Package - History	3	ItemCode	Item Code	nVarChar	20	0
67	CIN1	Correction Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
68	CIN8	Items in Package - Correction Invoice	3	ItemCode	Item Code	nVarChar	20	0
69	CPI1	A/P Correction Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
70	CPI14	A/P Correction Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
71	CPI16	A/P Corr. Inv - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
72	CPI8	A/P Correction Invoice - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
73	CPV1	A/P Correction Invoice Reversal - Rows	10	ItemCode	Item No.	nVarChar	20	0
74	CPV14	A/P Correction Invoice Reversal - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
75	CPV16	A/P Correction Invoice Reversal - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
76	CPV8	A/P Correction Invoice Reversal - Items in Package	3	ItemCode	Item Number	nVarChar	20	0
77	CSI1	A/R Correction Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
78	CSI14	A/R Correction Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
79	CSI16	A/R Corr. Inv. - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
80	CSI8	A/R Corr. Inv. - Items in Pkg	3	ItemCode	Item Code	nVarChar	20	0
81	CSV1	A/R Correction Invoice Reversal - Rows	10	ItemCode	Item No.	nVarChar	20	0
82	CSV14	A/R Correction Invoice Reversal - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
83	CSV16	A/R Correction Invoice Reversal - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
84	CSV8	A/R Correction Invoice Reversal - Items in Package	3	ItemCode	Item Number	nVarChar	20	0
85	DLN1	Delivery - Rows	10	ItemCode	Item No.	nVarChar	20	0
86	DLN14	Delivery Notes - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
87	DLN16	Delivery - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
88	DLN8	Items in Package - Delivery	3	ItemCode	Item Number	nVarChar	20	0
89	DPI1	A/R Down Payment - Rows	10	ItemCode	Item No.	nVarChar	20	0
90	DPI14	A/R Down Payment - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
91	DPI16	A/R Down Payment - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
92	DPI8	Items in Package - A/R Down Pmt.	3	ItemCode	Item Code	nVarChar	20	0
93	DPO1	A/P Down Payment - Rows	10	ItemCode	Item No.	nVarChar	20	0
94	DPO14	A/P Down Payment - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
95	DPO16	A/P Down Payment - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
96	DPO8	Items in Package - A/P Down Pmt.	3	ItemCode	Item Code	nVarChar	20	0
97	DRF1	Draft - Rows	10	ItemCode	Item No.	nVarChar	20	0
98	DRF14	Draft - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
99	DRF16	Draft - SnB - Rows	4	ItemCode	Item Code	nVarChar	20	0
100	DRF8	Items in Package - Draft	3	ItemCode	Item Code	nVarChar	20	0
101	IEI1	Incoming Excise Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
102	IEI14	Incoming Excise Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
103	IEI16	Incoming Excise Invoice - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
104	IEI8	Incoming Excise Invoice - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
105	IGE14	Goods Issue - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
106	IGE16	Goods Issue - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
107	IGN14	Goods Receipt - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
108	IGN16	Goods Receipt - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
109	INV1	A/R Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
110	INV14	A/R Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
111	INV16	A/R Invoice - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
112	INV8	A/R Invoice - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
113	MIN2	Item Imformation of MI	6	ItemCode	Item No.	nVarChar	20	0
114	MIV2	A/P Monthly Invoice - Item	6	ItemCode	Item No.	nVarChar	20	0
115	OEI1	Outgoing Excise Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
116	OEI14	Outgoing Excise Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
117	OEI16	Outgoing Excise Invoice - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
118	OEI8	Outgoing Excise Invoice - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
119	PCH1	A/P Invoice - Rows	10	ItemCode	Item No.	nVarChar	20	0
120	PCH14	A/P Invoice - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
121	PCH16	A/P Invoice - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
122	PCH8	A/P Invoice - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
123	PDN1	Goods Receipt PO - Rows	10	ItemCode	Item No.	nVarChar	20	0
124	PDN14	Goods Receipt PO - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
125	PDN16	Goods Receipt PO - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
126	PDN8	Goods Receipt PO - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
127	POR1	Purchase Order - Rows	10	ItemCode	Item No.	nVarChar	20	0
128	POR14	Purchase Order - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
129	POR16	Purchase Order - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
130	POR8	Items in Package - Purchase Order	3	ItemCode	Item Code	nVarChar	20	0
131	QUT1	Sales Quotation - Rows	10	ItemCode	Item No.	nVarChar	20	0
132	QUT14	Sales Quotation - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
133	QUT16	Sales Quotation - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
134	QUT8	Sales Quotation - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
135	RDN1	Returns - Rows	10	ItemCode	Item No.	nVarChar	20	0
136	RDN14	Return - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
137	RDN16	Returns - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
138	RDN8	Returns - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
139	RDR1	Sales Order - Rows	10	ItemCode	Item No.	nVarChar	20	0
140	RDR14	Sales Order - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
141	RDR16	Sales Order - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
142	RDR8	Sales Order - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
143	RIN1	A/R Credit Memo - Rows	10	ItemCode	Item No.	nVarChar	20	0
144	RIN14	A/R Credit Memo - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
145	RIN16	A/R Credit Memo - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
146	RIN8	Items in Package - A/R Credit Memo	3	ItemCode	Item Code	nVarChar	20	0
147	RPC1	A/P Credit Memo - Rows	10	ItemCode	Item No.	nVarChar	20	0
148	RPC14	A/P Credit Memo - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
149	RPC16	A/P Credit Memo - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
150	RPC8	Items in Package - A/P Credit Memo	3	ItemCode	Item Code	nVarChar	20	0
151	RPD1	Goods Return - Rows	10	ItemCode	Item No.	nVarChar	20	0
152	RPD14	Goods Return - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
153	RPD16	Goods Return - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
154	RPD8	Goods Return - Items in Package	3	ItemCode	Item Code	nVarChar	20	0
155	SAL1	Salida - Rows	13	ItemCode	Item No.	nVarChar	20	0
156	TRA1	Transition - Rows	13	ItemCode	Item No.	nVarChar	20	0
157	WTR14	Inventory Transfer - Assembly - Rows	4	ItemCode	Item no.	nVarChar	20	0
158	WTR16	Inventory Transfer - SnB properties	4	ItemCode	Item Code	nVarChar	20	0
TOPMRP
159	FCT1	Sales Forecast - Rows	3	ItemCode	Item No.	nVarChar	20	0
160	MSN2	MRP Run Results	2	ItemCode	Item No.	nVarChar	20	0
161	MSN3	MRP Pegging Information	2	ItemCode	Item No.	nVarChar	20	0
162	ORCM	Recommendation Data	4	ItemCode	Item No.	nVarChar	20	0
TOPService
163	AINS	Customer Equipment Card - History	14	itemCode	Foreign Key To Item	nVarChar	20	0
164	ASC2	Service Call Inventory Expenses - History	3	ItemCode	Item No. - History	nVarChar	20	0
165	ASC3	Service Call Travel/Labor Expenses - History	3	ItemCode	Item Number	nVarChar	20	0
166	ASCL	History	15	itemCode	Item Number	nVarChar	20	0
167	CTR1	Service Contract - Items	5	ItemCode	Item No.	nVarChar	20	0
168	OINS	Customer Equipment Card	14	itemCode	Item No.	nVarChar	20	0
169	OSCL	Service Calls	15	itemCode	Item No.	nVarChar	20	0
170	OSLT	Service Call Solutions	2	ItemCode	Item No.	nVarChar	20	0
171	SCL2	Service Call Inventory Expenses	3	ItemCode	Item No.	nVarChar	20	0
172	SCL3	Service Call Travel/Labor Expenses	3	ItemCode	Item No.	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

172 columns | B1 8.8 | ITEMCODE