|
|
API OSBQ
OSBQ - Item - Serial/Batch - Bin Accumulator Table
Bin Location OBIN SQL Table
Items OITM SQL Table
Serial Numbers Master Data OSRN 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 | Serial MD Internal Number | Int | 11 | OSRN Serial 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
OSBQ.AbsEntry AS 'Internal Number',
OSBQ.ItemCode AS 'Item Code',
OSBQ.SnBMDAbs AS 'Serial MD Internal Number',
OSBQ.BinAbs AS 'Bin Internal Number',
OSBQ.OnHandQty AS 'On-Hand Quantity',
OSBQ.WhsCode AS 'Warehouse Code'
FROM OSBQ AS OSBQ
Related information
Bin Location OBIN SQL Table
Items OITM SQL Table
Serial Numbers Master Data OSRN 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
