SAP HR

I have to generate a report that has personnel number,employee name,position and position text.The first three fields are being retrieved from one table ,that is,PA0001 and the last is to be retrived from another table namely HRP1000.Is there any common field in both the tables on which the validation can be applied and data can be retrieved?