ESS - Leave request stauts- Sent/Approved

[former_member1318835]

Hello all,

We have customized WF and one level approval for level approval for leave request. Everything is working fine for us except one day we have noticed that for few employees approved leave requests are not posted in backend system from web application. And this is bring disconnect in leave quota been displayed in ESS-Web Application and in back end system .

here are the steps how we have done back track investigation and didn't find any reason:-

1. We checked the date from approval notification in SOST.
2. On found date, checked the workflow log in SWI2_FREQ. WF completed successfully.
3. In report PTARQVIEW. Leave request status approved
4. In table PTREQ_ATTABSDATA , leave request status is approved, not posed ,
5. Batch job which is responsible for leave postings. Unfortunately, we dint have more 15 days batch job logs so we couldn't check batch job logs .

I have following question related to my exercise

1. Is there anything that I have missed to investigate?
2. Is my assumption is correct if I suspect batch job is culprit for the same , as WF completed successfully.
3. In case batch job is specious then why all absence types are specific group of employees.
4. Is there any report and common filed in absence request table (ESS-Web Application ) where I can write SAP query to fetch missing absence request with fields like employee number, applied date , number of hrs, status , to and from date. I already have checked , all these fields are not available in one single table. And, I am not able to write SAP query cause didnot find any common fields among tables to perform join.

Much appreciated your time to look at my query and your valuable response.

thnks

Subrat

[Former Member]

One quite nice transaction is PTARQ and the "Display documents" functionality. You could list all the leave requests that are in status APPROVED (=their current status). This status should basically be quite rare because normally the posting report changes the status POSTED in a short period of time. If you find old leave requests that are in status APPROVED, then you know that something is wrong.

Regards,

Karri

[former_member1318835]

Hello Keri,

thx for your reply.

Regarding to PTARQ "Display documents" which can fetch records based on status (approved,Sent, posted). however this report doesnt give me time data like , absence date, hrs etc etc.

My concern is when approved records are not posted , we have post it manually and as this report does't give us full data we are unble to post leave reqeust munually in backend system.

thks

subrat

[Former Member]

Please let me know, if you can find that kind of user friendly report for leave requests (I would need it too). From PTARQ you can see the leave data if you double-click the leave request "header data" rows that are listed.

You can basically query the tables PTREQ_HEADER => PTREQ_ITEM => PTREQ_ATTABSDATA. So if you know the leave request ID, then you can find the leave data from PTREQ_ATTABSDATA (through the table PTREQ_ITEM). But this all gets a bit complicated because you can also have deletion requests, and leave change requests (=you will have two rows in PTREQ_ATTABSDATA). The user who posts the leaves to IT2001 should know what he is doing.

Regards,

Karri

[former_member1318835]

Hey Karri,

There you go, come to main point.

Now can you please tell me any common field name among this table so that I can perform SAP query and pull out the desired list.

thnks

Subrat

[Former Member]

I think you should be able to do this by yourself. It is not that difficult. The relationships are formed with the long IDs of each table (the field names do not have to be same). I cannot remember the details but I think there was some kind of item ID in the header table? If yes, then you can do a select to the item table with this key, etc. Then there is some kind of ID in the item table, and with that you can find the stuff from the ATTABS-table.

Regards,

Karri

[Former Member]

The leave requests gets posted to infotype with scheduled report RPTARQPOST. Run this report and most likely you will see errors in the log.

Regards,

Karri

EDIT: Or actually perhaps you won't find an error, if the leave request status really still is APPROVED. But at least the report should be the first place to start looking for.