Report performace

[Former Member]

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

[Former Member]

You can use the Function

HR_READ_INFOTYPE

.

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

[Former Member]

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....

[Former Member]

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 .

[Former Member]

Thanks Mates.

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