SAP Query Drill Down Report

[Former Member]

Is Drill Down report possible in SAP QUERY?

[Former Member]

Hi Matthew,

Yes Drill down in SAP query is possible but to a very limited extent.

You can give hotspots on few columns and if the user clicks on the values say for example a sales order number or a purchase order number it can forward navigate to the respective screens like VA03 or ME23N and have couple of more functionalities.

Cheers

VJ

[former_member184569]

Driil down Reports

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:

1. Another SAP Query

2. A transaction code

3. 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.

You could also link a transaction code into the first query such as PA20 (display master data) and display all the details of the employee in question by double-clicking on the employee number. You can even link an ABAP program to run that program for your employee when you double-click on the employee’s personnel number.

Regards,

Susmitha

[Former Member]

HI

GOOD

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

GO THROUGH THIS LINK

http://www.sappoint.com/abap/ab4query.pdf

THANKS

MRUTYUN

[Former Member]

Is there a more detail instructions on how creating Drill Down Report? Or any books that you would suggest on Sap Query and sap query drill down report.