biuan SAP® BUSINESS ONE SDK
API ILM1
ILM1 - Srl & Batch Det of Inv Log Msg Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
MessageID KEY UNIQUEMessage IDInt
11OILM
Inventory Log Message
PRIMARYYes
ItemCodeItem CodenVarChar
20OITM
Items
SysNumberSystem NumberInt
11
QuantityQuantityNum
20
MdAbsEntryMD Abs EntryInt
11

Table relationship map

SELECT statement

SELECT ILM1.MessageID AS 'Message ID', ILM1.ItemCode AS 'Item Code', ILM1.SysNumber AS 'System Number', ILM1.Quantity AS 'Quantity', ILM1.MdAbsEntry AS 'MD Abs Entry' FROM ILM1 AS ILM1

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