|
|
API ADO16
ADO16 - Draft - SnB properties Table
Invoice - History ADOC SQL Table
Items OITM SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Document Number | Int | 11 | ADOC Invoice - History | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| SnBIndex | SnB Index | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| ObjId | Object ID | Int | 11 | |||||
| ObjAbs | SnB Object No. | Int | 11 | |||||
| DrfWObjAbs | SnBW Draft Object No. | Int | 11 | -1 | ||||
| Quantity | Qtty | Num | 20 | |||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance | Int | 11 |
Table relationship map
SELECT statement
SELECT
ADO16.AbsEntry AS 'Document Number',
ADO16.LineNum AS 'Row Number',
ADO16.SnBIndex AS 'SnB Index',
ADO16.ItemCode AS 'Item Code',
ADO16.WhsCode AS 'Warehouse Code',
ADO16.ObjId AS 'Object ID',
ADO16.ObjAbs AS 'SnB Object No.',
ADO16.DrfWObjAbs AS 'SnBW Draft Object No.',
ADO16.Quantity AS 'Qtty',
ADO16.SubLineNum AS 'Subrow Number',
ADO16.ObjType AS 'Object Type',
ADO16.LogInstanc AS 'Log Instance'
FROM ADO16 AS ADO16
Related information
Invoice - History ADOC SQL Table
Items OITM 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
