Skip to Content

ESS leave request status table

May 03 at 11:42 AM


avatar image
Former Member


to my understanding leave requests are stored in a table in ECC, where the different status' are managed (sent, approved, withdrawn etc.)

I would like to know this table.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
mounika annam May 04 at 07:11 AM


Go to transaction SE11 give the database table name as PTARQ* there you can find the related tables

PTARQ_ATTS_INFO : Leave request attendance data.

PTARQ_DEDUCTION: Deduction data of attendaces and absences.

PTARQ_DIR: interface table

PTARQ_EXTRA_INFO: leave request additional information.

To check status of the leave request go to SE11 then table PTREQ* and the following database tables will appear

PTREQ_ACTOR : Request Participant

PTREQ_APPROVER : Approvers for leave request

PTREQ_ATTABSDATA :Request data for Attendance/Absences


PTREQ_BATCH :Time stamp for run of back ground jobs

PTREQ_CKEY_MAP : Cache Assignment Table

PTREQ_HEADER : Request Header

PTREQ_ITEM_TYPES :Request Item Types

PTREQ_ITEMS :Request items

PTREQ_NOTICE : Note for Request

PTREQ_STATUS_CHK : Check methods for status Transitions

PTREQ_STATUS_TRA : Status Transfers

PTREQ_TYPE : Request Types

PTREQ_XFEREVENTS : Permitted Status Transitions

PTREQ_XFEREVNT_T : Texts for Status Transitions

These are all the tables that stores the data of leave request status approves,rejected,sent .

hope it will be useful for you.Any queries let me know

Kind regards

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Mounica, that was helpful.