Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Poor performance with MSS Pagrs or Compensation Planning Module

Former Member
0 Kudos
82

We have performance problem for compensation planning, details of which

has been listed below.

We are experiencing VERY POOR PERFORMANCE when a manager tries to do

compensation planning for the 118 people who report to him. The following are the steps that

are involved when a manager tries to do compensation planning.

1) Plan : 2 mins

2) Apply Guidelines : 3 mins

3) Review: 3 mins

4) Send : 4 mins

We executed ST05 (SQL & RFC) trace in our back end ECC system and

found:1. Large no. of Selects on PA0001/HRP1001. When we tried to trace the

source code we found that the selects were predominantly from the function

module HR_READ_INFOTYPE.

Based on one of the suggestion on this forum we tried HRWPC_RFC_OADP_EVAL_DATAVIEW in the field CACHEMAXAGE, giving value as 10 and it improved performance little bit. I am looking for any other suggestion to improve performance via indexes etc. Any help will be highly appreciated,

3 REPLIES 3

former_member192616
Active Contributor
0 Kudos
42

Hi Jaydeep,

Get in contact with a person with HR application knowledgde to check

if "structural authorization" is already used or if it it could be used for that manager.

There is a chance that the "structural authoization" could help to avoid the selects

on HRP1001.

Kind regards,

Hermann

Former Member
0 Kudos
42

We have structural authorization indexing done but did not help in this much

0 Kudos
42

Hi Jaydeep,

if these selects are not driven by the authorization checks (since structural authorization is used),

the next would be to find out who is driving these selects then.

You can use a non aggregated SE30 Trace, or the bottom up analysis in ST12 to find out who is calling this FM (and the selects). With that information and a person knowing the application one can start to analyze if there is another chance to reduce the number of calls.

Kind regards,

Hermann