|
|
API PDN14
PDN14 - Goods Receipt PO - Assembly - Rows Table
Goods Receipt PO OPDN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OPDN Goods Receipt PO | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | -1 | ||||
| ChildNum | Child Number | Int | 11 | -1 | ||||
| ItemCode | Item no. | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Quantity | Quantity | Num | 20 | |||||
| TotalQty | Total Quantity | Num | 20 | |||||
| OpenQty | Remaining Open Quantity | Num | 20 | |||||
| ObjectType | object type | nVarChar | 20 | ADP1 Object Settings - History | 20 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| BaseChildN | Base Child Number | Int | 11 | -1 |
Table relationship map
SELECT statement
SELECT
PDN14.DocEntry AS 'Document Internal ID',
PDN14.LineNum AS 'Row Number',
PDN14.ChildNum AS 'Child Number',
PDN14.ItemCode AS 'Item no.',
PDN14.WhsCode AS 'Warehouse Code',
PDN14.Quantity AS 'Quantity',
PDN14.TotalQty AS 'Total Quantity',
PDN14.OpenQty AS 'Remaining Open Quantity',
PDN14.ObjectType AS 'object type',
PDN14.LogInstanc AS 'Log Instance',
PDN14.BaseChildN AS 'Base Child Number'
FROM PDN14 AS PDN14
Related information
Goods Receipt PO OPDN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
