SAP HR Table

[Former Member]

Hello experts..

i have to get a search help for the following,

1) Personel number (PERNR)

2) Name

3) Department

4) Designation

5) Email id

for department and designation we need the code and their TEXT description.i dont know where to get these from.

Thank You.

Askar

[Former Member]

Hi Askar,

use table HRP1000 for text  of department and designation.

Regards,

Santosh Yadav

[Former Member]

I also need to get personel number,name so am creating a database view.
i need to give all tables.

please help,so that i can know which table contains what kind of field,currently i figured out PA0001 for employee id and name.

Thanks
Askar

[raymond_giuseppi]

You could easily find it in the Infotypes list, read some document like PA - Personnel Management in HR Infotypes.

(Look for Personal Data (International).)

Regards,

Raymond