Restriction of change / display to Model Tables via Query

[philippsathasivam]

Hello Experts !

We got a problem concerning autorizations:

We built the following scenario:

We read data from a S/4HANA table and write it into a model table. The business user now has the possibility to change certain key figures by using a query (editable), so that the subsequent process is calculated with updated key figures. Here is a diagram of this:

This works basically without problems.

However, we want to make the environment available to a large number of users (one per cost center). This means that the display and the change option in the query must be restricted to the respective cost center.

Example:

From S4 we read Key Figures for Cost Center 1 and Cost Center 2.

Through separate processes for User 1 (Cost Center 1) and User 2 (Cost Center 2), the data for each of the cost centers is written to the model table and then processed accordingly (this works very well through selection in the different processes). However, the query is process-independent, so that each user can see and also change all data contained in the model table.

We are looking for a way to restrict the view and the possibility to change data for each cost center.

We have already looked at different possibilities here in the blog:

1. https://blogs.sap.com/2021/12/09/sap-profitability-and-performance-management-papm-handy-tips-to-man...

Point 6 in this blog describes how you can specify variables as mandatory inputs for the user. The data will then be filtered according to the entered values. The issue here is that every user can still enter every available cost center and not only the one they are responsible for.

2. https://blogs.sap.com/2022/06/03/sap-profitability-and-performance-management-cloud-analytic-privile...

This blog describes the concept called “Analytic Privileges”. Unfortunately, only available in PaPM Cloud.

3. Using Info Objects

https://blogs.sap.com/2021/04/16/using-sap-bw-authorization-relevant-infoobject-in-sap-profitability...

and

https://blogs.sap.com/2021/07/30/using-sap-bw-authorization-relevant-infoobject-in-sap-profitability...

These 2 blogs describe ways of using bw infoobjects to achieve the goal. The issue is that we consume exclusively S4 fields and no info Objects. Maybe there is a simple way to transform the S4 Cost Center field into an Info Object and apply the authorizations to it?

Any help would be appreciated!

Best regards, Philipp