topic Re: Status during Time Sheet Validation in Application Development and Automation Discussions

Status during Time Sheet Validation

Former Member — Wed, 06 Aug 2014 07:40:02 GMT

Hi All,

We are trying to restrict the total number of hours one can book under a particular Work Type.

We are using the User Exit EXIT_SAPLCATS_006 for this purpose.

As we all know user can submit Multiple entries under the same work type. Some can be approved, some can be rejected or some can be cancelled.

But the structure CATS_COMM of the Exit does not have STATUS field to check entries which entries are approved/Cancelled/rejected.

We have to consider entries only with statuses 10 20 and 30. If we don't consider statuses it will give erroneous results.

If anyone has faced such issues please let us know.

How we can overcome this scenario.

Is there any other User Exit or BADI for the same purpose.

Thanks and Regards,

Vinay Mutt

Re: Status during Time Sheet Validation

Former Member — Wed, 06 Aug 2014 08:01:15 GMT

Try to fetch STATUS data from CATSDB table using CATS_COMM - PERNR, WORKDATE.

You may get multi entires from CATSDB, so, do sort on COUNTER and get the latest STATUS.

Cheers.

Dara.

Re: Status during Time Sheet Validation

Former Member — Wed, 06 Aug 2014 09:18:06 GMT

Dear Rajesh,

Structure CATS_COMM Does not have even Counter (Field COUNTER of type CATSCOUNTE Which is the Primary key of CATSDB). So only I posted this thread.

Regards,

Vinay Mutt

Re: Status during Time Sheet Validation

Former Member — Thu, 10 Sep 2015 16:10:51 GMT

Dear Vinay,

I have the same problem than you, I need STATUS value for validation when a new entry is being created in My Timesheet application. Did you resolve this?? Can you help me?

Thanks a lot.

Best Regards.

Luis

Re: Status during Time Sheet Validation

Former Member — Thu, 10 Sep 2015 16:29:59 GMT

Dear Vinay,

I've solved it adding a new append structure for CATS_COMM structure, with 'STATUS' field. Simply like this, and in your internal table for User-Exit, status for cats entry will be informed.

Regards.

Luis