Skip to Content
Author's profile photo Trong Minh (Woody) Nguyen

Integrating Negative Time and Payroll

I.Relationship

Normally any employee’s time data (esp Absence or Attendance) is processed in Time Evaluation. After accomplishing, Time Evaluation will automatically send these results into Payroll. Payroll driver will use these time information to compute employee’s salary. It’s standard SAP process. However, if using Negative Time Management and don’t have Time Evaluation (Time Schema), how can system calculate employee’s salary whenever employee raised leave request ( the absence can be Paid or Unpaid)? In Payroll schema, SAP support this case and it’s also standard SAP process

It’s be done by configuration. In SAP system, all absent list are stored and carefully specify which kind of absence is Paid or which one is Unpaid. Whenever employee raise a absence request, it’ll automatically impact information in Payroll schema.

II.Configuration

As I am using standard Payroll Schema (X000 – International Personnel Calc. Schema for RPCALCX0 (International)), so I go directly configuration and will explain how is run. I don’t create new requirement by myself as usual. If you are clear these configuration, you can build a new one by yourself and fit your customer’s expectation. Now let’s start with steps below:

1. I have some Absence Types and configure Payment Data as below:

Using T-code SM30 / SM31 with Table View V_554S_G ( actually the table view is all contained in T554S, but I would like to specific one, so I just input *554S* and find many views, after that choosing Absence: Payment Data).

Absence or Attendance.png

2. What’s the meaning of 01, 02 assigned to my Absence Types? ( only 2 Absence Type 1000 – Paid Leave & 1040 Leave Without pay will be used in the document).

Go to view V_T554C and input corresponding country grouping:

Country - Paid Unpaid.png

01 means Paid Leave, 02 otherwise is Unpaid Leave. So when employee raises Absence Type 1000, he has full salary, but Leave Without pay his salary will be deducted.

Now double click for every line, you can see the core configuration here:

with 01 – Paid Leave

Paid.png

with 02 – Unpaid Leave

Unpaid.png

Before going to testing, I will explain to you how SAP process it in Payroll Schema. If you have look at Relationship Time Evaluation and Payroll and understand, so don’t need to re-read this part again In Payroll Schema X000, sub-schema XAL9 will processing /801 in PCR XPPF, more detail it’s PCR

XPP1. Please look at picture below, I copied when running payroll with display log mode:

PCR.png

Their meaning are: (it’s SAP standard, you can find them by pressing F1 key or T-Code PDSY).

TSSOLL: Planned working time measured in working hours

TSAUxx : Unpaid absence measured in working hours => TSAU** (all kind of Unpaid absences, In my case I can change TSAU11, it’s still correct , because Counting class for absences with 02 – Unpaid Leave above it 11 )

TSDIVI : Total working time measured in working hours.

That’s all steps we need to configure

III.Test

I have 1 employee with working time in Aug-2012 as below: 31 calendar days but only 22 working days (Thu & Fri are day off). So 31 – 9 = 22 working days.

IT7.png

1. Raise 1 Paid Leave in Aug-2012

IT2001-1000.png

Running Payroll in Aug-2012 and his basic salary in IT8 is 1000. And in this period he still gets full salary 1000 displayed in payslip

Payslip - IT2001 - 1000.png

2. Raise 1 Leave Without pay in Aug-2012

IT2001-1040.png

Running Payroll and his employee is deducted:

Payslip - IT2001 - 1040.png

It’s simple standard solution to link directly time data into Payroll schema. With easy or not complicated requirements, step by step configuration above will support you to implement customer’s expectations in SAP system.

Hope it’s useful!

Regards!

Woody

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Madhava Rao Basava
      Madhava Rao Basava

      Hi Woody,

      Thanks for the document. This is very useful. It has brought new insight in to Time Management.

      Thanks,

      Madhav.

      Author's profile photo Former Member
      Former Member

      Really Brilliant Woddy

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      Thanks all!

      Madhave: you will be perfect in Time Management soon 😉 Just investigate and modify PCR and testing much 😉

      Author's profile photo Madhava Rao Basava
      Madhava Rao Basava

      Thanks Woody,

      Your documents are really useful for understanding schema & PCRs.

      I request you to kindly write more blogs and articles on Time & Payroll Schema & PCRs.

      I'm a regular follower of your posts. They are really informative and well explained.

      Thanks,

      Madhav.

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      Thanks Madhav! Hope you can control schema and pcr soon 😉

      Yes I will arrange time to publicize more documents 🙂

      Regards!

      Woody

      Author's profile photo Vijay Singh Siwach
      Vijay Singh Siwach

      Good Job Done Woody.

      Nice Blog.

      Regards,

      Vijay Siwach

      Author's profile photo Kavali V Leelamohanrao
      Kavali V Leelamohanrao

      Dear Woody Nguyen,

      Good document you shared keep on rocking.....!

      Ur's

      Mohan

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      Hi Vijay and Leelamohan,

      Thanks for your comments.

      Regards,

      Woody

      Author's profile photo Arka Sengupta
      Arka Sengupta

      Hi Woody,

      I did everything you mentioned above but now nothing is coming in my salary slip. 🙁

      Pls help....

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      You did some wrong or not fully configuration correctly. Don't say did EVERYTHING, as for sure you are missing some things. And a lot of info I didn't mentioned there, because the part must be clear first before controlling Payroll 😀

      Maybe employee's work schedule has problem, or you have no idea about payroll schema structure & how to modify pcr. Or you are not familiar with payslip configuration.

      Check carefully every step in configuration, you can find where you are missing soon.

      Regards,

      Woody

      Author's profile photo Sriram Tamil
      Sriram Tamil

      Hi Woody,

      Awesome one. really you showed a gateway in payroll. But my kind request,since you are master in payroll. would share more documents from the basic. taking standard schema and explaining the IT0008, 14, 15 , calculation how it gets processed etc?. you have showed us very good path in time. excepting the same in Payroll too.

      thanks

      Sri

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      Hi Sri,

      Done already Sir I've mentioned in another documents Useful documents for Schema & PCR configuration part PY.

      Of course some parts are very simple so it wastes time and is not necessary to document, as they are very simple. Just open schema and pressing F1 key or T-code PDSY, SAP provided all vital documents already or inside some SAP books. Alternative option, you can look for in SCN, some basic questions and had been answered already.

      1st understand payroll schema structure, clear some key functions PIT, ACTION, IF, ect. Operations and PCR. You will control it soon.

      Regards,

      Woody

      Author's profile photo Sriram Tamil
      Sriram Tamil

      Hi Woody,

      thanks for your input. sure i will do more R&D on this ,  and please continue sharing the blogs which are really awesome and helpful for us.

      Kudos

      Regards,

      Sri

      Author's profile photo Former Member
      Former Member

      Hi Woody,

      Great blog! Very informative and helpful. Really helped me better understand the schema and positive negative time.

      I am quite new to SAP HCM, hope you wouldn't mind I am asking a silly question.

      Each month has different number of working days, 23, 22, 21, 20, 19 depend on if there are public holidays. So when employee take unpaid leaves, depend on the month, they will receive slightly different pays. See examples below. So even though employee  take 2 days LWOP in Feb and another 2 days LWOP in Mar, he/she will receive different amounts.

      Would most company accept this differences and are able to explain to employees why their pay is slightly different?

      We had a manager wanting the LWOP unpaid salary to be exactly the same x number of days unpaid for every month.

      Many thanks

      Vera

      Days
        worked
      Work Days LWOP Salary Pay
      22 23 1 1000 956.5217
      21 22 1 1000 954.5455
      20 21 1 1000 952.381
      19 20 1 1000 950
      Days worked Work Days LWOP Salary Pay
      21 23 2 1000 913.0435
      20 22 2 1000 909.0909
      19 21 2 1000 904.7619
      18 20 2 1000 900
      Days worked Work Days LWOP Salary Pay
      20 23 3 1000 869.5652
      19 22 3 1000 863.6364
      18 21 3 1000 857.1429
      17 20 3 1000 850
      Days worked Work Days LWOP Salary Pay
      1 23 22 1000 43.47826
      1 22 21 1000 45.45455
      1 21 20 1000 47.61905
      1 20 19 1000 50

      Author's profile photo Trong Minh (Woody) Nguyen
      Trong Minh (Woody) Nguyen
      Blog Post Author

      Hi Vera,

      You request is quite simply to be done in SAP.

      1. configure your basic salary is not deducted by Absences.

      2. Create new wage type to record Absence Deduction = Basic (e.g.) x number days of absence / constant.

      The constant will be same for every month => so the deduction will be same if you one leave 2 days on Feb or Mar.

      The requirement is very common: ee gets salary basing on total working day a month, if working days is not the same => rate for each day is not same.

      All my customers (around 10 companies) share the same policy 😀

      Hope you can control it soon.

      Best Regards,

      Woody

      Author's profile photo Former Member
      Former Member

      Hi Woody,

      Thank you.

      1. configure your basic salary is not deducted by Absences.

      I am referring to unpaid leave only (LWOP - Leave without pay). No issues with paid leave. Unpaid leave needs to be deducted from salary

      We use ave monthly hours as the constant which is 164.67 hours per month. for partial month unpaid leave, a constant would work.

      Problem is where here is a longer month, for example 172 hours actual/164.67 = employee took a full month unpaid leave, he/she would have a negative salary, a claim will be created.

      For a shorter month, for example 152 hours, employee took full month unpaid leave, because 152 is less than the constant 164.67, employee will be paid for salary even tho he did not work.

      It is unpaid leave that we are having issues with.

      Would you be able to shed some light? Thanks again.

      Author's profile photo Former Member
      Former Member

      Thanks Woody for sharing