Skip to Content
avatar image
Former Member

ESS leave request status table


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 04, 2018 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_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

    Add comment
    10|10000 characters needed characters exceeded