Hi experts!!!
I need an extractor that gives me the hierarchy and the Personal ID. Like a join of the Organizational Unit extractor (0ORGUNIT_HR01_HIER) and the Staffing Assignments extractor (0HR_PA_OS_1).
I already saw that the 0ORGUNIT_HR01_HIER extractor give us the relationship between the nodes, but it doesnt have the staffing assigned to a specific node. I mean, if you have a node that is a SubArea node, you could have the relationship between the nodes (Parent node, Child node and Next Node), and the Personal ID of the person that is assigned to that node.
From the 0HR_PA_OS_1 extractor, we can get the Personal ID that is assigned to a specific Hierarchy level, but we can not take the relationship between the nodes.
So, what I want to get and I dont have any idea how to, is:
Get something like the resulting table from 0ORGUNIT_HR01_HIER with an additional field, the Personal ID of the assigned person to that node (NODENAME).
Fields for the table:
NODENAME|PARENTID|CHILDID|NEXTID|BEGDATE|ENDDATE| PERNR|
Anyone has faced a problem like this? Can anybody help me?
Thank you,
Hugo