biuan SAP® BUSINESS ONE SDK
API ECM3
ECM3 - Statuses and Logs for Actions in Electronic Communication Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal IDInt
11ECM2
Electronic Transactions
PRIMARYYes
LogNumLog NumberInt
11
LogMessageLog MessageText
16
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
LogInstancLog InstanceInt
6
CreateTSCreate Time - Incl. SecsInt
11
UpdateTSUpdate Full TimeInt
11

Table relationship map

SELECT statement

SELECT ECM3.AbsEntry AS 'Internal ID', ECM3.LogNum AS 'Log Number', ECM3.LogMessage AS 'Log Message', ECM3.UserSign AS 'User Signature', ECM3.CreateDate AS 'Creation Date', ECM3.UserSign2 AS 'Updating User', ECM3.UpdateDate AS 'Update Date', ECM3.LogInstanc AS 'Log Instance', ECM3.CreateTS AS 'Create Time - Incl. Secs', ECM3.UpdateTS AS 'Update Full Time' FROM ECM3 AS ECM3

Related information


Electronic Transactions ECM2 SQL Table

Users OUSR 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