SAP TM - Leave related tables and reports

Tables:
PTREQ_HEADER:
Every Leave request will have a 32 character document ID. This will have one entry for every document status and also have a time stamp for each of those entry. This has a 32 character field called "ID of the item list" which will link this table to the next table PTREQ_ITEMS.


PTREQ_ITEMS:
Every leave will have one or more items. Items ar enothing but leave operaitons.
Example: If it is a new leave, it will have one item for 'INS' (inserting) a new leave.
If it is a deletion leave, there iwll be one item for 'DEL' (deletion) of a leave.
If it is for changing an existing leave, then there will be two items. One for DEL of old leave, another for INS with changed leave values.


PTREQ_ATTABSDATA:
Every item in PTREQ_ITEMS will have one entry in PTREQ_ATTABSDATA giving details of pernr, leave date, type, operation (INS or DEL) etc. The link between these tables is again through a 32 character field ITEM_INS.

Reports:
Leave Request "Home page": Tcode: PTARQ or use the report RPTARQ

Above "Home Page" provides many reports and tools to work with Leaves. They are listed below.
1. RPTARQDBVIEW: This report allows you to see all leaves applied by a user. You can even use the work item id (top) to fetch a leave request.
2. RPTARQPOST: Post Leave requests to Infotype 2001
3. RPTARQDBDEL: Delete a leave request. This should be used carefully in Production. This has a 'Test Run' option. This report in Test Run option can be used to view leave requests instead of RPTARQDBVIEW, which is much slower.
4. RPTARQUIATEST: This is not released for customers. (That means SAP will not support any problems you face). But a very useful report which can be used to create new leaves, approve/reject existing leaves,