biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Deduction Tax Hierarchies
API Message Data Lines / Message Data Line
ALR3 - Dynamic message data cells Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInternal NumberInt
11OALR
Alerts
PRIMARYYes
LocationNumber of Column in MessageInt
11
LineNumber of Column in MessageInt
11
ValueThe column/row valuenVarChar
127
ObjTypeThe linked objectnVarChar
20
KeyStrKey string in linked objectnVarChar
127

SELECT statement

SELECT ALR3.Code AS 'Internal Number', ALR3.Location AS 'Number of Column in Message', ALR3.Line AS 'Number of Column in Message', ALR3.Value AS 'The column/row value', ALR3.ObjType AS 'The linked object', ALR3.KeyStr AS 'Key string in linked object' FROM ALR3 AS ALR3

Related information


Message Data Line MessageDataLine Object· Table: ALR3
The MessageDataLine is a child data structure related to the MessageDataColumn. It contains the value of a specified cell in the Data table, which is defined by its column number (vtIndex of Item of MessageDataColumns) and row number (vtIndex...
   Parent: Message Data Lines MessageDataLines Collection
Alerts OALR 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