Few queries on HR tables
I want to make one sapscript where i can display employee id,name,date of joining,department and payroll.For that i think have to map like this
employee id - pernr of PA0000
employee name - ename of PA0001
date of joining - begda of PA0000 where massn is 'HIRING'
department - organizational unit from PA0001 and relate it to hrp1002 and hrt1002
payroll - I will do later,using functional modules.
my doubt is that massn consists of numbers,i dont which number relates to 'hiring' and dotn have organizational unit in both the tables hrp1002 and hrt1002.So can anyone tell me which number in massn relates to 'hiring' and how to get department name.
thanks in advance.