|
|
API ECM3
ECM3 - Statuses and Logs for Actions in Electronic Communication Table
Electronic Transactions ECM2 SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal ID | Int | 11 | ECM2 Electronic Transactions | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LogNum | Log Number | Int | 11 | |||||
| LogMessage | Log Message | Text | 16 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Update Date | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 6 | |||||
| CreateTS | Create Time - Incl. Secs | Int | 11 | |||||
| UpdateTS | Update Full Time | Int | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
