|
|
API OIBQ
OIBQ - Item - Bin Accumulator Table
Bin Location OBIN SQL 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 | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemCode KEY UNIQUE | Item Code | nVarChar | 20 | OITM Items | BUSINESS_K | Yes | ||
| BinAbs KEY | Bin Internal Number | Int | 11 | OBIN Bin Location | BIN_ABS | No | ||
| OnHandQty | On-Hand Quantity | Num | 20 | |||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Freezed | Item Frozen in Bin Location | VarChar | Y) Yes N) No | 1 | N | |||
| FreezeDoc | Inventory Count Doc. Frozen By | Int | 11 | OINC Inventory Counting |
Table relationship map
SELECT statement
SELECT
OIBQ.AbsEntry AS 'Internal Number',
OIBQ.ItemCode AS 'Item Code',
OIBQ.BinAbs AS 'Bin Internal Number',
OIBQ.OnHandQty AS 'On-Hand Quantity',
OIBQ.WhsCode AS 'Warehouse Code',
OIBQ.Freezed AS 'Item Frozen in Bin Location',
OIBQ.FreezeDoc AS 'Inventory Count Doc. Frozen By'
FROM OIBQ AS OIBQ
Related information
Bin Location OBIN SQL Table
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
