on 07-22-2014 10:34 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.