	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

61 columns | B1 9.2 | PICKSTATUS

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPInventory and Production
1	AKL1	Pick List - Rows - History	6	PickStatus	Pick Status	VarChar	1	0	R	C=Closed, D=Partially Delivered, P=Picked, R=Released for Picking, T=Partially Picked
2	AWO1	Production Order (Rows) - History	26	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
3	IGE1	Goods Issue - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
4	IGN1	Goods Receipt - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
5	OIGE	Goods Issue	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
6	OIGN	Goods Receipt	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
7	OWTQ	Inventory Transfer Request	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
8	OWTR	Inventory Transfer	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
9	PKL1	Pick List - Rows	6	PickStatus	Pick Status	VarChar	1	0	R	C=Closed, D=Partially Delivered, P=Picked, R=Released for Picking, T=Partially Picked
10	UWOR1	Production Order - Rows	26	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
11	WOR1	Production Order - Rows	26	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
12	WTQ1	Inventory Transfer Request - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
13	WTR1	Inventory Transfer - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
TOPMarketing Documents
14	ADO1	A/R Invoice (Rows) - History	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
15	ADOC	Invoice - History	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
16	CIN1	Correction Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
17	CPI1	A/P Correction Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
18	CPV1	A/P Correction Invoice Reversal - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
19	CSI1	A/R Correction Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
20	CSV1	A/R Correction Invoice Reversal - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
21	DLN1	Delivery - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
22	DPI1	A/R Down Payment - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
23	DPO1	A/P Down Payment - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
24	DRF1	Draft - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
25	IEI1	Incoming Excise Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
26	INV1	A/R Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
27	OCIN	A/R Correction Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
28	OCPI	A/P Correction Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
29	OCPV	A/P Correction Invoice Reversal	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
30	OCSI	A/R Correction Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
31	OCSV	A/R Correction Invoice Reversal	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
32	ODLN	Delivery	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
33	ODPI	A/R Down Payment	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
34	ODPO	A/P Down Payment	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
35	ODRF	Drafts	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
36	OEI1	Outgoing Excise Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
37	OIEI	Incoming Excise Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
38	OINV	A/R Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
39	OOEI	Outgoing Excise Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
40	OPCH	A/P Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
41	OPDN	Goods Receipt PO	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
42	OPOR	Purchase Order	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
43	OPQT	Purchase Quotation	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
44	OPRQ	Purchase Request	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
45	OQUT	Sales Quotation	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
46	ORDN	Returns	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
47	ORDR	Sales Order	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
48	ORIN	A/R Credit Memo	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
49	ORPC	A/P Credit Memo	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
50	ORPD	Goods Return	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
51	PCH1	A/P Invoice - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
52	PDN1	Goods Receipt PO - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
53	POR1	Purchase Order - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
54	PQT1	Purchase Quotation - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
55	PRQ1	Purchase Request - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
56	QUT1	Sales Quotation - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
57	RDN1	Returns - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
58	RDR1	Sales Order - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
59	RIN1	A/R Credit Memo - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
60	RPC1	A/P Credit Memo - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
61	RPD1	Goods Return - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked

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

61 columns | B1 9.2 | PICKSTATUS