Quick tip, adding drill down functionality to your SAP Query.  Going to keep this Blog straight to the point.   If as a part of your job you create SAP Queries for the business then most likely you have been asked about drilling down into another report or SAP Transaction.

If you haven’t already figured out how to add the drill down functionality this Blog will walk you through the steps.

As I have mentioned in the past, my goal is that any knowledgeable SAP person can successfully use the following information, however this is not a step by step instruction manual and does require a good understanding of SAP and SAP Query.

This Blog deals specifically with adding a standard SAP transaction.  Specifically the old display purchase order transaction ME23.  Important Note:  SAP Enjoy transactions like ME23N (Display Purchase Order) will not work in drill down.

Following the same steps outlined in this Blog you can also add ABAP reports, SAP Queries, BW Queries, ect.

Keep in mind the selection criteria for the transaction you are drilling down to must be included in the line of original report.

As a note, this functionality is not available for Quick Viewer (SQVI).

Steps – Adding Drill Down Functionality to SAP Query.

1. Transaction SQ00 / SQ01 – SAP Query: Start Queries.

Select Query and hit change icon.

2. Transaction SQ00 / SQ01(cont.) – Change Query XXX; Title, Format

• Follow menu path Goto > Report Assignment
• “Assign Reports” pop-up box will appear
• Select Insert Row icon – pop up box will appear

• In “Add ABAP/4 Query” Pop up box select “Other report type” icon. Another pop up box will appear.

• In the “Report Type for the Report…” pop up box select Transaction (TR). Another pop up box will appear.

 

• In “Add transaction” pop up box enter the SAP transaction code, example ME23. Then hit enter.  You will be taken back to the “Assign Reports” pop up box.

Again, keep in mind the selection criteria for the transaction you are drilling down to must be included in the line of original report.

• The description for the transaction will appear in the “Assign Reports” pop up box. Hit save icon.

• Save changes to SAP Query

Once the transaction has been added to the SAP Query run the query and double click on a line in the report to drill down to the SAP transaction.

If you have question on this or any other PortSAP Consulting blog please feel free to contact us at Blog@PortSAP.com.  Or if you are looking for Top Quality SAP Consultants please feel free to contact us.

The author, Ray Hornbrook, has over 18 years of SAP functional and technical experience.  Ray started his career in SAP as a Subject Matter Expert (SME) for a SAP implementation in 1998 and is now a Senior Level SAP Consultant.  Since Ray has worked both sides of SAP, business end-user and IT professional, he is able to communicate effectively with both IT and Business team members.  Having a background as an SAP business end user has helped Ray greatly in his consulting career.  The business background helps him better communicate with the business members of the team.  As well as helping bridge gaps in communication between the IT and Business team members.

To find out more about the Ray Hornbrook please check out his LinkedIn profile by clicking HERE.

End of document – www.portsap.com

Neither PortSAP Consulting nor the author of this Blog is associated with SAP AG or with any of its subsidiary or alliance company. Trademarks used in our website are registered trademarks of respective companies and neither PortSAP Consulting nor the author of this Blog is associated affiliated with these companies.