|
|
SQL Administration / Task Notes
API AWL3
AWL3 - Task Notes Table
Workflow - Task Details OWLS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WFInstID | Workflow Instance ID | Int | 11 |
|---|---|---|---|---|---|---|---|---|
| TaskID KEY UNIQUE | Task ID | Int | 11 | OWLS Workflow - Task Details | PRIMARY | Yes | ||
| LineID | Line ID | Int | 11 | |||||
| Note | Note | Text | 16 | |||||
| Creator | Creator | nVarChar | 8 | |||||
| NoteDate | Note Date | Date | 8 | |||||
| Access | Accessibility | VarChar | W) Workflow T) Task | 1 | W | |||
| LogIns | Log Instance | Int | 11 |
SELECT statement
SELECT
AWL3.WFInstID AS 'Workflow Instance ID',
AWL3.TaskID AS 'Task ID',
AWL3.LineID AS 'Line ID',
AWL3.Note AS 'Note',
AWL3.Creator AS 'Creator',
AWL3.NoteDate AS 'Note Date',
AWL3.Access AS 'Accessibility',
AWL3.LogIns AS 'Log Instance'
FROM AWL3 AS AWL3
Related information
Workflow - Task Details OWLS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
