HR Table Relation

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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