Business Case:
At the moment SAP provides three standard reports for
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:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
8 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |