topic Re: Report performace in Application Development and Automation Discussions

Report performace

Former Member — Thu, 24 Jul 2008 16:02:32 GMT

Hi,

Which one will provide better performance when fetching data from multiple infotypes.

1) multiple 'HR_READ_INFOTYPE'

2) RP_PROVIDE_FROM_LAST or RP_PROVIDE_FROM_FIRST.

3) PROVIDE....ENDPROVIDE with HR_READ_INFOTYPE inside it

any other method...please let me know

Regards,

Amit

Re: Report performace

Former Member — Thu, 24 Jul 2008 16:09:28 GMT

You can use the Function

HR_READ_INFOTYPE

and read a particular Infotype. if you want Many infotype then use other methods.

Re: Report performace

Former Member — Thu, 24 Jul 2008 16:29:44 GMT

hi check this..

this depends on the requirement and if you are using the ldb or not ...

generally we use to fetch the data in hr by the 3 methods----

1 . select statements

2. using function modules

3. by the ldbs PNP, PAP, PCH, PNPCE .

we will follow the hr_read_infotype because this will follow the authorisation checks than the select statements..and if you want to display one employee data in the report ..then the logical database is also good for the performance .

for processing of many pernrs and many infotypes ....we will use provide and endprovide....

Re: Report performace

Former Member — Thu, 24 Jul 2008 16:55:37 GMT

Hi,

If you use the logical database in your program

and list the infotypes in the statement

 INFOTYPES :0000,0001......XXXXX

On the GET PERNR EVENT THE INFOTYPE TABLES PAXXXX Will contain the data for the list of employees based on data selection and time selection.

Then RP_PROVIDE_FROM_LAST or RP_PROVIDE_FROM_FIRST gives you the older or latest required infotypes.

The FM 'HR_READ_INFOTYPE' is used if you use different LDB or do not use LDB and need to fetch particular employee data .

Re: Report performace

Former Member — Mon, 18 Aug 2008 08:22:59 GMT

Thanks Mates.

I will follow the the suggestions mentioned in this thread and check the performance.