Provide ABAP statement used in HR Extractor

28 Views

Hello All,

I am extracting data by enhancing 0EMPLOYEE_ATTR extractor, using database tables PA0002, PA9001 (Custom infotype) and PA0006. But the logic does not take care of time intervals that are overlapping. so the data coming looks inconsistent.

For e.g.:

0EMPLOYEE (change of cost center)

01.01.2007 - 31.03.2007 000001 524000

01.04.2007 - 31.03.2008 000001 524001

PA9001 (change of job title)

01.01.2007 - 31.06.2007 000001 Manager

01.07.2007 - 31.12.2007 000001 Director

Wrong result (without time consolidation)

01.01.2007 - 31.03.2007 000001 524000 Manager

01.04.2007 - 31.03.2008 000001 524001 Manager

Correct result (with time consolidation)

01.01.2007 - 31.03.2007 000001 524000 Manager

01.04.2007 - 31.06.2007 000001 524001 Manager

01.07.2007 - 31.03.2008 000001 524001 Director

How do I get this resolved?

Kindly inform. Thanks.

Regards,

KP

Edited by: KK PP on Jan 8, 2008 6:35 AM

I referred a std FM 'HR_BIW_EXTRACT_IO_OCCUPANCY', which uses a ABAP statement PROVIDE for retrieval of consistent data based on the time intervals, but I am not sure how it works. Kindly help.

Regards,

KP