Early or Late coming and generation OT by T555Z
I. Purpose
In order to deeply understand Time Schema, this document will guide you how to check early/ late coming and generate Overtime by configuration in T555Z.
II. Solution
1. Checking early/ late coming
First, you have to get Start Working Time in Planned Working Time (IF0007) of employee. Creating PCR ZSWT
HRS=SNTB Start of normal working hours => Time type 9000 will hold this value – Start Working Time of employee.
After having start working time, comparing it with first check in (clock in) as in PCR ZE/L
HRS=PBEG it’s the first check in.
HRS-D9000 minus first check in with start working time holded in Time Type 9000
HRS?0 comparing with 0.
Who comes early, Time Type 9002 (Early coming) will be updated.
Otherwise, Time Type 9003 (Late coming) will be updated.
Now merging 2 new PCRs into Time Schema ZM00 (it’s copied from standard Time Schema TM00).
2. Generation Overtime
In the Time Type Determination view (V_T555Z), you define which time types and processing types the
TIP entries are assigned, based on the time identifier and the pair type:
Pair type 0: Unrecorded times
Pair type 1: Attendances from time postings and planned pairs
Pair type 2: Absences (infotype 2001)
Pair type 3: Attendances (infotype 2002) and off-site work postings
Calculation Overtime bases on Clock in / out, so you have to configure with Pair type 1
In order to understand, look at processing in Time Schema with Function TIMTP (Assign time type to time pair)
Inputting:
Planned Working Time: 09:00 – 17:00 (Break from 13:00 – 14:00)
Time Events: clock in on 08:00 and clock out on 19:00
After processing with TIMTP (basing configuration on T555Z), results are:
How it processes? because the meaning of all ID in T555Z (from 01 to 09)
01 = Overtime, unapproved (outside of planned working time)
02 = Fill time (during planned working time, without core times)
03 = Core time
04 = Core time break
05 = Fill time break
06 = Paid break
07 = Unpaid overtime break (infotype 2005)
08 = Paid overtime break (infotype 2005)
09 = Overtime break
=> from 08:00 to 09:00 (before start working time, ID’s 01), 1 hour Overtime will be assigned into Time Type 0310
=> from 09:00 to 13:00 (working time, ID’s 02), from 14:00 to 17:30 (working time, ID’s 02), insert into Time Type 0110
=> from 13:00 to 14:00 (break time, ID’s 05), Time Type 0510 will be updated.
=> from 17:30 to 19:00 (after end working time, ID’s 01), 1.5 hours Overtime for Time Type 0310.
III. Testing
One employee has working time from 01st-Jan-13 to 06th-Jan-13 as below (note 01-Jan-13 is Holiday)
Actual working time:
These are reports after running Time Schema.
Report for early/ late coming (01 Jan is Holiday and 06 Jan is Sun, not calculate on these days)
Employee came Early on 02-Jan and 05-Jan and Late on 03-Jan and 04-Jan. It’s exactly.
Report for Overtime:
Overtime on 01 Jan and 06-Jan are full days as 2 days are Holiday and Sunday – no working time. Overtime on 02-Jan and 05-Jan are correctly as well.
Hope you have more knowledge and tobe clear time schema and configuration in T555Z
Hi Woody,
Nice work, and clearly expressed. Keep it up.
Thanks Srikanth 🙂 Sure 😀
very nicely explained 🙂 good job dear
Thanks Dilip 🙂
Hi woody nice explanation !!
Thks Vib!
Hi Woody,
Good work...!!! 🙂
Hi Woody It is very informative and helpful to us and your presentation is excellent.
It is very clear.
keep posting.
Thanks
Thanks Swapnil & Chinna ( welcome new friend from China 😀 ) 🙂 Sure, I will do it when I have done my huge current target and have free time 🙂
Regards!
Woody
You are too good Woody..kudos to your articles...
Regards
Pramod
Thanks Pramod, hope you can get a lot of value from the document.
Regards!
Woody
Good Work...
Good explanation Woody Nguyen
Thanks
Satish
Thanks Srikanth & Satish for your comments 🙂
Hi Woody,
Pls tell me how to capture overtime if I am using negative time management.
Thanks and regards,
Arka
Hi Arka,
Of course with - time, you have to input OT manually 😀 no choice.
You can input into IT2010 (number or amount) or input number in IT2002 (attendance), after that control by Schema.
ps: you can use CATS.
Regards.
Woody
Hi Woody,
if in my organization i have both positive and Negative then how do i do the Over time?
Hi woody,
I am new to sap and not very through with time management.Can you old help me how to do this by schema?
Thanks in advance.
Hi Arka,
The document has mentioned by modifying pcr and schema already right?
Now merging 2 new PCRs into Time Schema ZM00 (it's copied from standard Time Schema TM00).
In scn and my blog, there are a lot of documents to create pcr and modify schema, try your best to understand it.
Hi Srikath,
You can check who is under positive or negative in schema.
For positive, my document is an idea for you to calculate OT. Only run the part above if employee is under positive.
For negative time, must manually calculate and input into IT2010 or if you want you can you IT2002. Or CATS is an option for you to manually input data.
Regards,
Woody
1. Hi Woody, I have requirement as describe below.
The requirement is to have leave deductions against shortfall hours on quarterly basis.
Employee leave deduction on short fall of working hours.
Shortfall Hours in the Quarter (X) = Total Planned Hours (In a Quarter) - Total Hours Clocked (In a Quarter)
Conditions
1. Sequence for leave deduction is.
First it should consider CL once CL quota is done the PL quota to be used. If now Absence quota Available the it should consider LWP
2. Leave deduction for short fall hours is half day only
if it’s 9 hours then it should be ½ day leave 4hr45min and another ½ days for next 4hr 45min
3. All leave deduction against short fall of hours should be reflect in Absence info type.
4. 1 hour grace period is given in each Quarter.
Following Absence and Attendance type are consider while calculating logic
1. All Paid and unpaid leaves
2. OD
3. Weekly offs
4. Public holiday
5. Training Attendances
6. On travel.(Out of City)
Can you please guide how we can control this through PCR and configuration.
Could you please let me know step by step process ? I can only see PCR but not schema
If i want to place PCR where I need to place in schema Please elucidate
I dont see time types config
Hi Priya,
Please read the document thoroughly again as I mentioned and capture screenshot from schema as well. Thanks.
Now merging 2 new PCRs into Time Schema ZM00 (it's copied from standard Time Schema TM00).
Best Regards,
Woody
Hi Sir,
I am new for Sap Hcm can you Give the
Pcrs  ZWKD ,ZW10 , ZHLD ,ZI/C  explained in above  Schema  TM00.
Thank you
Hi Sohan,
I have explained above actually.
You have to read more document by presing F1 key in pcr or read from PDSY, so you have a background.
It's not really easy to understand if you don't have the base knowledge. But you can build it via reading SAP document and 1st important running Time shema in log mode and see how it works.
Good luck.
These 4 PCRs are Custom PCRs (they all begin with a Z)
ZW10 is called by Function RTIP, so it will Read table TIP and process it's content.
ZI/O, ZWKD and ZHLD are all called by Function IF, so they contain a Decision Operation and depending on it's return value will either proceed (if TRUE) or skip (if FALSE). For example, ZHKD is checking if "Today" is a Working Day.
Use program RPDASC00 to expand your current Payroll Schema and all it's Rules, and search for other PCRs that are called by these Functions, and study them.