How to retrieve List of WorkItems for a user ?

List of WorkItems for a User
List of WorkItems for a User

You will find here the different methods to extract the list of WorkItems by user and TaskID.

First we will start with the existing SAP Standard Function/BAPI to retrieve user’s WorkItems. Then we will have a look on Work Items and User tables in SAP Workflow.

Function/BAPI Retrieve Work Item by User

Count Work Items for User

Let’s start by counting the Work Items for a SAP User. You can use the function: SAP_WAPI_COUNT_WORKITEMS.You should fill the user in USER and you can filter by Work Items, Task_Id.
Here the signature ofSAP_WAPI_COUNT_WORKITEMS: Workflow Interfaces: Number of Work Items for User.

Check this book about ABAP Development for SAP Business Workflow

SAP_WAPI_WORKITEMS_BY_TASK

The standard function moduleSAP_WAPI_WORKITEMS_BY_TASK is all what you need to extract list of Work Items for a SAP user.
You can filter by Time, User, Work Items Types(WORKITEM_TYPE_FILTER[]) and Task_ID (TASK_FILTER[]).
The Result will be in WORKLIST containing all relevant information for User’s Work Items.

Read also All you need to know about SAP SRM Confirmation TroubleShooting

Here the signature of SAP_WAPI_WORKITEMS_BY_TASK:

Work Items and User Related Tables

SAP Work Item Header Table SWWWIHEAD

SWWWIHEAD: Workflow Runtime: Header Table for All Work Item Types
You will find data such as :

  • WI_ID: Work item ID
  • WI_TYPE: Work item type
  • WI_CREATOR: Creator of a work item
  • WI_RH_TASK: Task ID
  • WI_AAGENT: SWW_AAGENT

SWFDEVENA: Activations for Event Linkages

List of Current Work ITems assigned to a User : SWWUSERWI

SWWUSERWI: Current Work Items Assigned to a User.
The fields of SWWUSERWI are:

  • USER_ID: User Name in User Master Record
  • WI_ID: Work item ID
  • TASK_OBJ: Concatenation of Object Type and Object ID
  • NO_SEL: Indicator: Entry has no Relevance to Selection
  • NO_EXECUTE: Work Item May Not be Executed by User Specified
  • FORWARD: Indicator: Work Item was Forwarded

Assignment of WIs to Org. Unit/Task: SWWORGTASK

SWWORGTASK:Workflow Runtime: Assignment of WIs to Org. Unit/Task
You can use this table if you want retrieve the list of Work Items by an Organization Unit rather than SAP User.

  • WI_ID :Work item ID
  • ORG_OBJ :Concatenated Identification (Type and ID) of Org.Objects
  • TASK_OBJ :Task
  • IDNO_SEL :Indicator: Entry has no Relevance to Selection
  • FORWARD: Indicator: Work Item was Forwarded

Note that you can use directly the SAP Transaction codeSWI5.
The Tcode SWI5 offers filtering Work Items by : Org. Unit, Type ( Completed Work Items, To Be Completed WI), Date, Task, Task Group and Application Component.

Check also The Most important SAP Workflow Transactions List

SAP Work Item History Table: SWWLOGHIST

SWWLOGHIST: Workflow Runtime: History of a Work Item
In the SAP Work Item History Tables, you will find all the information you need.

Check the following fields:

  • WI_ID : Work item ID
  • METH_USER: Actual Agent of Work Item

You may also like...