Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Tables for agent in tasks

roelof_sol2
Explorer
0 Kudos

I want to search through all the tasks within the workflows and find where a specific role (Agent type AG) is used as an agent. Which tables can i use (or tables with relations) to find this information ?

Roelof Sol

1 ACCEPTED SOLUTION

ronen_weisz
Active Contributor
0 Kudos

role (object type AG) = authorizations

rule (object type AC) = workflow

If it is workflow you are looking for, then the table is swdsexpr with;

exprtype = '013'

expression = 'AC<rule number>'

version = 9999 if you want the active version.

4 REPLIES 4

ronen_weisz
Active Contributor
0 Kudos

role (object type AG) = authorizations

rule (object type AC) = workflow

If it is workflow you are looking for, then the table is swdsexpr with;

exprtype = '013'

expression = 'AC<rule number>'

version = 9999 if you want the active version.

former_member215542
Active Participant
0 Kudos

You could check table HRP1001

Object type = TS (Standard Task)

Plan version = 01 Current plan

Object ID - Task number

Related object ID (SCLAS) = AG

This should list down all tasks that have role assigned

Former Member
0 Kudos

Hi,

Agent assignment on tasks is stored in HRP1001.

Check table SWWWIAGENT. BUT, I think it only contains agents that actually started processing of a task

former_member625343
Discoverer
0 Kudos

Hi,

This thread was posted long time ago but in case anyone need some clues.

The table for responsible agent in a specific Workflow item is SWWUSERWI

Thanks and Regards,

Ken