on 11-02-2015 2:09 PM
Hi,
I need to join PA0001 or PA0105 with HRP1000 so I can get a record that lists the employee name (SNAME) with their a object name (STEXT). Would this be done by filtering HRP1000 to object type = P and then joining the object id with the personnel number (PERNR)? this is somewhat urgent.
Cheers,
Yes. The object id in HRP1000 for object type "person" is the employee ID from PA0001.
....and you can make your life easier by using any one of the several functions/methods that will "match" the two for you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you have direct table access, then by finding the "employee" HRP1000 record and making use of "begin data" and "end date", you should then be able to find all the other "relations" that will interest you. This of course assume PD/OM-to-PA integration is "on". This is where knowing OM will come in handy.
ALL of the HRP10001 dancing will depend on the object type of the "from" and "to" object as well as the "relation" information you will have to look for...for example, the position for the employee(ie."holder") would be relation "B002" looking from holder->to->position.
After that, you can use the other HRP tables to find details (like text/title, abbreviation, related employee group/subgroup, cost center/company code, etc). All of this dancing should match up exactly to table PA00001 for the employee for the same period of time (begin date to end date). Have fun!
Read PA0105 matching on USRID and Subty = 0001 plus dates. You get a match then use the PERNR from the matching 105 to read another PA table for that PERNR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Normally Person data 'P' is not maintained in HRP1000. What data would you like to fetch from HRP1000?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Charles,
Don't join them, join is rather FI or SD abap style... HR is just a lil cleaner do cascade fetching.
1. IT0001
2. IT0105
3. IT1000 or T528T
You can use HR_READ_INFOTYPE function for PA infotype (IT0001 and IT0105), and RH_READ_INFTY_1000 for PD infotype (IT1000) or CL_HR_T528T if you go for T528T. For your scenarios I'd recommend fetching from T528T. For USERID don't forget to evaluate the subtly field for structure P0105 and consider that some subtype are customized to be kept under the _LONG field.
If you use PNP or PNPCE logical DB in the your program you can even forget about HR_READ_INFOTYPE and just declare INFOTYPES: 0001, 0105 in the global area in oder to be able to automatically fetch p0001 and p0105 and loop to access each entries.
Best,
Antoine
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.