on 07-06-2015 11:48 AM
Hi All,
How to know on which date employee has created a leave request in ESS?
Any standard table or program which fulfils the above requirement?
I am not sure if Program - RPTARQDBVIEW suffice the same.
Regards,
Kunal Pawar
Hi Kunal
I think you already stated the answer and just to add something you can use SWIA to see the workitem creation date as well
Good luck
a
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andrea,
The reason i said that i am not sure is because as per my understanding in Program - RPTARQDBVIEW column 'Last Changed On/By' does initially provides the date when employee applies for the leave request.
However if any decision(approve or reject) has been taken by the next agent then this column reflects the latest date and not the date on which employee has applied.
Also as said by you , using SWIA will provide the date for workitem creation however it is very time consuming go inside each workitem as i need the data for 2 months.
Correct me if i am wrong.
Regards,
Kunal Pawar
Hi Andrea,
Thanks for your efforts.
Although the process mentioned above will help to the get the dates for which the leave request was applied for (from table - PTREQ_ATTABSDATA - columns - BEGDA and ENDDA) .
However i didn't find any column providing details of dates on which the leave requests were applied.
Please suggest.
Regards,
Kunal Pawar.
Your option would be
PTREQ_HEADER MOD USER TIME>You can check it, Probably you can enhance RPTARQLIST for the creation date or
use PTARQ > TEST APPLICATION > Personnel Number 1
Role ("Mode") R
You can select and process requests in the list. Display Requests as of 01.07.2015
select as list of requests
Table Name PTARQ_UIA_REQUEST
Table Category Structure Field Name
FIRST_SUBM_DATE Data Element DATUM
Hello Siddharth,
While using the PTARQ > TEST APPLICATION > Personnel Number 1
Role ("Mode") R - SAP Application help says -
Caution
As i will be using this in Production System, could please provide information on above caution eg any particular precautionary measures to be taken before using in Production System.
Also executing the Program - RPTARQLIST, i observed that it captures the data only for the those dates for which report is executed.
i.e if report is executed for June,2015 , then program captures only those leaves which fall in June,2015 month and not those leaves which were applied in June,2015 but are for different month apart from June,2015.
My requirement is to get all leaves that were applied in a particular month irrespective of those leaves are for which months.
Reagrds,
Kunal Pawar.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.