|
|
DTW Inventory / Inventory Transactions / Inventory Revaluation
API AWL2
AWL2 - Input data for tasks 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 | |||||
| ObjectType | Object Type | nVarChar | 20 | |||||
| ObjKey | Object Key | nVarChar | 100 | |||||
| Command | Command | VarChar | B) Based On M) Field Mapping | 1 | B | |||
| LogIns | Log Instance | Int | 11 | |||||
| ObjSubType | Object Subtype | nVarChar | 64 | |||||
| ObjDetail | Object Detail | Text | 16 |
SELECT statement
SELECT
AWL2.WFInstID AS 'Workflow Instance ID',
AWL2.TaskID AS 'Task ID',
AWL2.LineID AS 'Line ID',
AWL2.ObjectType AS 'Object Type',
AWL2.ObjKey AS 'Object Key',
AWL2.Command AS 'Command',
AWL2.LogIns AS 'Log Instance',
AWL2.ObjSubType AS 'Object Subtype',
AWL2.ObjDetail AS 'Object Detail'
FROM AWL2 AS AWL2
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
