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.

/wp-content/uploads/2014/08/1_532817.jpg

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

/wp-content/uploads/2014/08/2_532818.jpg

In transaction GR53 identify the reports assigned to report group 1SIP. The report assigned is 1SIP-001.

/wp-content/uploads/2014/08/3_532819.jpg

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.

/wp-content/uploads/2014/08/4_532826.jpg

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

/wp-content/uploads/2014/08/5_532827.jpg

In next screen, report description can be added.

/wp-content/uploads/2014/08/6_532828.jpg

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

/wp-content/uploads/2014/08/7_532850.jpg

Click on first column to add column for actuals, select Key figure with characteristics option

/wp-content/uploads/2014/08/8_532851.jpg

Select basic key figure as “Cost”  and Value Type – 4  for Actuals

/wp-content/uploads/2014/08/9_532852.jpg

Select Version 0, check and confirm

/wp-content/uploads/2014/08/10_532853.jpg

Provide short, long and medium text for column (Shift+F1)

/wp-content/uploads/2014/08/11_532854.jpg

Click on second column to add column for plan values. Select Key figure with characteristics option

/wp-content/uploads/2014/08/12_532855.jpg

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)

/wp-content/uploads/2014/08/13_532856.jpg

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)

/wp-content/uploads/2014/08/14_532857.jpg/wp-content/uploads/2014/08/15_532858.jpg

Click on fourth column to add column for Relative variance. Enter formula as follows.

/wp-content/uploads/2014/08/16_532859.jpg

Similarly insert new elements for Plan Version 1 as below

/wp-content/uploads/2014/08/17_532860.jpg

Absolute Variance for version 1

/wp-content/uploads/2014/08/18_532865.jpg

Relative variance for version 1

/wp-content/uploads/2014/08/19_532866.jpg

Insert element for Plan Version 2 similar to Plan Version 1 with version as 2 in Element definition

/wp-content/uploads/2014/08/20_532867.jpg

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.

/wp-content/uploads/2014/08/21_532868.jpg

Report selection can be designed as below by selecting Edit > Gen. Data Selection. Save the report once report selection and report columns are designed.

/wp-content/uploads/2014/08/22_532869.jpg

Step 3 – To assign form report to report group

In transaction GR51, create a new report group in Library 1VK

/wp-content/uploads/2014/08/23_532870.jpg

Provide appropriate description

/wp-content/uploads/2014/08/24_532874.jpg

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.

/wp-content/uploads/2014/08/25_532875.jpg

Step 4 – Report execution

Report group can be executed using transaction GR55. A transaction code can also be created and assigned to report.

/wp-content/uploads/2014/08/26_532876.jpg

Report can be executed, by providing cost center group or values also cost element group or values

/wp-content/uploads/2014/08/27_532880.jpg

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.

/wp-content/uploads/2014/08/28_532881.jpg

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

/wp-content/uploads/2014/08/29_532882.jpg

On next screen select the report and execute

/wp-content/uploads/2014/08/30_532883.jpg

File for report is exported to presentation server.

/wp-content/uploads/2014/08/31_532884.jpg

Export report group from development system using transaction GR57. Enter Library and Report Group and provide path to presentation server and execute

/wp-content/uploads/2014/08/32_532885.jpg

On next screen select the report and execute

/wp-content/uploads/2014/08/33_532889.jpg

File for report group is exported to presentation server.

/wp-content/uploads/2014/08/34_532890.jpg

In Production or higher systems, report can be imported using transaction GR38. Provide a path to file on presentation server in selection and execute

/wp-content/uploads/2014/08/35_532891.jpg

Report is imported

/wp-content/uploads/2014/08/36_532892.jpg

Report Group can be imported using transaction GR58. Provide a path to file on presentation server in selection and execute

/wp-content/uploads/2014/08/37_532893.jpg

Report Group is imported

/wp-content/uploads/2014/08/38_532894.jpg

Report and report groups can also be moved to higher systems by creating a transport using transaction GCTR

/wp-content/uploads/2014/08/39_532896.jpg

Limitations –

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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. AMO Mane

    Hello

    nice, I would like add, in some case is very nice to work on text file, for example on translation, it’s very heavy to do it throught transaction GRRT and very simple throught the flat file. I invite you to open it and many information are simple to understand.

    Other point, if into report you need to have some dynamic value for example period. User wants to call report from period 1 to xx. Please work with formula into your variable, it’s simple and it’s a good result.

    Best regards

    Philippe

    (0) 

Leave a Reply