Create Drill-Down Reports Without ABAP Using Query Report Assignment Functionality

  • by Greg Newman, HCM Consultant, Newhit Ltd.
  • December 15, 2005
Link your query results with transaction codes and other SAP Queries to allow users to drill down into the results for more information.
Key Concept

The report assignment functionality allows you to nest reports and transactions inside each other. You can use this technique to create user-friendly drill-down queries that run further reports or execute transactions based on the output of an initial query.

You can configure an existing SAP Query to create drill-down reports that generate new information by double-clicking on the result. SAP Query allows you to link your query results into the following functions:

  • Another SAP Query
  • A transaction code
  • An ABAP program

For example, you have an SAP Query that lists all the new employees in a set period and you have another SAP Query that shows all the payments and deductions assigned to an employee. You can nest the second report in the first one so that when you run a new employee’s report, you simply double-click on one of the employees. The system runs the second query automatically for the employee you selected and displays the results for this employee. When you have finished viewing the data, you return to the results of your first query.

Greg Newman

Greg Newman is originally from New Zealand, and has been implementing and supporting HR and Payroll systems since 1999. He has worked on numerous SAP HR and Payroll implementations for Great Britain, the Republic of Ireland, Australia, New Zealand, and several other international rollouts. Currently Greg is a managing consultant working for Newhit HR and Payroll Solutions in England.

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.