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: 

Performance issue in HR Payroll Report

Former Member
0 Kudos

Hi Experts

I having performance issue in HR payroll report

My issue as follows

I have selection period to select date range

if I select start date & end date Which is giving EMP name, wage type,wage text, amount, etc

whenever I excute it takes morethan one hour to get the resust

my code is some wht like this

loop at GT_REDIR where

begda(start date) ge pnpbegda and

endat(end date) le pnpendat and

paytyp eq ''

move gt-sqnr to lv_sqnr

call function PYXX_READ_PAYROLL_RESULT

here i am passing pernr and sequence number

please give me some idea to fix this issue

Thanks in Advance

Gopinath Subramanyam

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hii...

Have you checked your program in T-CODE SE30 and have u checked SQL Trace for your program.. It will tell you which statement is taking how much time..

Then your problem will be specific, then we can find the solution.

Regards,

Jhings

4 REPLIES 4

Former Member
0 Kudos

Hii...

Have you checked your program in T-CODE SE30 and have u checked SQL Trace for your program.. It will tell you which statement is taking how much time..

Then your problem will be specific, then we can find the solution.

Regards,

Jhings

Former Member
0 Kudos

Hi Jhings

Thanks for Your immediate reply

data is coming from cluster table and also I am using Logical database

I will post my code here soon

Regards

Gopinath subramayam

0 Kudos

Solved Myself...

Regards

Gopinath Subramanyam

0 Kudos

Solved Myself...

Regards

Gopinath Subramanyam