Fetch HR infotype tables in BI Extractor
I have a requirement to select huge amount of employee data from HR master data infotype tables. The HR master data is stored multiple tables which is more than 10. I have written the logic for selecting the data in the extractor custom function module. The selection screen has only personnel number, employement status and date range to select the data. The employee data has to be selected with in the date range. The employement status which is a selection parameter on the screen is maintained in a infotype table PA0000 for each employee. For the employee numbers selected from infotype PA0000 by passing employement status and date range as key other infotype tables(PA0001, PA0007,PA0008,PA2001,PA20002,PA2003 etc) has to be read. The extractor select the employees based on the packet size set on the input screen. For example in each set 1000 employee records are selected from the infotype pa0000. then for the employee numbers in this 1000 records other tables are read. Which is causing performance problem. How to fetch the HR data from infotype table in Extractor. In some cases the emloyee may have multiple employee assignment(concurrent assignment) those assignment information also has to be populated for each employee data output. The time infotypes has huge number data. So there is constraint to fetch all the entries from the table with out passing any dates.