	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

69 columns | B1 9.3 | 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, Y=Picked
2	AWO1	Production Order (Rows) - History	25	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=Partially Picked, R=Released for Picking, Y=Picked
10	UWOR1	Production Order - Rows	25	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
11	WOR1	Production Order - Rows	25	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	OPRR	Goods Return Request	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
46	OQUT	Sales Quotation	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
47	ORDN	Returns	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
48	ORDR	Sales Order	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
49	ORIN	A/R Credit Memo	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
50	ORPC	A/P Credit Memo	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
51	ORPD	Goods Return	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
52	ORRR	Return Request	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
53	OSFC	Self Credit Memo	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
54	OSFI	Self Invoice	121	PickStatus	Pick Status	VarChar	1	0	N	N=No, Y=Yes
55	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
56	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
57	POR1	Purchase Order - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
58	PQT1	Purchase Quotation - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
59	PRQ1	Purchase Request - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
60	PRR1	A/P Return Request - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
61	QUT1	Sales Quotation - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
62	RDN1	Returns - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
63	RDR1	Sales Order - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Release for Picking, Y=Picked
64	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
65	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
66	RPD1	Goods Return - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
67	RRR1	A/R Return Request - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
68	SFC1	Self Credit Memo - Rows	105	PickStatus	Pick Status	VarChar	1	0	N	N=Not Picked, P=Partially Picked, R=Released for Picking, Y=Picked
69	SFI1	Self Invoice - 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

69 columns | B1 9.3 | PICKSTATUS