Table join problem- "no data was selected"

[Former Member]

I've created a table join of tables PA0000, PA0001, PA0002, PA0077 and T5U13. But when I try and execute an ad hoc query, I get a message that says "No data was selected." I am trying to create a query with EEO info...I need to be able to input personnel number or employment status (PA0000), need to display the employee's subgroup, position and job (PA0001), their first and last name (PA0002), and ethnic code (PA0077). From T5U13, I need the EEO category. I've already tried building a query using PNP and PNPCE but was not successful. What step(s) am I missing? Thanks for any guidance you can provide.

[Former Member · Accepted solution]

Hi Harmony

you wanted to write a query in ABAP or you want to write an adhoc query.

Also if I am not wrong PNP and PNPCE are for Employee master data, Time data and payroll while the Job or Job category information is part of human resource Planning data (PD) and is only available in PCH.

guds

Edited by: guds on May 12, 2009 1:20 AM

[Former Member · Accepted solution]

Thanks for your reply. I want to be able to create an adhoc query- using ABAP would be my last resort