Use SAP Query Drill-Down Reporting to View HR Master Data Infotype Records

  • by Owen McGivney, Senior Consultant, iProCon Ltd.
  • November 13, 2013
Learn how to create true drill-down functionality with SAP query reporting. Using this work-around you can get master data details from the underlying infotype records of employees.
Learning Objectives

You will learn:

  • How to create drill-down functionality with SAP query reporting.
  • How to get master data details from employee master data infotypes.
  • How to create a utility reporter.
Key Concept
SAP query provides a drill-down functionality that enables the main query to execute one or more other queries, reports, or transaction codes. Using this functionality enables users to create useful multi-functional reports where the output of one report is passed along as the input to the next.

SAP query provides useful functionality that allows reports to be linked. This means that the output from one report can be passed to the following report so that users can drill down into the details. One feature that many users want is to be able to drill down in an SAP query to view the underlying infotype record.

Greg Newman covers the basics of this approach in the SAPexperts article “Create Drill-Down Reports Without ABAP Using Query Report Assignment Functionality.” I recommend reading his article for a useful guide for how to link two (or more) queries, and it also explains how to drill down to other HR transactions.

A subject that Greg Newman covers in his article (mentioned above) is how to drill down from a query to an underlying or related infotype record in display master data (transaction code PA20). While it is possible to add a report assignment to view PA master data via transaction PA20 directly, this doesn't provide true drill-down functionality. This is because users have to enter some data on the view master data screen, such as infotype and subtype. I have seen many questions about how to solve this shortcoming in various blogs and forums, but I have never come across any complete instructions on how to do this. Because how to pass parameters or data between drill-down queries and transactions is not well documented, many SAP ERP HCM users struggle to get the most out of drill-down functionality.

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


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.