select statement failing on SWWWIHEAD table

[former_member783875]

I am trying to determine the pending agents from SWWWIHEAD table by passing top work item id to top_wi_id field and wi_type = 'W'(Activity) and wi_stat = 'READY', but select statement returning a sy-subrc value of 4. Not able to find the exact reason, could someone help me on this.

[Sandra_Rossi]

No surprise, the reason is that SELECT doesn't find the line. Now impossible to help more if you don't investigate on your own and don't explain the context.

[MaKu]

I cannot answer your question directly as I do not know your database content.

However, I suggest to use table SWWUSERWI

[former_member783875]

Hi Manuela,

I do have entries in the table that satisfy select where conditions, please find the screenshot below.

[former_member783875]

my requirement is that for a request when user clicks on history button he would like to see where the workitem was pending, its series of approvals that were in loop statement of workflow.

My logic is that from SWWWIHEAD i get the top workitem id from current workitem id then from top workitem id i navigate to workitem that is of activity type and status is READY.

Even the SWWUSERWI table have workitem id as key field. So i need to pass workitem id to the table then get the user. To get the workitem id i need to use SWWWIHEAD table, which is failing in my case.