‎2007 Jan 11 8:35 PM
Hi Folks,
I'd like to receive some tips improve performance in HR reports specially payroll.
Thanks
‎2007 Jan 12 12:19 AM
HI,
Almost all HR reports use the Logical Databse for their selection screens.
You may use the standard BAPI's or FM's to fetch data from the databases.
This will definitely increase the performance.
Regards
Subramanian
‎2007 Jan 12 12:19 AM
HI,
Almost all HR reports use the Logical Databse for their selection screens.
You may use the standard BAPI's or FM's to fetch data from the databases.
This will definitely increase the performance.
Regards
Subramanian
‎2007 Jan 12 5:53 AM
Hi,
Do not use LDB's if you have huge data. Better to design your own selection
screen and code accordingly.
While writing the selects try to give as many key fields as possible in the
where condition. Giving BEGDA and ENDDA will help a lot in filtering the
data. Filter the data initially i.e. at the selects only rather than filtering the
records at the end.
If Payroll for a pernr is to be read then there is no way to get the results for
one particular period in one single go .. need to get the entire data and then
filter it accordingly based on the period. Even if there are any FM's they also
do the same ..
Regards,
GSR.