Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

HR Table Relation

Go to solution
Former Member

‎01-02-2008 3:58 PM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎01-04-2008 2:15 PM

0 Kudos

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

2 REPLIES 2

Go to solution
Former Member

‎01-04-2008 2:15 PM

0 Kudos

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

Go to solution
Former Member
In response to Former Member

‎01-05-2008 3:31 PM

0 Kudos

Hi Ajith,

Thx for your reply. What is the logical DB about?? Is it only available in the ABAP?? Can i use it in the database level??

Regards,

Kit