Step-by-Step Instructions for a Successful Payroll Implementation Using an SAP ERP HCM Payroll Comparison Program

  • by Srini Munagavalasa, PMP, Principal Business Integration
  • October 31, 2011
Migrating payroll from your legacy payroll systems into an SAP payroll system is a
highly complex process and is a major factor for ensuring the overall success of an SAP implementation. Follow this step-by-step process to compare your legacy payroll run with your SAP payroll run for the same period. See how to capture your year-to-date results in your new SAP payroll system, and get code snippets that you can use for your implementation.
Key Concept
This payroll comparison program is a set of custom reports that helps you compare your payroll processes. Any SAP ERP HCM payroll implementation requires the development of a program to compare the legacy and SAP payrolls as well as to validate the payroll configuration and HR master data payroll loads such as earnings, deductions, and taxes. The main goal of the payroll comparison program is to provide visibility into your payroll processes; identify issues at the wage type level; aid in fixing master data, data translation, and data mapping; and identify configuration issues. The tool helps you optimize SAP implementation time with proven techniques and step-by-step instructions, and without having to reinvent your payroll comparison strategy.

This custom program I designed and developed is intended to simplify the process of comparing legacy payroll data with data migrated to SAP payroll. It helps identify legacy data issues, identify and fix data mapping and translation rules, identify and fix master data issues, and fix payroll configuration issues. I have used this tool very successfully in many SAP payroll implementations. Without this tool, payroll administrators have to resort to using multiple SAP-provided reports to verify and validate payroll data. That process is complex, cumbersome, confusing, and time consuming. I also provide performance improvement tips to use when loading millions of records into payroll tables.

At the end of this article, I provide code snippets to load your legacy year-to-date (YTD), quarter-to-date (QTD), and payroll period data into standard SAP payroll tables. Unlike SAP’s standard load programs, these load programs can handle high volumes, generate load statistics, and be scheduled to run in the background.

Srini Munagavalasa

Srinivasa (Srini) Munagavalasa has 14 years of experience in various SAP modules. Srini has worked on multiple SAP global implementations at major clients. He has experience as a project manager, deployment lead, build manager, and technical development manager.

See more by this author


4/22/2013 6:38:44 AM
Somdeb Banerjee

Hi Srini,

This is a wonderful article.

Thank you for sharing your valuable experiences.


Please log in to post a comment.

To learn more about subscription access to premium content, click here.