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,

What is the difference between "Positive time recording" and "Negative time recording"

SAP Time Management
What is the difference between positive and negative time recording?

It is common for employees to record their working time periodically.

Consider regular salaried employees, who are supposed to work regularly 8 hours, and it is a common practice among employees to work 8 hours every day. In this case it is better only to record deviation to the work schedule. If there is no deviation to the work schedule, no time sheet will be entered.

Consider another scenario, where it is common for employees to work unspecified number of extra hours, or common to work less than regular hours. In these cases it is better to enter working hours daily so that there is minimum rework at the end of the period.



Let us consider few simple examples:

Scenario 1:
As per Employee's work schedule she is supposed to work 8 hours every day.
Employee works only 8 hours every day.

Positive Time recording --> Enter 8 hours for every day in the time sheet.
Negative time recording --> Do not enter anything in the time sheet.

Scenario 2:
As per Employee's work schedule she is supposed to work 8 hours every day.
On Monday he works 8 hours
On Tuesday he works 5 hours. ( 3 hours of leave )
On Wednesday he works 10 hours ( 2 hours of Over time )
On Thursday he works 12 hours ( 4 hours of Over time )
On Friday he works 2 hours ( 6 hours of leave)

Positive Time recording -->
Monday - Enter 8 hours of regular work.
Tuesday - Enter 5 hours of regular work.
Wednesday - Enter 8 hours of regular work and 2 hours of OT
Thursday - Enter 8 hours of regular work and 4 hours of OT
Friday - Enter 2 hours of regular hours.

Negative time recording -->
Monday - No time sheet entry
Tuesday - Enter 3 hours of absence.
Wednesday - Enter 2 hours of OT.
Thursday - Enter 4 hours of OT.
Friday - Enter 6 hours of absence.

Hope it is clear now. If you have any questions leave a comment.