Skip to Content
avatar image
Former Member

Joining PA and HRP tables

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 02, 2015 at 04:15 PM

    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. 🤪

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 05:01 PM

    Normally Person data 'P' is not maintained in HRP1000. What data would you like to fetch from HRP1000?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 06, 2015 at 08:55 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded