SWWUSERWI data is not same with SWI5 transaction data
I facing an issue while finding out the exact work items pending with user1. SWWUSERWI table has approximately 1560 work items pending with him. But when I see through SWI5 transaction found out only 420 work items pending with him. In table I am only using USER parameter and in SWI5 t-code only US and user1 name.
For testing I took one work item from table and see the agent details through SWIA. But didn't find user1 listed.
Please tell me why is the difference.
Ronen Weisz replied
Pay attention that:
in SWI5 there are 2 places where user task's are displayed - under the user's name, and in the "not reserved by an agent" section. both are in the user's inbox - the not reserved ones - he/she simply hasn't entered them yet.
in SWWUSERWI there is an irrelevant (no_sel) field, if it's marked the user will not see the task in his/hers inbox. this field in marked if 2 users (or more) have the workitem and one of them starts working on it/reserves it - all other users will not see it in their inbox and in the SWWUSERWI table it will be marked as X in the no_sel field.