Link SAP Payslips to Your Excel Payroll Reports

  • by Owen McGivney, Senior Consultant, iProCon Ltd.
  • July 14, 2014
When you are viewing SAP payroll reports, they often make more sense when viewed side-by-side with employees’ payslips. This adds context and makes payroll reports much easier to understand. Learn a simple way to link payroll reports to employee payslips with short macros in Excel using Visual Basic for Applications (VBA). No ABAP code is required.
Learning Objectives
Reading this article, you will learn how to:
  • Create a macro that can display payslips in a web browser
  • Create a macro that adds hyperlinks to those payslips
Key Concept
Visual Basic for Applications (VBA) is a programming language that enables you to automate tasks in Microsoft Word, Excel, and other applications. VBA is created behind the scenes whenever you record a macro. The VBA development environment is included in most versions of Excel. 

SAP payroll reports are frequently downloaded to Excel before being distributed as part of HCM and payroll processes. Many payroll reports consist of lists of wage types and amounts, and it can be hard to understand the detail without referring to a payslip or paycheck. The payslip gives a summarized view of the payroll details that is intuitive and easy to understand. Often an immediate, quick look at a payslip gives the payroll context for an employee, so that a more meaningful analysis of a detailed wage type listing is then possible.
  

Prerequisites

The prerequisites for understanding this article are:
  • Familiarity with standard SAP HR and payroll reports and how to download them to Excel
  • Knowledge of basic SAP payroll processes (e.g., producing payslips)
  • Familiarity with Excel is useful but knowledge of VBA is not essential as guidance is given

Owen McGivney

Owen McGivney is a senior consultant at iProCon Ltd., part of the iProCon group, based in London, England. He has worked on implementing SAP HR and payroll systems since 1998. Owen has delivered UK, Irish, and multi-national payroll solutions for a wide range of private- and public-sector clients. He has a special interest in combining ABAP programming with configuration to create innovative and effective solutions.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

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