Skip to Content
Product Information
Author's profile photo Christoph Tillmann

What’s new in business content “Integrated Financial Planning with SAP S/4HANA” – Content Innovation 22

Introduction 

In this blog post I want to share details on our latest updates for the SAP Analytics Cloud business content on Integrated Financial Planning with SAP S/4HANA. The content innovation cycle 22 has been released with wave 2021.20 and is available in your SAP Analytics Cloud tenant. Learn how to import business content from Analytics Content Network (ACN). 

When it comes to financial planning with SAP S/4HANA the strategic direction is SAP Analytics Cloud Planning. Take a look at this blog post on how to address fpa challenges with SAP S/4HANA. Integrated Financial Planning with SAP S/4HANA (IFP) serves this strategic direction and provides pre-built business content powered by SAP Analytics Cloud.

The following enhancements have been made to financial planning, which serve the overarching and steady growing concept of xP&A (extended Planning and Analysis). 

  • Landing page – data flow 
  • Cross-model add-on for SAP Integrated Business Planning (SAP IBP) Integration  
  • One-click simulation 
  • Prepare demo data 
  • Iterative activity price calculation 

 

Enhancements

Landing page – data flow

We enhanced our SAC landing page story by the data flow graphic representing the overall business content. It is added directly on the entry page “General” and enables you to have the holistic view on our process integration at hand with one click.

Figure%201%3A%20IFP%20landing%20page%20%u2013%20General

Figure 1: IFP landing page – General

Here you see the highlighted area where to find the data flow information link.

The “Data Flow” link will navigate to the data flow tab within the story. See below figure 2.

Figure%202%3A%20IFP%20Landing%20Page%20%u2013%20Data%20Flow%20information

Figure 2: IFP landing page – data flow information

See immediately how the different planning areas are inter-connected. Click the home icon in the top-right corner to return to the landing page entry screen.

 

Cross-model add-on for SAP IBP Integration (consensus demand plan)

We often get the question how and especially where to integrate SAP IBP (SAP Integrated Business Planning) in the overall financial planning process. With the cross-model add-on for SAP IBP you can now incorporate the result of the consensus demand plan into your financial plan out-of-the-box.

In detail the supply chain planner calculates the quantities for the consensus demand plan. This result can now be transferred to the sales quantity plan in Integrated Financial Planning. During the transfer additional information on profit center (based on plant and product) and company code (based on plant property) for further processing in finance is derived.

Figure%203%3A%20IFP%20data%20flow%20%u2013%20SAP%20IBP%20integration

Figure 3: IFP data flow – SAP IBP integration

Finally, you can also retract the updated profitability plan to your SAP IBP system and continue your S&OP specific analysis.

First you need to import the add-on package from ACN to your SAC tenant. Look for package “Add-on for Integrated Financial Planning for SAP S/4HANA”.

Figure%204%3A%20Add-on%20for%20Integrated%20Financial%20Planning

Figure 4: Add-on for Integrated Financial Planning

The SAP IBP connection, import job and SAP IBP demand plan version is delivered with the main IFP package already. The add-on package includes a story to copy the imported demand plan figures from SAP IBP to IFP sales & profitability model. In this step also the company code and profit center is derived (and can be reviewed in the story as well). The mapping rules can be imported from SAP S/4HANA using the pre-configured import job – also coming with the add-on content package. Check more details in the documentation on how to import.

Figure%205%3A%20Copy%20demand%20quantities%20from%20SAP%20IBP

Figure 5: Copy demand quantities from SAP IBP

To retract data to SAP IBP you need to create an export job, which is described in full detail in our documentation.

 

One-click simulation

The simulation cockpit for financial planning in SAP Analytics Cloud allows stakeholders in management or a central controlling department to perform what-if simulations for sample processes based on changing drivers, such as sales quantity or personnel expenses.

Below figure 6 shows 1 of 3 pre-defined simulation scenarios for sales simulation. The orange icons indicate input for drivers, and the blue marked boxes highlight the related processes affected of the changed drivers.

Figure%206%3A%20Simulation%20cockpit%20%u2013%20data%20flow%20information

Figure 6: Simulation cockpit – data flow information

With the latest release you can now execute a simulation process with just one click once you have done the changes to your input planning drivers. The result is reflected instantly in all related processes (see data flow information). Click the “Trigger all Data Actions for this Simulation” as shown below (figure 7).

Figure%207%3A%20Simulation%20cockpit%20%u2013%20One-click%20simulation%20trigger

