Skip to Content
Author's profile photo Former Member

How to Cure SAP Work Schedulitis

I think we have all suffered from SAP work schedulitis? You know the symptoms. You started off with a reasonable number of work schedules in your SAP system but over time they have multiplied so that there are now thousands, possibly even tens of thousands, in your system.

Initially there was probably a logical system to the naming convention but that too has long gone by the wayside meaning that when allocating a work schedule to infotype 0007 a user will struggle to find an existing pattern that matches the requirements. In some cases this leads to a new work schedule being requested that may already exist!

As work schedules are configuration items a new schedule will take time to create and test so will use up valuable resources from your SAP support team.

This had happened to one of our clients and they asked us if we could help.

We developed a series of bespoke tables, input screens and programs that would allow an employee’s line manager to accurately create the working pattern for the employee whilst inbuilt validation would ensure that the new pattern did not differ from the employees contractual hours held on IT0007 Planned Working Time.

This approach allowed the client to reduce the number of work schedules to a minimum and give the responsibility of maintaining accurate work schedules to an employees line manager.

The line manager can also create a rotating schedule of up to 12 weeks if required. The total hours per week can be more or less than the weekly working hours in IT0007 so long as the average DOES equal.

It is also very useful when it comes to part time employees. If two employees both wanted to work 20 hours per week but with different patterns this would require the creation of two separate work schedule rules in SAP. Now the employees can be allocated the standard Full Time Equivalent work schedule rule, change the weekly working hours to 20 and the detail of the 20 hours entered by the line manager.

There is a knock on benefit to this approach as the percentage utilisation value will be transferred to IT0008 and if the employee is allocated to a pay scale with set rates the pro ration will take place automatically.

Below is a screen shot where a manager would create the required shift pattern using start and end times, including any breaks.


Once the pattern has been created, validated and stored in the bespoke tables one of the programs, which is a scheduled job, will process the record and create IT2003 Substitutions records from the start date of the record. The number of IT2003 records created will be based on the end date of the record.  The program will also re-evaluate any IT2001 Absences or IT2002 Attendances records that fall within the date range.

Since being developed for the original client we have provided a similar solution to several other clients in the UK and USA.

If you would like to know more details then I am happy to share.!input.jspa?targetUser=913484

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jagan Gunja
      Jagan Gunja

      Hi Steve,

      This looks to be a good solution.  But still would IT 2003 be not required?

      I know this is a regular problem In many of my clients' installations.  Dynamic scheduling also had its own issues e.g., misuse, too many WS's.  I was wondering that we would run out of the name range.

      The link!input.jspa?targetUser=913484 

      givees me a message that I am unauthorized with message "Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here".

      I'd be interested to know details.

      br, Jagan

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Jagan,

      The link was supposed to take you to view my profile so you can get my email address as I am not allowed to add it to the blog post. Can you please try and find my email address from my profile in SCN. You are supposed to be able to do this.



      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Jagan,

      If you click on my name (highlighted in blue) you can see my email address.

      Thanks for your interest and hope to hear from you soon.


      Author's profile photo Aditya Tegginmath
      Aditya Tegginmath

      Hi Steve ,

      Really Interesting , I would like to know more about it

      I checked your email address but its private couldn't view it .

      Could you please share your email address.

      With Regards


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Aditya,

      I have updated my SCN profile so you should now be able to see my email address if you click on my name.

      Kind regards,


      Author's profile photo Antoine Foucault
      Antoine Foucault

      Cool stuff Steve Williams... nice solution !

      This is an awesome way of giving a solution to customer with a wide range and variety of schedules 😉 .

      Author's profile photo Former Member
      Former Member

      Well done! This is a great solution to implemented.