Finding changes in HR infotypes by date.

[Former Member]

Hi All,

I am required to develop a report giving * changes in HR infotypes by date.

*I have made use of two Function Modules, HR_INFOTYPE_LOG_GET_LIST and

HR_INFOTYPE_LOG_GET_DETAIL. I am able to correctly get the table giving

output of first function module HR_INFOTYPE_LOG_GET_LIST. However, when I am

passing each record of table retrieved as output of first function module to

second function module, it is taking a lot of time to process and finally

gives a dump at the SELECT SQL statement that is responsible for retrieving the data from PCL4 cluster.

Regards,

Ameet

[Former Member]

have you considered this report RPUAUD00 infotype audit report? find its documentation [here|http://help.sap.com/saphelp_erp2005vp/helpdata/en/d8/2d183828204b1ae10000009b38f889/content.htm]

[Former Member]

Hi,

Thanks for the reply.

Yes, thats true. My requirement is based on report RPUAUD00 infotype audit report.

Based on this report and Functional Specification given to me, I am required to make use of two Function Modules mentioned earlier.

I have written a code given below:-

DATA: t_change_list TYPE pldoc_key_tab,

w_change_item TYPE pldoc_key.

CALL FUNCTION 'HR_INFOTYPE_LOG_GET_LIST'

EXPORTING

• TCLAS = 'A'

begda = p_aedtm

endda = p_aedtm

TABLES

infty_logg_key_tab = t_change_list

.

DATA: t_before TYPE prelp_tab,

t_after TYPE prelp_tab,

w_before TYPE prelp,

w_after TYPE prelp.

LOOP AT t_change_list INTO w_change_item.

CALL FUNCTION 'HR_INFOTYPE_LOG_GET_DETAIL'

EXPORTING

logged_infotype = w_change_item

TABLES

infty_tab_before = t_before

infty_tab_after = t_after.

ENDLOOP.

Now, when I loop at t_after into its corresponding workarea, just to know the records populated by means of following code.

LOOP AT t_after INTO w_after.

CASE w_after-infty.

WHEN '0001'.

WHEN '0007'.

etc..........

ENDCASE.

ENDLOOP.

It gives me dump when report is run, and the dump error screen locates this error at point select * from PCL4.....

I hope that my problem is more clear to you now. Please help me out to understand what would be causing to give the dump.

Also I want to ask in case I dont want to use standard PNP selection screen. Inspite of that I want to use the only three select options viz Changed By, Changed On and PERNR from the RPUAUD00 infotype audit report. How can I achieve this. Is there a way to do this.

Regards,

Ameet