Timesheet rejection workflow
I'm trying to develop a workflow that sends out email(outlook) to creator of timesheet in case his timesheet gets rejected.
Following are the steps that I did
Custom business object ZCATS which is subtype of CATS.
In ZCATS I've a background method called STATUS with reads status field in table CATSDB.
Workflow gets triggered with 'completed' event. Since 'completed' event is the only event that generates for both approval and rejection, I check using background method STATUS if field 'status' in catsdb holds value '40'(rejected). In that case I sends out a email.
Now my problem is Key field in business object CATS is different from that in CATSDB. Key field of CATSDb is COUNTER while that of business object CATS is workitem id.
I'm able to trigger my workflow but fails when it reaches the background method
How do I proceed? Any better ideas? I will make sure that I award points to any useful hints