Skip to Content
Author's profile photo Tammy Powlas

How your ABAP List Viewer can be a source for Crystal Reports

How would like to go from an ABAP List Viewer (ALV) report to a Crystal Report?

/wp-content/uploads/2012/03/3fig_80775.jpg

Figure 1

Figure 1 shows an ALV report and the same data displayed on the right as a Crystal Report inside your ECC system.  You can do it, as long as you are on Enhancement Package 5 (ECC 6.0) with some configuration and downloading a viewer.

Configuration:

Go to transaction SPRO:

IMG > SAP NetWeaver > Application Server > SAP List Viewer > Maintain SAP GUI Specific Settings

/wp-content/uploads/2012/03/4fig_80776.jpg

Figure 2

In Figure 2, select checkbox to Allow Crystal Reports and then SAVE.

Download the Crystal Viewer mentioned in SAP Note 1353044 to your desktop and install.  You need to be on SAPGui 7.1 or higher.

/wp-content/uploads/2012/03/5fig_80807.jpg

Figure 3

Then, run your favorite ALV report and select Views -> Crystal Reports as shown in Figure 3.

Your ALV report is now a Data Source to Crystal Reports, inside your ERP system.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Edison Lim
      Edison Lim

      Hello Tammy,

      Thanks for sharing this functionality. I am able to use it after downloading Crystal Viewer.

      What is the value of showing ALV report in Crystal Reports format? So far, it looks like it may print better on physical paper. Are there other functionalities? For example, I don't see an option to include a pie chart like what you showed in the image above. Are there other hidden features or analytics capabilities?

      Thanks and best regards,

      Edi

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Edi,

      Thank you for reading and commenting

      Here is an example on this blog:

      http://scn.sap.com/community/embedded-analytics/blog/2012/06/10/pixel-perfect-financial-statements-inside-sap-erp-yes-with-crystal-reports

      You would need to download the Crystal Report to Crystal Reports 2008/2011 and make the changes (such as the pie chart) and then upload that back to SAP.  We're also using it as Inventory Sheets. 

      I hope this helps.

      Tammy