Need Project Details Table of SAP HR
I am developing one RFC which will accepts PERNR (Table PA0002) as a input and should output one table containing project information from table PROJ.
I found another table namely PA0535 (HR Master Record: Infotype 0535 (Project & Achievement) ) containing 3 fields:
1) ACHTP Project or achievement type
2) ACHNM Project or achievement number
3) ATTRL Role in project
More required fields from PROJ are :
1) PSPNR Project definition (internal)
2) PSPID Project Definition
3) VERNA Name of responsible person (Project manager)
4) PLFAZ Project planned start date
5) PLSEZ Project planned finish date
But i don't find any common field in these two tables.
Can you tell me the other tables so that i can write join query to fetch all these fields??
Any pointers regarding this will be greatly appreciated.
Thanks in Advance,