biuan SAP® BUSINESS ONE SDK
API PKL2
PKL2 - Pick List for SnB and Bin Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OPKL
Pick List
PRIMARYYes
PickEntryRow NumberInt
11
Pkl2LinNumPKl2 Line NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
ManagedByManagement MethodInt
10000044) BTN
10000045) SRN
-1) NOB
11
-1
SnBEntrySnB Abs. EntryInt
11
BinAbsBin Internal NumberInt
11OBIN
Bin Location
AllowNegAllow Negative Entry [Y/N]VarChar
Y) Yes
N) No
1
N
RelQttyReleased QuantityNum
20
PickQttyPicked QuantityNum
20
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
156
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT PKL2.AbsEntry AS 'Internal Number', PKL2.PickEntry AS 'Row Number', PKL2.Pkl2LinNum AS 'PKl2 Line Number', PKL2.ItemCode AS 'Item No.', PKL2.ManagedBy AS 'Management Method', PKL2.SnBEntry AS 'SnB Abs. Entry', PKL2.BinAbs AS 'Bin Internal Number', PKL2.AllowNeg AS 'Allow Negative Entry [Y/N]', PKL2.RelQtty AS 'Released Quantity', PKL2.PickQtty AS 'Picked Quantity', PKL2.ObjType AS 'Object Type', PKL2.LogInstanc AS 'Log Instance' FROM PKL2 AS PKL2

Related information


Pick List OPKL SQL Table

Bin Location OBIN SQL Table

Items OITM SQL Table

Object Settings - History ADP1 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