|
|
API IQI2
IQI2 - Inventory Opening Balance - SnB Table
Inventory Counting OINC 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 | DocEntry KEY UNIQUE | Internal Number | Int | 11 | OINC Inventory Counting | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row 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 Whse Obj. Abs. | Int | 11 | -1 | ||||
| Quantity | Quantity | Num | 20 | |||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| ObjType | Object Type | nVarChar | 20 | |||||
| LogInstanc | Log Instance - History | Int | 11 | |||||
| TakerType | Counter Type | Int | 0 1) Two Counters - Counter 1 2) Two Counters - Counter 2 | 11 |
Table relationship map
SELECT statement
SELECT
IQI2.DocEntry AS 'Internal Number',
IQI2.LineNum AS 'Row Number',
IQI2.SnbIndex AS 'SnB Index',
IQI2.ItemCode AS 'Item Code',
IQI2.WhsCode AS 'Warehouse',
IQI2.ObjId AS 'Object ID',
IQI2.ObjAbs AS 'Object Abs.',
IQI2.DrfWObjAbs AS 'Draft Whse Obj. Abs.',
IQI2.Quantity AS 'Quantity',
IQI2.SubLineNum AS 'Subrow Number',
IQI2.ObjType AS 'Object Type',
IQI2.LogInstanc AS 'Log Instance - History',
IQI2.TakerType AS 'Counter Type'
FROM IQI2 AS IQI2
Related information
Inventory Counting OINC 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
