|
|
API OBTL
OBTL - Bin Transaction Log Table
Bin Location OBIN SQL Table
Inventory Transactions Log OITL SQL Table
Inventory Log Message OILM 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 |
|---|---|---|---|---|---|---|---|---|
| MessageID KEY | ILM Message ID | Int | 11 | OILM Inventory Log Message | MESSAGE_ID | No | ||
| BinAbs KEY | Bin Internal Number | Int | 11 | OBIN Bin Location | BIN_ABS | No | ||
| SnBMDAbs | SnB Master Data Internal Number | Int | 11 | -1 | ||||
| Quantity | Quantity | Num | 20 | |||||
| ITLEntry | ITL Log Internal ID | Int | 11 | OITL Inventory Transactions Log | -1 |
Table relationship map
SELECT statement
SELECT
OBTL.AbsEntry AS 'Internal Number',
OBTL.MessageID AS 'ILM Message ID',
OBTL.BinAbs AS 'Bin Internal Number',
OBTL.SnBMDAbs AS 'SnB Master Data Internal Number',
OBTL.Quantity AS 'Quantity',
OBTL.ITLEntry AS 'ITL Log Internal ID'
FROM OBTL AS OBTL
Related information
Bin Location OBIN SQL Table
Inventory Transactions Log OITL SQL Table
Inventory Log Message OILM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates