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”

      1_Actuals Period_Year.jpg
      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

     

                 2_Plan Period_Year.jpg

                  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”

                  3_Actuals_LY Period_Year.jpg

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:

4_Report View.jpg

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.

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply