biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Pick List / Pick List - Rows
DTW Inventory / Pick and Pack / Pick List / Pick List - Rows
API Pick Lists / Pick Lists Lines
PKL1 - Pick List - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OPKL
Pick List		PRIMARYYes
PickEntryRow NumberInt
11
OrderEntry KEYOrder EntryInt
11
ORDERNo
OrderLineOrder Row IDInt
11
PickQttyPicked QuantityNum
20
PickStatusPick StatusVarChar
R) Released for Picking
P) Picked
T) Partially Picked
D) Partially Delivered
C) Closed
1
R
RelQttyReleased QuantityNum
20
LogInsacLog Instance - HistoryInt
11
PrevReleasPreviously Released QuantityNum
20
BaseObjectBase Object TypeInt
17) Order
13) Reserve Invoice
202) Production Order
1250000001) Inventory Transfer Request
0
11

SELECT statement

SELECT PKL1.AbsEntry AS 'Internal Number', PKL1.PickEntry AS 'Row Number', PKL1.OrderEntry AS 'Order Entry', PKL1.OrderLine AS 'Order Row ID', PKL1.PickQtty AS 'Picked Quantity', PKL1.PickStatus AS 'Pick Status', PKL1.RelQtty AS 'Released Quantity', PKL1.LogInsac AS 'Log Instance - History', PKL1.PrevReleas AS 'Previously Released Quantity', PKL1.BaseObject AS 'Base Object Type' FROM PKL1 AS PKL1

Related information


Pick Lists Lines PickLists_Lines Object· Table: PKL1
The PickLists_Lines is a child object of the PickLists object. Each line represents an order and its picking details in the pick list. Source table: PKL1.
   Parent: Pick Lists PickLists Object· Table: OPKL
Pick List OPKL SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates