|
|
SQL Others / User Action Log
API OUAL
OUAL - User Action Log Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Id KEY UNIQUE | ID | Identity | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UserId | User Id | Int | 6 | OUSR Users | ||||
| ActionDate KEY | Action Date | Date | 8 | TIME | No | |||
| ActionTime | Action Time | Int | 11 | |||||
| ActionType | Action Type | VarChar | 1 | |||||
| ObjectId KEY | Object Id | Int | 11 | ID_KEY | No | |||
| ObjectKey | Object Key | nVarChar | 64 |
SELECT statement
SELECT
OUAL.Id AS 'ID',
OUAL.UserId AS 'User Id',
OUAL.ActionDate AS 'Action Date',
OUAL.ActionTime AS 'Action Time',
OUAL.ActionType AS 'Action Type',
OUAL.ObjectId AS 'Object Id',
OUAL.ObjectKey AS 'Object Key'
FROM OUAL AS OUAL
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
