cancel
Showing results for 
Search instead for 
Did you mean: 

Pay component group amount in Story report

Tal_Levy
Explorer
0 Kudos
1,776

Hi

Does anyone manage to create a story report showing the pay component group amount?
I already activate the paycomponent sync and cant see the info in ad hoc report
but for some reason, I can show it Story report
I tried to create a custom field with the calculation but then I faced a different issue - unable to present all records in the same currency

Tnx

Accepted Solutions (0)

Answers (3)

Answers (3)

CSmith
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi tal.levy.cellebrite,

Yes the videos in the blogs refer to the compensation and variable pay modules so the information shared is specific to them. You should be able to create a custom calculation to sum various pay components that make up the pay component group using a starting EC domain. I'm not sure if you will be able to access any currency conversion tables but you should be able to hard code the conversion rates as well in a custom formula worse case. I have not yet built this type of report.

You can also try adding the EC tag to your question as since the data is coming directly from EC, it's more relevant there and you may get additional responses.

All the best

Christian

CSmith
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi tal.levy.cellebrite

You can access PCG from EC in ad hoc or Table Reports. Easiest way is to create a report under the Person and Employment Info as of date domain. The PCG are under Employee Pay Group Sums usually at the very bottom.

Unfortunately it is not yet possible to report on PCG in Story Reports but as these are calculated fields, you could re-create the calculation in a custom field by summing the applicable pay components.

Alternatively if you are running a Story Report from the compensation worksheet, the PCG data will be stored there and you should be able to run a report using the Compensation Planning domain in story report.

Hope that helps,

Christian

Tal_Levy
Explorer
0 Kudos
Hi christiansmith
Thank you for your answer
First I wanted to say that your post blogs that xavierlegarrec posted in his answer were great and I learned a lot from them.

Please correct me if I'm wrong,
According to the videos, I must use "compensation planning" to get this info. But If we didn't implement the compensation module, I can't use it.

I assumed that if SAP already announced that in the near future, all reporting except Stories will be decommissioned, I need to build all new reports with Story.
unfortunately, I understand that right now, it is not possible to create a Story report with "Employee Pay Group Sums", I can do that only with an ad hoc report.?If I do want to use Story and create a custom calculation, I couldn't find a way to add to the calculation the ability to convert all to USD currency - Do you have any tips for that?

Tal
xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi tal_l

I have never built a report pulling data directly from PCG in EC however wanted to point to these recordings by my colleague Christian Smith in case they can be of help. I do believe that she pulls all information (including annualized salary = pcg from Compensation domain however).

https://blogs.sap.com/2022/10/04/learn-how-to-create-an-incentive-outcome-dashboard-in-report-storie...

https://blogs.sap.com/2022/08/04/learn-how-to-create-a-compensation-budget-dashboard-in-report-stori...

All the best

Xavier

Tal_Levy
Explorer
0 Kudos

Thank you