Consider QuickViewer When You Need a New Report

  • by Dr. Stef G.M. Cornelissen, MBA, SAP Business Consultant, Sperry Partners BV
  • January 15, 2007
Find out about a standard tool, QuickViewer, that allows you to create reports without programming.
Key Concept
QuickViewer allows you to define your own data queries based on table joins and logical databases. It is a useful tool when you have to perform a fast, unplanned analysis of non-standard data to solve an urgent issue. QuickViewer requires that you understand which tables you need for an analysis and what values are represented in the table fields.
Recently, I had a conversation with a client that went something like this:

Client: Can you provide me a list of subtotals, in pricing and sales order type, for this list of customers and materials for 2006?

Me: Well, yes and no. It is not a standard report. It involves two different tables: VBAK for the sales order type and VBAP for the pricing procedure details. I can try to combine them in Microsoft Excel or Access, but it will take some time. Could you come back at the end of the week? If you need this type of analysis often, you should enter a change request for a new report. Is there a budget for this analysis?

Client: Hey, this is urgent! Why can’t I create a simple list? Our old system …

Users and consultants often run into this issue — you always need the report that the ABAP programmers did not build. After go-live, you would like to have a list that is not available with existing reports. The ABAP programmer has left and you are faced with the uphill struggle of having a change request approved. This occurs more frequently if your R/3 or mySAP ERP Central Component (ECC) system includes custom tables that are outside normal reporting.

Many of us have wished for an uncomplicated method that allows us to perform this analysis. With R/3 Release 4.6, SAP has complied. A functionality called QuickViewer lets you define reports without programming or a long course in Report Painter. It hides in the System>Services menu path. I discovered it by accident. After you understand the various data sources involved, you’ll find that this is a good tool to know. Of course it is not a solution to all problems. The tables and reports you create are straightforward with SAP List Viewer (ALV) functionality. You cannot add additional logic as you could if you specified a report for ABAP programming.

I’ll show you the basics of QuickViewer in three steps, using an example of logical database VAV, which combines the main sales order-related tables in the Sales and Distribution (SD) module. Then I’ll give you a tip about using QuickViewer to join information from two different tables — no customizing required.

Dr. Stef G.M. Cornelissen

Dr. Stef G.M. Cornelissen, MBA, is an experienced international SAP business consultant from the Netherlands with certifications in FI, CO, and SD. He took part in important international projects involving the large Dutch multinationals. Before specializing in SAP, he worked as a management consultant and was a senior advisor to the Board of Directors of the University of Nijmegen. Stef's academic background is in business administration, economics, and organizational science. He is the owner of Bowstring BV and principal partner at Sperry Associates.

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.