Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
henriette_beha
Explorer

Business Case:

At the moment SAP provides three standard reports for

  • an Actual/Plan comparison for different periods (Current period, year to period, Year to date) --> Report: “Financial Statements - Plan/Actual”
  • a Two Year comparison, comparing actual values and the corresponding last year’s values -->Report: “Financial Statements - Two Years”
  • and a version Comparison, comparing Actuals with different Plan Versions --> Report: “Financial Statements - Plan/Actual - Version Comparison”

If you want the information of the three above mentioned reports in only one report view you can do this by creating restricted Key Figures with Restriction Typ “Variable”.

I would like to show you how you can create such an Integrated Financial Reporting:

  1. Create new report based on Data Source “Financial Statement”
  2. Create the following Key Figures:
    1. Actuals Period/Year (= Actuals for a specific month)
      Restricted Key Figure based on Key Figure “Amount Company Currency”


      Remarks:
      For the Characteristic “Accounting Period/Year” the Restriction Type “Variable” is chosen which means that this Variable with the name “Period Actuals Period/Year” is later on available in the selection area of the report. I specified that in the selection area only the entry of a “Single Value” – in our case a specific month – is allowed and that the entry will be mandatory.

          b.   Plan Period/Year (= Plan Values for a specific month)
                Restricted Key Figure based on Key Figure “Amount Company Currency

     

                

                  Remarks:
                  Additionally to what I described above I specified for the Plan Value that a Plan Version needs to be selected in the selection area of the report.

             c.  Actuals LY Period/Year (= Last year’s Actuals for the corresponding month)
                  Restricted Key Figure based on Key Figure “Amount Company Currency”


                 

You would now create Key Figures for “Year to Period” or “Year to Date” accordingly, changing the Selection Type from ”Single Value” to “Intervall” as you want to see not only one month but a specific timeframe.

As a result you get – I have to admit - a quite sophisticated Selection Screen in your report, but you easily can reduce the complexity for your customer by creating predefined monthly views:

This approach allows you to enhance the report just as you like (e.g. comparing also different Plan Versions, including more specified timeframes and so on). You just have to keep in mind that your Selection Screen “grows” accordingly.

1 Comment