|
|
DTW Inventory / Pick and Pack / Pick List
API OPKL / / Pick Lists
OPKL - Pick List Table
Pick Lists PickLists Object· Table: OPKL
OPKL SQL Table
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Absolute entry | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name | Name | nVarChar | 127 | |||||
| OwnerCode | Owner Code | Int | 6 | OUSR Users | ||||
| OwnerName | Owner Name | nVarChar | 127 | |||||
| PickDate | Pick Date | Date | 8 | |||||
| Remarks | Remarks | Text | 16 | |||||
| Canceled | Canceled | VarChar | Y) Yes N) No | 1 | N | |||
| ShipType | Shipping Type | Int | 6 | |||||
| Status | Status | VarChar | R) Released Y) Picked P) Partially Picked D) Partially Delivered C) Closed | 1 | R | |||
| Printed | Printed | VarChar | Y) Copy N) Original | 1 | N | |||
| LogInstac | Log Instance - History | Int | 11 | |||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 156 | |||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UseBaseUn | Inventory UoM | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OPKL.AbsEntry AS 'Absolute entry',
OPKL.Name AS 'Name',
OPKL.OwnerCode AS 'Owner Code',
OPKL.OwnerName AS 'Owner Name',
OPKL.PickDate AS 'Pick Date',
OPKL.Remarks AS 'Remarks',
OPKL.Canceled AS 'Canceled',
OPKL.ShipType AS 'Shipping Type',
OPKL.Status AS 'Status',
OPKL.Printed AS 'Printed',
OPKL.LogInstac AS 'Log Instance - History',
OPKL.ObjType AS 'Object Type',
OPKL.UpdateDate AS 'Date of Update',
OPKL.CreateDate AS 'Creation Date',
OPKL.UserSign AS 'User Signature',
OPKL.UserSign2 AS 'Updating User',
OPKL.UseBaseUn AS 'Inventory UoM'
FROM OPKL AS OPKL
Related information
Pick Lists PickLists Object· Table: OPKL
The PickLists object supports the picking process of items from the warehouse. The picking process is applicable only for items that are already approved in sales orders.
Source table: OPKL.
OPKL SQL Table
Object Settings - History ADP1 SQL Table
Users OUSR SQL Table
PickLists
Method
Object
PickLists_Lines PKL1
Property
AbsoluteEntry
DTW DB
Name
DTW DB
ObjectType
DB
OwnerCode
DTW DB
OwnerName
DB
PickDate
DTW DB
Remarks
DTW DB
Status
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
