|
|
API ILM3
ILM3 - Non-Inventory and Resource Components Log Msg Table
Items OITM SQL Table
Inventory Log Message OILM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | MessageID KEY UNIQUE | Message ID | Int | 11 | OILM Inventory Log Message | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineID | Line ID | Int | 11 | |||||
| POLine | Line in Production Order | Int | 11 | |||||
| ItemType | Item Type | Int | 11 | |||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| Quantity | Quantity | Num | 20 | |||||
| TotalLC | Inventory Total LC | Num | 20 | |||||
| BaseAbsEnt | Abs. Entry of Base Doc. | Int | 11 | -1 | ||||
| BaseType | Base Transaction Type | Int | -1) 0 60) Goods Issue | 11 | -1 | |||
| BaseLine | Base Line Number | Int | 11 | -1 |
Table relationship map
SELECT statement
SELECT
ILM3.MessageID AS 'Message ID',
ILM3.LineID AS 'Line ID',
ILM3.POLine AS 'Line in Production Order',
ILM3.ItemType AS 'Item Type',
ILM3.ItemCode AS 'Item No.',
ILM3.LocType AS 'Location Type',
ILM3.LocCode AS 'Location Code',
ILM3.Quantity AS 'Quantity',
ILM3.TotalLC AS 'Inventory Total LC',
ILM3.BaseAbsEnt AS 'Abs. Entry of Base Doc.',
ILM3.BaseType AS 'Base Transaction Type',
ILM3.BaseLine AS 'Base Line Number'
FROM ILM3 AS ILM3
Related information
Items OITM 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