<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi, for making the custom report based on object key, please do the following procedure. </DIV>
<DIV>1) Get the correspodning workitem id for the object key </DIV>
<DIV> from table sww_wi2obj</DIV>
<DIV>2) Once you get the workitem details, you can get the workitem history </DIV>
<DIV>fron tables swwwi*hist and sww*user tables. </DIV>
<DIV> </DIV>
<DIV>3) By using this and also you can restrict based on task for better performance. </DIV>
<DIV> </DIV>
<DIV>This way you can get to know the current status of the workflow and the agent and every details. </DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV>Ravi<BR><BR>--- On <B>Thu, 21/8/08, sap-wug-request@mit.edu <I><sap-wug-request@mit.edu></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: sap-wug-request@mit.edu <sap-wug-request@mit.edu><BR>Subject: SAP-WUG Digest, Vol 45, Issue 50<BR>To: sap-wug@mit.edu<BR>Date: Thursday, 21 August, 2008, 11:01 AM<BR><BR><PRE>Send SAP-WUG mailing list submissions to
sap-wug@mit.edu
To subscribe or unsubscribe via the World Wide Web, visit
http://mailman.mit.edu/mailman/listinfo/sap-wug
or, via email, send a message with subject or body 'help' to
sap-wug-request@mit.edu
You can reach the person managing the list at
sap-wug-owner@mit.edu
When replying, please edit your Subject line so it is more specific
than "Re: Contents of SAP-WUG digest..."
Today's Topics:
1. Re: WF Builder - Can not generate/activate WF !?! (BJ)
2. Custom report to know the workflow approval status (Ibrahim Khan)
3. Re: Custom report to know the workflow approval status
(Rahul Shukla)
4. Re: Custom report to know the workflow approval status
(Ibrahim Khan)
----------------------------------------------------------------------
Message: 1
Date: Wed, 20 Aug 2008 13:59:10 -0500
From: BJ <shresthab@gmail.com>
Subject: Re: WF Builder - Can not generate/activate WF !?!
To: "SAP Workflow Users' Group" <sap-wug@mit.edu>
Message-ID:
<675cac310808201159g6f49eda8ud09f994f969678df@mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"
Hi Sue,
Long time ago I had this issue. However I don't exactly remember what I did
to fix. However I could remember one thing that instead of building from
scractch again I just activated the one version older than my current one.
You might have already tried this.
Have a great day.
Bijay
2008/8/20 Keohan, Susan <keohan@ll.mit.edu>
> Hi Bijay,
>
> Good to hear from you.
>
> I have chalked this one up to the mysterious 'workflow definition was
> corrupted' and started rebuilding from scratch.
>
> I'd still be interested to hear if anyone else had this happen though.
>
> Cheers,
>
> Sue
>
>
>
> ----
>
> Susan R. Keohan
>
> SAP Workflow Specialist
>
> Enterprise Applications
>
> Information Services Department
>
> MIT Lincoln Laboratory
>
> 244 Wood Street, LI-200
>
> Lexington, MA. 02420
>
> 781-981-3561
>
> keohan@LL.MIT.EDU
>
>
> ------------------------------
>
> *From:* sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] *On
> Behalf Of *BJ
> *Sent:* Wednesday, August 20, 2008 1:04 PM
> *To:* SAP Workflow Users' Group
> *Subject:* Re: WF Builder - Can not generate/activate WF !?!
>
>
>
> Hi Sue,
>
>
>
> I hope other than this issue, rest is going well with you.
>
>
>
> I'd ask your Basis friend to do the same thing that you're trying
and see
> if it works with his id. If it works then it could be authorization issue.
>
>
>
> Good luck!
>
>
>
> Bijay Shrestha
>
> 2008/8/20 Keohan, Susan <keohan@ll.mit.edu>
>
> Greetings all,
>
>
>
> I am on 4.6c, SP SAPKB46C51, GUI version 7100.1.6.3075.
>
>
> Building and changing a new WF template, and the buttons (wrench for Test,
> match for Activate) menu paths (Workflow > Generate runtime version,
> Workflow > Generate and activate runtime version, Workflow > Test)
all
> produce the *same message* as the Check button. The status of the
> workflow may change to Saved, but never activated.
>
> This is not related to
>
> a) my machine (can replicate on a co-worker's machine)
>
> b) the GUI ? can replicate on a co-worker's machine using 640 GUI
>
> c) The Workflow itself ? have copied to a new version and encounter
> same issues there
>
> d) My Userid ? I had my friends in Basis create a new userid
>
>
>
> There are no short dumps, no RFC errors.
>
> Needless to say, I am at a loss. My Basis friends are looking into it,
but
> if anyone else has experienced, I'd appreciate any light you could
shed.
>
> Happy WF-ing,
> Sue
>
>
>
> ----
>
> Susan R. Keohan
>
> SAP Workflow Specialist
>
> Enterprise Applications
>
> Information Services Department
>
> MIT Lincoln Laboratory
>
> 244 Wood Street, LI-200
>
> Lexington, MA. 02420
>
> 781-981-3561
>
> keohan@LL.MIT.EDU
>
>
>
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG@mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
>
>
> --
> Bijay Shrestha
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG@mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
--
Bijay Shrestha
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.mit.edu/pipermail/sap-wug/attachments/20080820/02d2167f/attachment-0001.htm
------------------------------
Message: 2
Date: Thu, 21 Aug 2008 11:14:18 +0800
From: "Ibrahim Khan" <ikhansap@gmail.com>
Subject: Custom report to know the workflow approval status
To: "SAP Workflow Users' Group" <SAP-WUG@mit.edu>
Message-ID:
<fff808000808202014q4f0b3ac4h439ca547a94428d5@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hi Friends,
For one of my custom workflow the client needs a custom report to know the
approval status. This custom workflow will be a multilevel approval and they
want to know the status based on the object key(document number) like who
has approved it at what time, who else has to approve etc which standard
workflow tables can be used for this? Please advice.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.mit.edu/pipermail/sap-wug/attachments/20080821/45beb29a/attachment-0001.htm
------------------------------
Message: 3
Date: Wed, 20 Aug 2008 20:58:33 -0700 (PDT)
From: Rahul Shukla <rahul_ariean@yahoo.com>
Subject: Re: Custom report to know the workflow approval status
To: "SAP Workflow Users' Group" <sap-wug@mit.edu>
Message-ID: <859783.55274.qm@web32006.mail.mud.yahoo.com>
Content-Type: text/plain; charset=us-ascii
Pls go to se12 and search for swww*, there are header and workitem tables from
where based upon ur object name and task names, you can retrieve such
information.
You may need to join ur custom tables too to get the next level of approvers ,
if you are maintaing there.
Regards,
Rahul
Something that can't be re-cycled is Wasted Time.
--- On Thu, 8/21/08, Ibrahim Khan <ikhansap@gmail.com> wrote:
> From: Ibrahim Khan <ikhansap@gmail.com>
> Subject: Custom report to know the workflow approval status
> To: "SAP Workflow Users' Group" <SAP-WUG@mit.edu>
> Date: Thursday, August 21, 2008, 8:44 AM
> Hi Friends,
> For one of my custom workflow the client needs a custom
> report to know the
> approval status. This custom workflow will be a multilevel
> approval and they
> want to know the status based on the object key(document
> number) like who
> has approved it at what time, who else has to approve etc
> which standard
> workflow tables can be used for this? Please advice.
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG@mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
------------------------------
Message: 4
Date: Thu, 21 Aug 2008 13:30:50 +0800
From: "Ibrahim Khan" <ikhansap@gmail.com>
Subject: Re: Custom report to know the workflow approval status
To: "SAP Workflow Users' Group" <sap-wug@mit.edu>
Message-ID:
<fff808000808202230j776fd3d7uc62978e9c0c2fec3@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I am working on the Appropriation Request workflow for PS.
The information is not stored in standard tables because the approvers are
dynamic and selected while creating the Appropriation request.
In this case I need to explore the workflow related tables to create this
custom report.
On Thu, Aug 21, 2008 at 11:58 AM, Rahul Shukla
<rahul_ariean@yahoo.com>wrote:
> Pls go to se12 and search for swww*, there are header and workitem tables
> from where based upon ur object name and task names, you can retrieve such
> information.
>
> You may need to join ur custom tables too to get the next level of
> approvers , if you are maintaing there.
>
> Regards,
> Rahul
> Something that can't be re-cycled is Wasted Time.
>
>
> --- On Thu, 8/21/08, Ibrahim Khan <ikhansap@gmail.com> wrote:
>
> > From: Ibrahim Khan <ikhansap@gmail.com>
> > Subject: Custom report to know the workflow approval status
> > To: "SAP Workflow Users' Group" <SAP-WUG@mit.edu>
> > Date: Thursday, August 21, 2008, 8:44 AM
> > Hi Friends,
> > For one of my custom workflow the client needs a custom
> > report to know the
> > approval status. This custom workflow will be a multilevel
> > approval and they
> > want to know the status based on the object key(document
> > number) like who
> > has approved it at what time, who else has to approve etc
> > which standard
> > workflow tables can be used for this? Please advice.
> > _______________________________________________
> > SAP-WUG mailing list
> > SAP-WUG@mit.edu
> > http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG@mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.mit.edu/pipermail/sap-wug/attachments/20080821/503376f1/attachment.htm
------------------------------
_______________________________________________
SAP-WUG mailing list
SAP-WUG@mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug
End of SAP-WUG Digest, Vol 45, Issue 50
***************************************
</PRE></BLOCKQUOTE></td></tr></table><br>
<!--2--><hr size=1></hr> Unlimited freedom, unlimited storage. <a href="http://in.rd.yahoo.com/tagline_mail_2/*http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/">Get it now</a>