Using the SAP Query to Solve Your Reporting Requirements

  • by Tami Becker, SAP Platinum Consultant
  • May 15, 2003
Have you ever asked yourself, "How can I create an easy report with only the fields I want to see on it?" The author suggests you try the SAP Query.

Have you ever asked yourself, "How can I create an easy report with only the fields I want to see on it?" A few examples are a simple customer listing with specific fields, a general ledger account history, or an accounts payable open-invoice report. R/3 delivers reports in these areas, but they are crowded with information and can be difficult to read. SAP Query gives you the ability to create such reports. A lot of people don’t even know that the SAP Query exists. I’ve had clients tell me that R/3 doesn’t have a query tool. In early releases, SAP Query was called ABAP Query. ABAP Query was not a graphical tool like SAP Query, so the creation and execution of queries was less user friendly.

This article is a "get-your-feet-wet" introduction to the SAP Query. I’ll discuss terminology and show you how to create a query. The query will have drill-down capability to the transaction code for changing a document. Drill-down makes navigation from the query to other queries, transactions, or ABAP programs easy, and it is a time saver. You don’t have to open a new session and go to the change document transaction. You just double-click on the document and you’re there.

Tami Becker

Tami has been working with SAP R/3 for about eight years and really enjoys the software and its constant challenges. Her focus has been with reporting, FI, SPL, SAP Enhancements, Euro, DART, Conversions, and now Contract Accounting. There’s never a dull moment with each new release — she hopes you find it as interesting as she does!

See more by this author


Comments

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.