Skip to Content
author's profile photo Former Member
Former Member

Table for Leave request

Hi,

When Leave is ceated in ESS, after approval it shows in IT2001 but while in process i.e. before approval in which table leave gets saved.

How to find out the leave in process? In which table Data gets captured? or what is Tranaction code?

Please guide.

Thanks,

Abhay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2008 at 09:24 AM

    Hi,

    Check tables PTREQ*

    A useful transaction for leave request displaying&handling is PTARQ.

    Regards,

    Karri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2008 at 12:31 PM

    Hi ,

    You can find everything in transaction PTARQ.

    The main tables for PTARQ are :

    PTREQ_HEADER :Request Header

    PTREQ_items : Request Items

    PTREQ_attabsdata : Request Data for Attendances/Absences

    Check following query.

    You will find the exact relation ship between these three tables :

    select SINGLE item_list_id into w_item_list_id

    from ptreq_header

    where request_id = request_id

    AND VERSION_NO = ( SELECT MAX( VERSION_NO ) FROM ptreq_h

    where request_id = request_ID and status = 'SENT').

    select single ITEM_INS

    from ptreq_items

    into w_item_ins

    where ITEM_LIST_ID = w_item_list_id.

    select single *

    from ptreq_attabsdata

    into wa_ptreq_attabsdata

    where ITEM_ID = w_item_ins.

    STARTDATE = wa_ptreq_attabsdata-begda.

    ENDDATE = wa_ptreq_attabsdata-endda.

    CUSTOMERFIELD1 = wa_ptreq_attabsdata-CUSTOMER01.

    CUSTOMERFIELD2 = wa_ptreq_attabsdata-CUSTOMER02.

    Regards,

    Kalpesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.