biuan SAP® BUSINESS ONE SDK
API ILM3
ILM3 - Non-Inventory and Resource Components Log Msg Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MessageID KEY UNIQUEMessage IDInt
11OILM
Inventory Log Message
PRIMARYYes
LineIDLine IDInt
11
POLineLine in Production OrderInt
11
ItemTypeItem TypeInt
11
ItemCodeItem No.nVarChar
20OITM
Items
LocTypeLocation TypeInt
6
LocCodeLocation CodenVarChar
8
QuantityQuantityNum
20
TotalLCInventory Total LCNum
20
BaseAbsEntAbs. Entry of Base Doc.Int
11
-1
BaseTypeBase Transaction TypeInt
-1)
0
60) Goods Issue
11
-1
BaseLineBase Line NumberInt
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates