Send mail for CATS Approval and pending workitems

Mon Sep 25 11:23:57 EDT 2006

Prasath,

I included my ABAP code for the email utility. We extended CATS by creating a new event called PartiallyCompleted. We run the utility every night and if a timesheet record was approved or rejected on that day the event CATS.PARTIALLYCREATED is launched using SAP_WAPI_CREATE_EVENT. We have a custom workflow just waiting for this event that does nothing but email the employee.

You'll notice that my SELECT statement is kind of long because only certain Absence/Attendance types are workflowed. I also exclude data "approved" by the HR Centre users since they enter data centrally for some remote users.

The utility also includes code to make the email message bilingual because of our language requirements.

Enjoy.

Claude
-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of prasath natesan
Sent: September 25, 2006 9:33 AM
To: SAP Workflow Users' Group
Subject: Re: Send mail for CATS Approval and pending workitems

Hi Claude,
That sounds great. Could you please explain with a little more details on the customization that u did? Our requirements are almost similiar to what you have done. We need e-mail Notifications to be sent on Approvals also. 

Thanks 
Prasath N

On 9/25/06, Claude Bourque <cbourque at bank-banque-canada.ca> wrote: 

	Prasath,

	We build a custom utility for 2 reasons. Reason 1: CATS.COMPLETED wouldn't work because, CATS behaves differently than other workflows. Everytime an employee enters a timesheet record, the entry gets attached to the existing outstanding work item for that employee. So until a manager has approved all records, an employee can keep adding to the work item. Since in some cases completion took several weeks, we decided to create a utility that is run nightly that creates an event to trigger a send email workflow. Reason 2: Although CATS.REJECTED would work, we needed an email for approval as well as rejection. So, again the utility does the trick.

	We've been using it for 2 weeks and so far so good.

	Regards,

	Claude Bourque
	-----Original Message-----
	From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf Of Kjetil Kilhavn
	Sent: September 25, 2006 2:01 AM
	To: SAP Workflow Users' Group

	Subject: RE: Send mail for CATS Approval and pending workitems

	You don't write what version you are on, but assuming you're not on a version with extended notifications (that would have to be 6.x as far as I know) I think the notification via RSWUWFML2 is your best choice for the manager.

	Why don't you use CATS.REJECTED as triggering event for your other solution? I'm not familiar with the standard approval solution for time sheets, so perhaps your answer is "because that event is not triggered" - but looking at BOR object type CATS it seems an obvious choice :-) 

	Looking at program RCATSB01 in our system I see there is a selection screen option to send notification of rejection. Unfortunately the parameter MAIL in function module CATS_DISPLAY_LIST which is called by the program is not referenced in the function module's ABAP code. An OSS message to SAP to see if you receive the standard answer "this is not an error" is perhaps in place. 
	-- 
	Kjetil Kilhavn, Statoil OFT GBS BAS DEV SAP

  _____  

		From: sap-wug-bounces at mit.edu [mailto: sap-wug-bounces at mit.edu <mailto:sap-wug-bounces at mit.edu> ] On Behalf Of prasath natesan
		Sent: 25. september 2006 06:43
		To: SAP Workflow Users' Group
		Subject: Send mail for CATS Approval and pending workitems

		Hi,
		We use approval task TS20000460(approval by superior) for approval of CATS submitted by an employee. This task sends a mail back to the employee if the Approval is rejected by the superior. We have 2 more requirements for this case as follows, 

		1. The initiator should receive an e-mail notification when the CATS submitted by him is approved by the manager.

		For this i have tried to create a custom workflow with a sendmail step. I have assigned CATS-COMPLETED event as the triggering event for this workflow. The problem is this event is triggered in both the cases i.e when the workitem is either Approved or Rejected. I need this workflow to be triggered only in cases of Approval. I also could not find any container elements which shows the status as Aprpoved/Rejected.

		2. The Approver should receive a notification in his inbox whenever the employee submits the time sheets asking him to approve the pending time sheets weekly. 

		For this i think i might be able to use the report RSWUWFML2 and schedule it on a certain time period to check for pending workitems of task TS20000460 and send notifications. But havent yet tried on this. Is there a better way to do this? Any tables that get updated based on this? 

		we are at ECC5.0 with EP6.0

		Any help on the above queries will be of great use.
		Thanks in advance for any help provided.

		Prasath N

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

	====================================================================================

	La version française suit le texte anglais.

	------------------------------------------------------------------------------------ 

	This email may contain privileged and/or confidential information, and the Bank of
	Canada does not waive any related rights. Any distribution, use, or copying of this
	email or the information it contains by other than the intended recipient is 
	unauthorized. If you received this email in error please delete it immediately from
	your system and notify the sender promptly by email that you have done so.

	------------------------------------------------------------------------------------ 

	Le présent courriel peut contenir de l'information privilégiée ou confidentielle.
	La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion,
	utilisation ou copie de ce courriel ou des renseignements qu'il contient par une 
	personne autre que le ou les destinataires désignés est interdite Si vous recevez
	ce courriel par erreur, veuillez le supprimer immédiatement et envoyer sans délai à
	l'expéditeur un message électronique pour l'aviser que vous avez éliminé de votre 
	ordinateur toute copie du courriel reçu.

	_______________________________________________
	SAP-WUG mailing list
	SAP-WUG at mit.edu 
	http://mailman.mit.edu/mailman/listinfo/sap-wug

====================================================================================

La version française suit le texte anglais.

------------------------------------------------------------------------------------

This email may contain privileged and/or confidential information, and the Bank of
Canada does not waive any related rights. Any distribution, use, or copying of this
email or the information it contains by other than the intended recipient is
unauthorized. If you received this email in error please delete it immediately from
your system and notify the sender promptly by email that you have done so. 

------------------------------------------------------------------------------------

Le présent courriel peut contenir de l'information privilégiée ou confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient par une
personne autre que le ou les destinataires désignés est interdite. Si vous recevez
ce courriel par erreur, veuillez le supprimer immédiatement et envoyer sans délai à
l'expéditeur un message électronique pour l'aviser que vous avez éliminé de votre
ordinateur toute copie du courriel reçu.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20060925/19067fec/attachment.htm
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: z_cats_email.txt
Url: http://mailman.mit.edu/pipermail/sap-wug/attachments/20060925/19067fec/attachment.txt