|
|
API OBBQ
OBBQ - Item - Serial/Batch - Bin Accumulator Table
Bin Location OBIN SQL Table
Items OITM SQL Table
Batch Numbers Master Data OBTN 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 | Item Code | nVarChar | 20 | OITM Items | ||||
| SnBMDAbs KEY UNIQUE | Batch MD Internal Number | Int | 11 | OBTN Batch Numbers Master Data | 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 |
Table relationship map
SELECT statement
SELECT
OBBQ.AbsEntry AS 'Internal Number',
OBBQ.ItemCode AS 'Item Code',
OBBQ.SnBMDAbs AS 'Batch MD Internal Number',
OBBQ.BinAbs AS 'Bin Internal Number',
OBBQ.OnHandQty AS 'On-Hand Quantity',
OBBQ.WhsCode AS 'Warehouse Code'
FROM OBBQ AS OBBQ
Related information
Bin Location OBIN SQL Table
Items OITM SQL Table
Batch Numbers Master Data OBTN 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