Figure 7: Simulation cockpit – One-click simulation trigger

If you still want to perform a controlled simulation path you can of course follow all steps (tabs), execute isolated data actions, check the intermediate result, and move on.

The feature of the one click approach enhances efficiency and trust in the simulation process. Still the flexibility during a simulation process will remain where required for the planner.

 

Prepare demo data

The business content comes with sample data already, but in order to create a consistent data set across all processes we now offer the feature called “Prepare Demo Data”. It is included in the simulation cockpit menu and has 2 options.

Option 1: Create sample reference data

This will create sample reference data such as actuals, budget, cost estimate and plan driver value. Keep in mind that existing data will be cleared upfront to ensure a consistent state!

Option 2: Create consistent sample plan version

This will generate a consistent plan version end-to-end. Keep in mind that this will clear existing plan data!! Hence, use this feature very carefully! J

Have a look at figure 8 where to access the feature in the simulation cockpit.

Figure%208%3A%20Simulation%20cockpit%20%u2013%20Prepare%20demo%20data

Figure 8: Simulation cockpit – Prepare demo data

 

Iterative activity price calculation

If cost centers exchange activities to each other the calculation of an activity price becomes tricky. The problem can be reflected as a linear equation system and solved iteratively with the so-called Jacobi method. Go to your preferred search engine and you’ll find plenty of information around it J.

Within the business content we enhanced the data action and advanced formula to calculate the activity price iteratively. Have a look at the cost center story SAP__FI_BPL_COSTCENTER_ACTIVITYPRICE_CALCULATION and open the designer panel for the data action “Calculate Activity Cost Rates”.

Figure%209%3A%20Calculate%20activity%20cost%20rates%20with%20iteration

Figure 9: Calculate activity cost rates with iteration

As highlighted in figure 9 there is an additional parameter to steer if the activity price calculation should be calculated iteratively. By default this value is set to ‘0’, hence inactive. You can adapt the data action trigger to your needs of the business process to leverage this functionality.

See here a little example with two cost centers that delivery activities to each other to make this more tangible.

Figure%2010%3A%20Activity%20cost%20rates%20with%20iteration%20%u2013%20P1%20and%20P2%3F

Figure 10: Activity cost rates with iteration – P1 and P2?

The red numbers are the activity quantities from the cost centers (C1, C2) to other cost centers (50, 100) or to the outside (350, 125; cost center = unassigned). Prices P1 and P2 need to be calculated.

Linear equation system:

Total Input = Total Output
1000€ + P2 * 100h = P1 * (350h + 50 h)
2000€ + P1 * 50h = P2 * (125h + 100 h)

The solution is for P1 = 5€/h and P2 = 10€/h.

Figure%2011%3A%20Activity%20cost%20rates%20with%20iteration%20%u2013%20result%20for%20P1%20and%20P2

Figure 11: Activity cost rates with iteration – result for P1 and P2

Figure 11: Activity cost rates with iteration – result for P1 and P2

Solved linear equation system:

1000€ + 10€/h * 100h = 5€/h * (350h + 50 h)
2000€ + 5€/h * 50h = 10€/h * (125h + 100 h)

See below how the figures approach the activity price and the delta between each iteration towards 0.

Figure%2012%3A%20Activity%20cost%20rates%20with%20iteration%20%u2013%20approximation%20example

Figure 12: Activity cost rates with iteration – approximation example

We start with iteration 1 and ignore the internal relation of C1 and C2, but only calculate the price as if it would be delivered “externally” only. With iteration 2 we can now consider the activities between C1 and C2 as there is a price calculated from iteration 1. This process is being repeated until the delta between iteration n and iteration n-1 is below 0.001. The threshold is defined in the advanced formula and can be adjusted if needed as well.

 

Outlook

These are the enhancements with our latest content package for Integrated Financial Planning.

In 2022 we plan to ship our content fully based on the New Model Type (Get Started with the New Model Type)!

Many thanks for your interest in the topic and I hope you like it. Please share your feedback in the comments and let me know if you have any questions.

