|
|
API AWLS
AWLS - Workflow - Task Details Table
Workflow - Instances OWFI SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WFInstID | Workflow Instance ID | Int | 11 | OWFI Workflow - Instances |
|---|---|---|---|---|---|---|---|---|
| TaskID KEY UNIQUE | Task ID | Int | 11 | PRIMARY | Yes | |||
| WFID | Workflow ID | nVarChar | 64 | |||||
| WFName | Workflow Name | nVarChar | 100 | |||||
| TaskDesc | Task Description | nVarChar | 100 | |||||
| ObjType | Object Type | nVarChar | 20 | |||||
| Operation | Operation | VarChar | 1 | |||||
| ObjKey | Object Key | nVarChar | A) Add U) Update D) Delete | 100 | ||||
| EnterDate | Enter Date | Date | 8 | |||||
| EnterTime | Enter Time | Int | 6 | |||||
| TaskType | Task Type | VarChar | U) User Task M) Manual Task | 1 | ||||
| DueDate | Due Date | Date | 8 | |||||
| DueTime | Due Time | Int | 6 | |||||
| UpdateDate | Update Date - History | Date | 8 | |||||
| UpdateTime | Update Time - History | Int | 6 | |||||
| Owner | Owner | nVarChar | 8 | |||||
| Priority | Priority | Int | 6 | |||||
| UserSign | User Signature | Int | 1) High 2) Medium 3) Low | 6 | 2 | |||
| Status | Status | VarChar | S) Setup W) To Be Picked P) Picking G) In Progress D) Completing F) Completed N) Suspended C) Cancelling Q) Canceled O) Forwarding E) Error | 1 | W | |||
| LogIns | Log Instance - History | Int | 11 | |||||
| UserSign2 | Updating User - History | Int | 6 | |||||
| Deleted | Deleted - History | VarChar | 1 | |||||
| DuraDays | Duration Days | Int | 11 | |||||
| DuraHours | Duration Hours | Int | 6 | |||||
| TaskName | Task Name | nVarChar | 100 | |||||
| isPicked | Is Picked | VarChar | 1 | |||||
| Attachment | Attachment | Text | 16 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| WorkListId | Worklist ID | Int | 11 | |||||
| ObjSubType | Object Subtype | nVarChar | 64 | |||||
| ForwardTo | User to Forward | nVarChar | 8 | |||||
| WasRead | Line Read | VarChar | 1 | N | ||||
| TrigParams | Trigger Parameters | Text | 16 |
SELECT statement
SELECT
AWLS.WFInstID AS 'Workflow Instance ID',
AWLS.TaskID AS 'Task ID',
AWLS.WFID AS 'Workflow ID',
AWLS.WFName AS 'Workflow Name',
AWLS.TaskDesc AS 'Task Description',
AWLS.ObjType AS 'Object Type',
AWLS.Operation AS 'Operation',
AWLS.ObjKey AS 'Object Key',
AWLS.EnterDate AS 'Enter Date',
AWLS.EnterTime AS 'Enter Time',
AWLS.TaskType AS 'Task Type',
AWLS.DueDate AS 'Due Date',
AWLS.DueTime AS 'Due Time',
AWLS.UpdateDate AS 'Update Date - History',
AWLS.UpdateTime AS 'Update Time - History',
AWLS.Owner AS 'Owner',
AWLS.Priority AS 'Priority',
AWLS.UserSign AS 'User Signature',
AWLS.Status AS 'Status',
AWLS.LogIns AS 'Log Instance - History',
AWLS.UserSign2 AS 'Updating User - History',
AWLS.Deleted AS 'Deleted - History',
AWLS.DuraDays AS 'Duration Days',
AWLS.DuraHours AS 'Duration Hours',
AWLS.TaskName AS 'Task Name',
AWLS.isPicked AS 'Is Picked',
AWLS.Attachment AS 'Attachment',
AWLS.AtcEntry AS 'Attachment Entry',
AWLS.WorkListId AS 'Worklist ID',
AWLS.ObjSubType AS 'Object Subtype',
AWLS.ForwardTo AS 'User to Forward',
AWLS.WasRead AS 'Line Read',
AWLS.TrigParams AS 'Trigger Parameters'
FROM AWLS AS AWLS
Related information
Workflow - Instances OWFI SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
