|
|
API CSI16
CSI16 - A/R Corr. Inv. - SnB properties Table
A/R Correction Invoice OCSI 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 | abs entry | Int | 11 | OCSI A/R Correction Invoice | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Line Number | Int | 11 | |||||
| SnBIndex | SnB Index | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| WhsCode | Warehouse | nVarChar | 8 | OWHS Warehouses | ||||
| ObjId | Object id | Int | 11 | |||||
| ObjAbs | Object Abs | Int | 11 | |||||
| DrfWObjAbs | draft Wobj Abs | Int | 11 | -1 | ||||
| Quantity | Qtty | Num | 20 | |||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| ObjType | Object Type | nVarChar | 20 | 165 | ||||
| LogInstanc | Log Instance | Int | 11 |
Table relationship map
SELECT statement
SELECT
CSI16.AbsEntry AS 'abs entry',
CSI16.LineNum AS 'Line Number',
CSI16.SnBIndex AS 'SnB Index',
CSI16.ItemCode AS 'Item Code',
CSI16.WhsCode AS 'Warehouse',
CSI16.ObjId AS 'Object id',
CSI16.ObjAbs AS 'Object Abs',
CSI16.DrfWObjAbs AS 'draft Wobj Abs',
CSI16.Quantity AS 'Qtty',
CSI16.SubLineNum AS 'Subrow Number',
CSI16.ObjType AS 'Object Type',
CSI16.LogInstanc AS 'Log Instance'
FROM CSI16 AS CSI16
Related information
A/R Correction Invoice OCSI 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