Stay tuned and stay healthy,
Christoph

 

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gabriel Berthion
      Gabriel Berthion

      Dear Christoph,

       

      very interesting updated content !

      We have the SAC version 2021.20.12, and very interested in the Iterative activity price calculation. After import I cannot see the new filter you mentionned saying that Iteration is active or inactive. It seems that we have not the updated content.

      Is that related to our SAC version ?

      thanks

      Author's profile photo Christoph Tillmann
      Christoph Tillmann
      Blog Post Author

      Hi Gabriel,

      thanks for your question.

      Firstly you can check the "Changed On" date in the content network > business content for "Integrated Financial Planning" to ensure this has been updated in the library (source for import) in your tenant. Should show Nov 8, 2021.

      Secondly, you can check that the data action has been updated during import to your tenant. Hence, check the dates "Created" and "Last Changed" for data action 'SAP__FI_BPL_IM_COSTCENTER_CALCULATE_PRICE'. Last change should be the date of your last import. If it isn't, import again only the data action.

      Btw: When did you import the content to the tenant first time? You might need to re-import more objects.

      Step 1
      Go to content network > business content > Integrated Financial Planning for SAP S/4HANA > Import Options.

      Step 2
      Select import option "Overwrite objects and data" and click in the content area the checkbox on "Name" to deselect all objects!!!!

      IFP%20Import%20Update%20-%20Step%201

       

      Step 3
      Scroll down to section "Data Actions" and select only data action object named "Calculate activity cost rates".

       

      Step 4
      Import and check updated data action in story SAP__FI_BPL_IM_COSTCENTER_ACTIVITYPRICE_CALCULATION.
      Navigate to tab "Cost Rates" > switch to Edit-mode > Select data action trigger "Calculate Activity Cost Rates". Now you should see the new parameter.

      Let me know if you have further questions.

      Kind regards,
      Christoph

      Author's profile photo Gabriel Berthion
      Gabriel Berthion

      great it worked reimporting only the data action

      Thanks Christoph !!!

      Author's profile photo Wolfgang Runge
      Wolfgang Runge

      Dear Christoph,

      thanks for the update which is very interesting. We also have built already an integration between SAC IFP and SAP IBP which worked pretty ok.

      But looking into the add-on package you have mentioned (Add-on for Integrated Financial Planning for SAP S/4HANA) I can only see the integration to workforce planning.

      "Overview
      This content package is an Add-On for the package Integrated Financial Planning for SAP S/4HANA and provides integration to other planning packages. Currently available is the integration to the package Workforce Planning for SAP S/4HANA Cloud. The Add-on package can be imported after both the Integrated Financial Planning for SAP S/4HANA content and the Workforce Planning for SAP S/4HANA content have been imported."

      Best regards,

      Wolfgang

      Author's profile photo Christoph Tillmann
      Christoph Tillmann
      Blog Post Author

      Dear Wolfgang,

      many thanks for your feedback. You're right it seems the description is not updated. Please take a look at the tab "Import options". You should see the new objects for IBP integration:

      • Story
        • SAP Finance: BPL - Copy Demand from IBP
      • Model
        • SAP Finance: BPL - IBP Integration
      • Connection
        • SAP Integrated Business Planning
      • Data Actions
        • Clear Version
        • Create IBPsample data
        • Copy demand from IBP

      Will check with the team to get an updated overview tab.

      Let me know if you have further questions.

      Kind regards,
      Christoph

      Author's profile photo Wolfgang Runge
      Wolfgang Runge

      Thanks!

      Author's profile photo Christoph Tillmann
      Christoph Tillmann
      Blog Post Author

      Hi Wolfgang,

      the content package overview page has been updated.

      Kind regards,
      Christoph

      Author's profile photo Jef Baeyens
      Jef Baeyens

      Hi Christophe,

      Great content.

      2 questions:
      1) Is there any expectation when this will be updated in 2022 (using SAC new models)?
      2) Is it possible somehow to store activity rates / percentages in a separate model and on different time granularity (e.g. quarterly) for planning purpose? We'd like to customize to perform driver based planning, but cannot get any functionality to work when models use different time granularity.

      Author's profile photo Christoph Tillmann
      Christoph Tillmann
      Blog Post Author

      Hi Jef,

      many thanks for your questions.

      1. we're working full force on providing the content on the new model and release it with 2022.Q2 (subject to change), including some enhancements in the opex planning. Stay tuned!
      2. This is currently not forseen in standard business content. Would be interested to learn why you'd like to store it in a separate model. I guess you're aware that you can maintain rates with quarterly logic also in a monthly model - just keep same value for 3 month ;). For generic feature questions how to combine monthly and quartely planning models I kindly ask you to reach out to SAC-P PM team.

      Let me know if you have further questions.

      Kind regards
      Christoph