05-11-2011 7:04 PM
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
05-11-2011 7:11 PM
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
05-11-2011 7:11 PM
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
05-11-2011 7:29 PM
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
05-26-2011 8:52 AM
05-26-2011 8:52 AM