Skip to Content
Technical Articles
Author's profile photo Thomas Boerner

PaPM: How to embed an SAP HANA stored procedure into a model

Hello all,

As you certainly know, SAP Profitability and Performance Management (PaPM) is a modern modeling application for covering business requirements beyond standardized best practices. It was designed for being used by business users and therefore strives for replacing coding and scripting (as often necessary in other solutions) with configuration enabling business users to become more independent from IT and to extend and optimize allocation and calculation models much faster.

However, in some situations it might still be helpful to include SQL coding (SAP HANA stored procedure) into a model, for instance in the initial implementation project when you can take it over from the predecessor application.The attached screen shots demonstrates how you can embed SQL code (an SAP HANA stored procedure) into a model of PaPM.

The same function (PaPM business function Remote Function Adapter) can of course also be used for connecting to other applications and systems including S/4HANA, web-services or an R server.

Find everything about PaPM in the application help under this link.

Have fun,
Thomas.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Chanchal Gupta
      Chanchal Gupta

      Thanks a lot for the blog Thomas. can you please share some examples where calling HANA stored procedure would be beneficial or helpful?

       

      Thanks

      Author's profile photo Thomas Boerner
      Thomas Boerner
      Blog Post Author

      Hi Chanchal,

      Actually PaPM aims at freeing customers from writing SQL script themselves. Instead they would just create their models by configuration enabling business users to work independently from the IT department.

      However, in some companies division of work just remains the same and developers would continue to (partly) do what they might know best writing own script for realizing requirements.

      Best regards,
      Thomas,

       

      Author's profile photo Martin Kucharcik
      Martin Kucharcik

      Hi Thomas,

       

      is similar feature planned also for PaPM Cloud?

       

      Thank you and regards,

      Martin