|
|
API AKL1
AKL1 - Pick List - Rows - History Table
Pick List OPKL SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OPKL Pick List | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PickEntry | Row Number | Int | 11 | |||||
| OrderEntry | Order Entry | Int | 11 | |||||
| OrderLine | Order Row ID | Int | 11 | |||||
| PickQtty | Picked Quantity | Num | 20 | |||||
| PickStatus | Pick Status | VarChar | R) Released for Picking P) Picked T) Partially Picked D) Partially Delivered C) Closed | 1 | R | |||
| RelQtty | Released Quantity | Num | 20 | |||||
| LogInsac | Log Instance - History | Int | 11 | |||||
| PrevReleas | Previously Released Quantity | Num | 20 | |||||
| BaseObject | Base Object Type | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
