biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Goods Receipt PO - SnB properties
API PDN16
PDN16 - Goods Receipt PO - SnB properties Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEabs entryInt
11OPDN
Goods Receipt PO		PRIMARYYes
LineNumLine NumberInt
11
SnBIndexSnB IndexInt
11
ItemCodeItem CodenVarChar
20OITM
Items
WhsCodeWarehousenVarChar
8OWHS
Warehouses
ObjIdObject idInt
11
ObjAbsObject AbsInt
11
DrfWObjAbsdraft Wobj AbsInt
11
-1
QuantityQttyNum
20
SubLineNumSubrow NumberInt
11
-1
ObjTypeObject TypenVarChar
20
20
LogInstancLog InstanceInt
11

Table relationship map

SELECT statement

SELECT PDN16.AbsEntry AS 'abs entry', PDN16.LineNum AS 'Line Number', PDN16.SnBIndex AS 'SnB Index', PDN16.ItemCode AS 'Item Code', PDN16.WhsCode AS 'Warehouse', PDN16.ObjId AS 'Object id', PDN16.ObjAbs AS 'Object Abs', PDN16.DrfWObjAbs AS 'draft Wobj Abs', PDN16.Quantity AS 'Qtty', PDN16.SubLineNum AS 'Subrow Number', PDN16.ObjType AS 'Object Type', PDN16.LogInstanc AS 'Log Instance' FROM PDN16 AS PDN16

Related information


Goods Receipt PO OPDN SQL Table

Items OITM SQL Table

Warehouses OWHS 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