topic Re: HR Table Relation in Application Development and Automation Discussions

HR Table Relation

Former Member — Wed, 02 Jan 2008 15:58:13 GMT

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 — Fri, 04 Jan 2008 14:15:00 GMT

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 — Sat, 05 Jan 2008 15:31:52 GMT

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