Many a times due to business requirements user requests for an enhancement in available standard SAP reports. The information about standard reports and process to create a new report using standard report is available at various places on forum in bits and pieces. However one might end up spending a good amount of time in understanding the process, especially inexperienced consultants in CO domain. This document details out the process to enhance the standard CO reports in report painter to meet various business requirements.
The process is explained by considering the standard report 1SIP-001 (Transaction S_ALR_87013611). The standard report displays the actual and plan figures for a cost center area or a cost center along with variance. The limitation of the standard report is that it could display values of only one plan version at a time. As indicated in below screen multiple selections for Plan Version is not available.
A business requirement is to generate a report with values for different Plan Versions. One can always execute standard report multiple times by providing different Plan Version values in selection. This process is not user friendly. It is easier to enhance the standard report to meet the requirement to display values for different plan versions in single execution.
Step 1 – To identify Standard Report for enhancement
Information about Library and Report Group of standard report is available under main menu of report selection (Transaction S_ALR_87013611) > Environment > Technical Information. The library for standard report (Transaction S_ALR_87013611) is 1VK and report group 1SIP
In transaction GR53 identify the reports assigned to report group 1SIP. The report assigned is 1SIP-001.
In transaction GRR3 under Library 1VK identify how standard report is defined. Row model and column values can be identified with double click on respective fields.
Step 2 – To create a custom report based on standard report
To create a custom report based on standard report, in transaction GRR1, provide custom report name and Library and select “Create” button
In next screen, report description can be added.
Click on the row 1 and go to Edit > Rows > Inset row model and Select 1-LM-BEL-ENT Cost element: Deb/Cred as indicated below
Click on first column to add column for actuals, select Key figure with characteristics option
Select basic key figure as “Cost” and Value Type – 4 for Actuals
Select Version 0, check and confirm
Provide short, long and medium text for column (Shift+F1)
Click on second column to add column for plan values. Select Key figure with characteristics option
Select Characteristics “Cost” as follows, Value type as “1” and Version “0” check and confirm and provide short, long and medium text for column (Shift+F1)
Click on third column to add column for Absolute variance. Select formula option and provide formula as below. Provide short, long and medium text for column (Shift+F1)
Click on fourth column to add column for Relative variance. Enter formula as follows.
Similarly insert new elements for Plan Version 1 as below
Absolute Variance for version 1
Relative variance for version 1
Insert element for Plan Version 2 similar to Plan Version 1 with version as 2 in Element definition
Insert element for Absolute Variance2 and Relative Variance2, provide appropriate values in formula similar to Absolute Variance 1 and Relative Variance 1.
For Actal value, Plan value, Absoulte Variance, Relatvie Variance of version 0,1,and 2 report layout will be as follows. Report layout can be modified as per requirement.
Report selection can be designed as below by selecting Edit > Gen. Data Selection. Save the report once report selection and report columns are designed.
Step 3 – To assign form report to report group
In transaction GR51, create a new report group in Library 1VK
Provide appropriate description
Select report tab to assign newly created report to the report group. Under reports newly created report (CCPLAN1) will be available for selection in F4. Save created group.
Step 4 – Report execution
Report group can be executed using transaction GR55. A transaction code can also be created and assigned to report.
Report can be executed, by providing cost center group or values also cost element group or values
Data for all plan versions 0, 1 and 2 is available with single execution. One can add more versions to the report as per requirement.
Step 5 – Transport Report and Report Group
If report is to be created in development environment and then moved to production environment then same can be achieved by standard transaction.
Export report from development system using transaction GR37, Enter Library and report name, Provide path to presentation server and execute
On next screen select the report and execute
File for report is exported to presentation server.
Export report group from development system using transaction GR57. Enter Library and Report Group and provide path to presentation server and execute
On next screen select the report and execute
File for report group is exported to presentation server.
In Production or higher systems, report can be imported using transaction GR38. Provide a path to file on presentation server in selection and execute
Report is imported
Report Group can be imported using transaction GR58. Provide a path to file on presentation server in selection and execute
Report Group is imported
Report and report groups can also be moved to higher systems by creating a transport using transaction GCTR
1) Plan version field is not available as a selection parameter
2) The drilldown option to get actual line items and other details in standard reports is not available in custom report