ESS leave request status table

[Former Member]

Hello,

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.

[former_member543465 · Accepted solution]

Hi,

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_ATTACHMENT : Attachment

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

[Former Member · Accepted solution]

Thank you Mounica, that was helpful.