|
|
API DPO14
DPO14 - A/P Down Payment - Assembly - Rows Table
A/P Down Payment ODPO 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 | ODPO A/P Down Payment | 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 | 204 | |||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| BaseChildN | Base Child Number | Int | 11 | -1 |
Table relationship map
SELECT statement
SELECT
DPO14.DocEntry AS 'Document Internal ID',
DPO14.LineNum AS 'Row Number',
DPO14.ChildNum AS 'Child Number',
DPO14.ItemCode AS 'Item no.',
DPO14.WhsCode AS 'Warehouse Code',
DPO14.Quantity AS 'Quantity',
DPO14.TotalQty AS 'Total Quantity',
DPO14.OpenQty AS 'Remaining Open Quantity',
DPO14.ObjectType AS 'object type',
DPO14.LogInstanc AS 'Log Instance',
DPO14.BaseChildN AS 'Base Child Number'
FROM DPO14 AS DPO14
Related information
A/P Down Payment ODPO 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
