	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

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

198 columns | B1 8.82 | ITEMCODE