Table for Leave request

[Former Member]

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

[Former Member]

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

[Former Member]

Dear Kalpesh,

Do you know how to update the status of the table? Any class or method that i can use it?

Thanks

Regards,

Bryan

[Former Member]

Hi,

Check tables PTREQ*

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

Regards,

Karri