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.
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.
Would you like to see this full item?