SAP_WAPI_COUNT_WORKITEMS result.

[Bijay Shrestha]

Those Note addresses the issue but in Release 610 and higher. We are in
Version 4.6c.=20
 
Bijay Shrestha=20
Ph: (763) 764-2201=20
Email: Bijay.Shrestha at genmills.com=20
"WebFlow gets the right information to the right people at the right
time!"
 
 
 
 
-----Original Message-----
From: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] On Behalf Of
Michael Pokraka
Sent: Tuesday, May 11, 2004 11:02 AM
To: SAP-WUG at MITVMA.MIT.EDU
Subject: Re: SAP_WAPI_COUNT_WORKITEMS result.
 
 
Hi,
There are notes which address these issues:
680147 Deadline items not deleted from SWWUSERWI
 
and if you use SWUS, it can also leave some nasties in SWWUSERWI, use
706806 Data inconsistency with synchronous chains to fix. Cheers Mike
 
 
Kjetil Kilhavn wrote:
> It can't be just that (I think) - because we don't use deadline=20
> notifications and have seen the same thing. If I recall correctly our=20
> best guess was that the function returns the sum of workitems with you
 
> as a specified agent and with no specified agent (e.g. available to=20
> all), even if those without agents were also having no possible agents
 
> (e.g. not visible to anyone).
>
> E.g. in our quality system I have 2 quality notifications in my inbox.
>
> There are four entries in SWWUSERWI on my user ID. The two which are=20
> not in my inbox are work items which I have forwarded (in 2002...).=20
> There are 27 entries with no user ID in SWWUSERWI.
>
> The function returns ... to my surprise ... 2!
>
> The two entries on my user which are not appearing in my inbox and all
 
> the entries with no user ID have the indicator NO_SEL set (no=20
> relevance for selection). That is probably why they are not included.
>
> I tried replacing one of the workitems without user ID. The NO_SEL=20
> indicator was cleared. The function then returns 3, but there are also
 
> 3 work items visible in my inbox now.
>
>
> Data are too good in our test system. Now in the development system...
 
> the function returns 40 and my inbox shows 31 (while SWI5 shows=20
> 35...). The function matches the number of entries in SWWUSERWI with=20
> either my user or no user and with NO_SEL =3D space.
>
> The 5 entries not displayed in SWI5 are all general tasks. I don't=20
> know the significance of it, but they all have agents and are waiting=20
> for completion either by user confirmation or by an event.
>
> Don't know if this makes you any wiser, but it could at least give you
 
> some ideas about where to look. At least I got a little bit wiser, by=20
> discovering the significance of the NO_SEL flag.
> --
> Kjetil Kilhavn
>
>
>
>
>                     "Jeffrey A.
>                     Rappaport"                  To:
> SAP-WUG at MITVMA.MIT.EDU
>                     <Jeff at Business-Workf        cc:     (bcc: Kjetil
> Kilhavn)
>                     low.com>                    Subject:     Re:
> SAP_WAPI_COUNT_WORKITEMS result.
>                     Sent by: SAP
>                     Workflow
>                     <Owner-SAP-WUG at MITVM
>                     A.MIT.EDU>
>
>
>                     10.05.2004 18:20
>                     Please respond to
>                     "SAP Workflow Users'
>                     Group"
>
>
>
>
>
>
> Bijay,
>
>    Are you using Deadline Monitoring in the WF's? If so I believe the=20
> big difference in SWWUSERWI is it includes all the DM Message Items=20
> that go to the User. Tranx: SBWP & SWI5 should match up. And the FM's=20
> RH_WI_PER_USER_COUNT & SAP_WAPI_COUNT_WORKITEMS should match up.
>
> Jeffrey A. Rappaport
> Business Workflow, LLC
> Voice:(732)355-0123
> Fax:  (509)757-4144
> Email:Jeff at Business-Workflow.com
> Web:  www.Business-Workflow.com
>
>
> Quoting Bijay Shrestha <Bijay.Shrestha at genmills.com>:
>
>> Thanks for your help.
>>
>> I have my program in Prod. Where I did querry against Swwwihead=20
>> table. I'm getting the correct number if user has reserved. Logically
 
