biuan SAP® BUSINESS ONE SDK
API AKL1
AKL1 - Pick List - Rows - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OPKL
Pick List
PRIMARYYes
PickEntryRow NumberInt
11
OrderEntryOrder EntryInt
11
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
0
11

SELECT statement

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

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates