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.
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.