cancel
Showing results for 
Search instead for 
Did you mean: 

Tables storing leave request data before approval and after approval.

Former Member
0 Kudos

Hi All,

I am working on enterprise service for leave request creation/deletion. I want to know as to which tables store the data for leave request for leave request before approval and after approval in SAP.

There are two scenarios:

1. Deleting leave request before it is approved by approver.

2. Deleting leave request after it is approved by approver.

Thanks,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

There are 3 important tables which stores leave request details.

1. PTREQ_HEADER

2. PTREQ_ITEMS

3. PTREQ_ATTABSDATA

Regards,

Jyothi

Former Member
0 Kudos

Hi Jyothi,

I am using standard enterprise service to create a leave record and also to delete leave record(before approval and after approval are two possible scenarios). The standard enterprise service internally checks if record exists in table PTARQ_DIR at the time of deleting the record. I want to know as to when this table gets filled. I have created few leave requests and approved too. But could not see any record in this table. So I would really appreciate your help if you can help me to understand importance of this table and tables that start with PTARQ_.

Thanks,

Former Member
0 Kudos

Hi,

I am not able to see any table called PTARQ_DIR. Can you please explain how you are applying leave.

Regards,

Jyothi

Former Member
0 Kudos

Dear Ameet,

It will store in PTREQ_* tables as given by jyothi, check in se16 once updated leave in these tables.

PTARQ is for configuration & for checking workflow in one trans.

Former Member
0 Kudos

Hi Jyoti,

I am using standard enterprise service EmployeeLeaveRequestCreateRequestConfirmation_In to create and delete leave request. This enterprise service internally has a code which checks entries in table PTARQ_DIR and if entry is not found then throws an error. While creation of leave record, it does not check this table. Thus there is no problem in creating a leave record, but only while deleting it is not allowing.

Thanks,

Former Member
0 Kudos

Hi Kedar,

I am using standard enterprise service EmployeeLeaveRequestCreateRequestConfirmation_In to create and delete leave request. This enterprise service internally has a code which checks entries in table PTARQ_DIR and if entry is not found then throws an error. While creation of leave record, it does not check this table. Thus there is no problem in creating a leave record, but only while deleting it is not allowing.

Thanks,

Former Member
0 Kudos

Hi Ameet,

There in no table called PTARQ_DIR. If it exists, please share the screenshot of the table along with the entries.

Regards,

Jyothi

former_member184702
Active Contributor
0 Kudos

Hi Ameet,

If you are using CATS processing , Please check the table CATSDB or CATS_APPR_LITE transaction code , check the processing status 10,20,30,40,50, and 60.

Thanks

Siva