0HRPOSITION_ATTR

[former_member260745]

Hi Experts,

I have appended 0HRPOSITION_ATTR Datasource with some fields from HRP1011, HRP1007, HRP1008.

This is my sample code.

    SELECT SINGLE STATUS FROM HRP1007 INTO WA_HRP1007-STATUS

         WHERE OBJID EQ <WA_HRMS_BW_IO_POSITION>-PLANS

         AND   ENDDA GE <WA_HRMS_BW_IO_POSITION>-BEGDA

         AND   ENDDA LE <WA_HRMS_BW_IO_POSITION>-ENDDA.

    IF SY-SUBRC = 0.

      MOVE WA_HRP1007-STATUS TO <WA_HRMS_BW_IO_POSITION>-ZZSTATUS.

    ENDIF.

PSA- extractor worked fine but the value in PSA overlapped. Checked DPT "Handle Duplicate records" still did not work.

Position        Start Date               End date      Status     Job

30000000      07/01/2005             06/30/2007                1000001

30000000      07/01/2007             02/26/2008                1000002

30000000      02/27/2008             06/30/2009     0         1000003

30000000      07/01/2009             06/30/2009                1000004---> This last record has Start date Greater than End date, causing further load to fail. Not sure why End date did not change to  12/31/9999      

Seems like, time dependent nature of HR data,  it is better idea to create seperate extractor for each Infotype and map them into InfoObject.

Please suggest if you have better thought.

Thanks

Arjun

[mr_v · Accepted solution]

Because of time dependency, its always better to create seperate datasource for HR master data objects.

In your case you can create custom datasource on HRP1007 to get 'Vacant Position' information.

And other custom datasource on HRP1008 to get Personnel Area, Personnel Sub area, Employee Group, Employee Sub Group etc

[former_member260745 · Accepted solution]

Thanks V.

[former_member260745 · Accepted solution]

Hi,

I am using standard DataSource- 0HRPOSITION_ATTR and I am getting  last row overlapped.

Is there any pre-step that I need to load data so it will not through error loading from PSA to 0HRPOSITION.

Position        Start Date               End date      Status     Job

30000000      07/01/2005             06/30/2007                1000001

30000000      07/01/2007             02/26/2008                1000002

30000000      02/27/2008             06/30/2009     0         1000003

30000000      07/01/2009             06/30/2009                1000004---> This last record has Start date Greater than End date.

[mr_v · Accepted solution]

Did u check, IT HRP1000 (OTYPE = S) data for this position 30000000 ? End Date should be 31.12.9999.

Also check RSA3 check for 0HRPOSITION_ATTR for thsi position 30000000.

[former_member260745 · Accepted solution]

Hi V,

Sorry, I've used the wrong Position ID for this example. for 30000000, the End date is 12/31/1999 which is good but for some other positions like 30001022 it has End date as 06/29/2007. because this position completely delimited.

Such position when loading into data target getting date overlap error message. Is there some setting that is necessary to handle this type of records.

Position     Start Date   End date    V EEGrp    Org unit         Job  

30001022 07/01/2005 12/10/2005  2 26          10000152      20000034

30001022 12/11/2005 06/30/2006  2 26          10000302      20000034

30001022 07/01/2006 06/29/2007  2 26          10000302      20000034

Thanks

Arjun

[mr_v · Accepted solution]

Is the above example from RSA3 check?

For delimited positions, there would be no 12/31/9999 record.

Since you are running on 0HRPOSITION_ATTR (without enhancement code), the startdate should never be > than Enddate. Seems to be incoorect record.

Pls validate these positions with your HR functional team.

[former_member260745 · Accepted solution]

Thanks for your input V,

We found that there was data entry error from HR.

Thanks again for your input.

Arjun