>> it's working fine. Only the issue we have is end users are=20
>> complaining about
>> performance because it takes little longer. That's why I thought if
>> I
>> could use this FM instead.
>>
>> The number 210 matches with the records in table SWWUSERWI but it=20
>> seems like those records doesn't match with the WI in the inbox. I=20
>> just deleted few WI from my Inbox to reduce the number, then checked=20
>> the table SWWUSERWI. In the table number doesn't change, it's still
>> 210.
>>
>> Therefore seems like I can't use this FM.
>>
>> Thanks for your help again.
>>
>> Bijay Shrestha
>>
>>
>>
>>
>> -----Original Message-----
>>> From: SAP Workflow [mailto:Owner-SAP-WUG at MITVMA.MIT.EDU] On Behalf Of
>> Kjetil Kilhavn
>> Sent: Sunday, May 09, 2004 4:14 AM
>> To: SAP-WUG at MITVMA.MIT.EDU
>> Subject: Re: SAP_WAPI_COUNT_WORKITEMS result.
>>
>>
>> Look at table SWWUSERWI and see if the number of workitems there on
>> either your user or no user matches the 210.
>> --
>> Kjetil Kilhavn
>>
>>
>>
>>
>>
>>
>>                     "Miller, Jerry"
>>                     <Jerry.Miller at NOVELL        To:
>> SAP-WUG at MITVMA.MIT.EDU
>>                     US.com>                     cc:     (bcc:
>> Kjetil
>> Kilhavn)
>>                     Sent by: SAP                Subject:     Re:
>> SAP_WAPI_COUNT_WORKITEMS result.
>>                     Workflow
>>                     <Owner-SAP-WUG at MITVM
>>                     A.MIT.EDU>
>>
>>
>>                     08.05.2004 00:09
>>                     Please respond to
>>                     "SAP Workflow Users'
>>                     Group"
>>
>>
>>
>>
>>
>>
>>         Bijay,
>>
>>         You can create a simple Query to get this data using tables
>> SWWWIHEAD and SWWORGTASK.
>>
>>
>> -----Original Message-----
>>> From: Bijay Shrestha [mailto:Bijay.Shrestha at genmills.com]
>> Sent: Friday, May 07, 2004 2:57 PM
>> To: SAP-WUG at MITVMA.MIT.EDU
>> Subject: SAP_WAPI_COUNT_WORKITEMS result.
>>
>>
>> I did go through the archive and found lots of discussion about
>> this
>> function module sap_wapi_count_workitems. We're in 4.6c version. In
>> my
>> inbox there are 137 workitems but this FM tells me that I have 210
>> items. It doesn't make sense to me.
>>
>> Then I went further one step and run another FM
>> RH_WI_PER_USER_COUNT
>> which gives me same result which groups by Task#. Have somebody
>> answer
>> on this what are all this numbers. I need to know the number of
>> workitems in somebody's inbox in my program.
>>
>>
>> Bijay Shrestha
>> Ph: (763) 764-2201
>> Email: Bijay.Shrestha at genmills.com
>> "WebFlow gets the right information to the right people at the
>> right
>> time!"
>>
>>
>>
>>
>> -------------------------------------------------------------------
>> The information contained in this message may be CONFIDENTIAL and
>> is
>> intended for the addressee only. Any unauthorised use,
>> dissemination of
>> the information or copying of this message is prohibited. If you
>> are not
>> the addressee, please notify the sender immediately by return
>> e-mail and
>> delete this message. Thank you.
>>
>
>
>
>
> -------------------------------------------------------------------
> The information contained in this message may be CONFIDENTIAL and is
> intended for the addressee only. Any unauthorised use, dissemination
of the
> information or copying of this message is prohibited. If you are not
the
> addressee, please notify the sender immediately by return e-mail and
delete
> this message.
> Thank you.
>
>