biuan SAP® BUSINESS ONE SDK
API OBTL
OBTL - Bin Transaction Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
MessageID KEYILM Message IDInt
11OILM
Inventory Log Message
MESSAGE_IDNo
BinAbs KEYBin Internal NumberInt
11OBIN
Bin Location
BIN_ABSNo
SnBMDAbsSnB Master Data Internal NumberInt
11
-1
QuantityQuantityNum
20
ITLEntryITL Log Internal IDInt
11OITL
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



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