Skip to Content
Technical Articles
Author's profile photo Akshay Georaikar

SAP Profitability and Performance Management: A unique integration with SAP BPC and SAP Analytics Cloud

Introduction

SAP Profitability and Performance Management provides many integration plug points with various SAP and Non-SAP system. I am explaining here the SAP PaPM integration with SAP Business planning consolidation (BPC) and SAP Analytics Cloud (SAC).

This document will describe one of the ways to have a single interface for PaPM Users to provide input for PaPM calculations in SAC story, run PaPM functions through SAC and get updated results back in SAC story.

System Landscape: SAP PaPM, SAP BPC and SAC

Architecture

Below is the Architecture that describe various data flow and components

Architecture

Architecture

Solution:

PaPM Setup

Model BW function for data source in PaPM

Model%20BW

Model BW

PaPM Process as per business requirement:

Process

Process

Final PaPM Query for SAC story: This story can exposed in SAC story as final results from PaPM system

Final%20PaPM%20Query

Final PaPM Query

BW Setup

BW ADSO with “Planning enabled” and “External SAP HANA View” configuration

BW%20ADSO

BW ADSO

Aggregation Level on ADSO:

Aggregation%20Level

Aggregation Level

Input enabled Bex Query: Create I/P Enable bex query to capture user input for PaPM calculations

Input%20Enabled%20Bex%20Query

Input Enabled Bex Query

BW Process Chain Setup: Create BW process chain to have PaPM function triggered sequentially. this will be further required to be called in BPC planning function.

Process%20Chain

Process Chain

ABAP Process Variant: Use Program /NXI/P1_FW_RUN”. Maintain variant with specific PaPM function

ABAP%20Variant

ABAP Variant

ABAP%20Program

ABAP Program

BPC Setup

Create BPC Embedded Model and link it with BW ADSO.

BPC%20Embedded%20Model

BPC Embedded Model

BPC-BW%20Infoprovider

BPC-BW Info provider

BPC Planning Function: Planning function of type Fox Formula. this will be needed to call BW process chain.

BPC%20Planning%20Function

BPC Planning Function

BPC Planning Sequence:

BPC%20Planning%20Sequence

BPC Planning Sequence

SAC Setup:

BPC Live Connectivity: Create BPC Live connection

SAC%20BPC%20Live%20Connection

SAC BPC Live Connection

SAC Model with Live connectivity: Create SAC Planning model on Bex Input Enabled query

SAC%20Planning%20Model

SAC Planning Model

SAC story to update data in PaPM : Planning template on SAC model. This will help to get write data in PaPM Model BW function.

SAC%20Planning%20Template

SAC Planning Template

 

Trigger PaPM calculation through BPC Planning Sequence: BPC Planning sequence to trigger BW process chain of PaPM functions.

BPC%20Planning%20Sequence

BPC Planning Sequence

After the successful run of BPC Planning sequence triggered through SAC. SAC story get update with latest PAPM calculation results.

 

Conclusion:

There are many ways through which  SAP PaPM data get updated and trigger calculations.

It certainly helps PaPM Business users not to navigate many screens and get everything available on single platform.

References:

SAP Note 2589761

BPC Live data Connection

 

Cheers!!!!

Akshay Georaikar

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo chanchal gupta
      chanchal gupta

      Excellent. Thanks for sharing. :). what is your view on PaPM addressing budgeting and planning scenarios as a standalone solution? Did you go through the new sample content 'Corporate planning and budgeting'?

      Author's profile photo Akshay Georaikar
      Akshay Georaikar
      Blog Post Author

      Thank you. Yes, It can be targeted as solution for Planning and budgeting. With the new content in SP12, this has been addressed to quite some extent. Although still some of the key features are missing if compared with SAP BPC.

      Author's profile photo chanchal gupta
      chanchal gupta

      Thanks. :). You & I seem to be on same page. I too think that simple planning scenarios could be addressed.  maybe could you highlight some of those missing key features?

      Author's profile photo Akshay Georaikar
      Akshay Georaikar
      Blog Post Author

      Features like Work status, Business rule are pretty important for any planning/budgeting application. Its not like we can't do it here. but again we need to do customization( BW) to achieve this.

      Author's profile photo Dhananjay Khanna
      Dhananjay Khanna

      Thanks for the detailed info!

      Author's profile photo EMANUELE FUMEO
      EMANUELE FUMEO

      Hi Akshay Georaikar, thank you for the great post!

      Currently, BPC embedded requires a separate license, correct? What if we wanted to reduce the number of licenses needed by removing BPC? Do you think it would be possible to just connect SAC Planning and PaPM together?

      Actually, I am not sure because the live connection to BPC allows triggering planning sequences from SAC Planning, and I do not know if a similar mechanism could be implemented with PaPM...

      Thanks in advance!

      Author's profile photo Akshay Georaikar
      Akshay Georaikar
      Blog Post Author

      Hi Emanuele,

      Thank you.

      Yes, BPC embedded need separate license.

      Currently as per SAP planned, SAC Planning engine integration SAP PaPM innovation was planned in Q42021. However I do not see that connection yet.

      It will certainly help and can help to trigger processes.

      The other option i can think of is Odata services. there we can try to trigger PaPM processes from SAP analytics Cloud.

      Regards,

      Akshay Georaikar

       

       

      Author's profile photo Tushar Poddar
      Tushar Poddar

      Hi,

      Any document published by SAP to show how SAP is planning to place PaAM in its whole technology stack, given the capabilities it has as claimed by SAP.

      Or it will be also die down after few years because the confusion it will create for customers.

       

      Regards

      Author's profile photo Srinivas Perala
      Srinivas Perala

      Dear Akshay,

       

      Could you please share the procedure to integrate SAC and PaPM. I'm trying to connect PaPM on SAP BTP to SAC tenant. Thanks,

       

      Regards,

      Srinivas

      Author's profile photo Akshay Georaikar
      Akshay Georaikar
      Blog Post Author

      Hi Srinivas,

       

      Please find below link to refer:

       

      https://blogs.sap.com/2022/12/05/sac-and-sap-papm-cloud-integration-in-a-nutshell/

       

      Regards,

      Akshay