Skip to Content
author's profile photo Former Member
Former Member

HR Table Relation

Hi,

I'm new HR module.

I require the following field in the report

employee id, grade, grade effective date, leave entitlement, ID card number, date join, termination date

Anyone know the know the HR table relationship such as PA0001, PA0005,etc??

Thx

Regards,

Kit

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2008 at 02:15 PM

    Hi,

    Most of the HR tables can be joined with the personnel number field (pernr). Also make sure that you select using the field endda = '99991231'.

    If you have to select from more that two tables, pls use logical DB pnp for emp org data.

    Regards

    Ajith

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.