SAP CPQ Report Module Overview Part-2: Building a Report

SAP CPQ Report Module Overview Part-2: Building a Report

No comment Share

Author: Mirza Baig

SAP CPQ’s Report Module is a quick and easy reporting tool for every day reporting needs. As discussed in the previous post (SAP CPQ Report Module Part-1), there are 2 parts in CPQ Report Module:

  1. Building the Data Source (also covered previous post)
  2. Building the Report


In this article, we will explain how to build a report. We will go over some key features that help admins generate reports for users.


Building Reports in Report Module

A report can be displayed as a list or a dashboard for more visual reporting. That is defined by the CPQ admin based on business requirements. Another feature that is often used by the end-users is to export the reports to Excel, Word or, PDF files.


Reports can be organized using Labels, which are tags to classify reports such as Quote Item Reports, Customer Reports, and Sales Rep Reports. Labels are not required but it’s a best practice to create and assign them to reports. Over time they help search/sort/identify the type of report easily. Each report can be tagged with multiple Labels. 


Once the Data Source has been created, a report can be generated by the CPQ admins. Creating a report involves using a wizard that guides the user through a sequence of screens where the search criteria fields, rows/columns, and grouping are selected.  


Report module (2) - 1        SAP CPQ Report Module - Specifying report’s selection criteria for the end-users  

Reports can be customized to have Row Groups, Column Groups, and Columns. Row Groups enables grouping of rows together based on a column. It helps group rows with the same key value on a column and will not list out the same values multiple times.


Column Groups allows you to have multiple columns grouped together with a header. The Columns section is where you choose the columns from your data source that you want to display on your report.


Report module (2) - 2SAP CPQ Report Module - Specifying the report’s output row groups, column group, and columns  


Within the wizard, admins are able to provide access rights and visibility to various permission groups.


Report module (2) - 3 SAP CPQ Report Module - Specifying report’s access rights by permissions groups  


Once admins have defined the data source and all the report details discussed above, they can test the report within the Report Module itself.


Report module (2) - 4 SAP CPQ Report Module - testing the report output (admin view) 


End Users Navigating to Reports  

End-users can access the reports using their User Profile menu on the top right corner of the screen. From there, they can select Reports from the menu. They will only see reports belonging to their permission groups.


Report module (2) - 5


Final Thoughts

Once key users, business managers, and department heads identify their reporting needs, CPA admins can suggest reports that can be managed in CPQ. Complex reporting requirements should be managed by enterprise grade reporting analytics such as SAP Analytics Cloud (SAC). 


When creating reports in CPQ, the underlying Data Source must be first defined using database table view or SQL query with joins to other tables. The data source can then be referenced in multiple reports. Businesses can also identify which permissions groups (user, user types, companies, brands, markets) should have access to those reports. 


Learn more about the author, Mirza Baig.