on 2024 Oct 04 11:18 AM
Hello,
We are creating a SAP Story report using two reference roles. In our organization, each person has one reference role and there are few specified pay ranges and each pay range can have multiple reference roles. In our story report, we are trying to set up the query such that we pull the reference role for each individual and match it to the reference role for the pay grade to get the correct entry of data. Basically we need to pull 1) reference role for each individual and 2) reference role for pay grade in the same query. Now, while trying to find the reference role I am able to find and call the reference role of each employee. But I am not able to find the reference role for pay range (tried to click to see related tables from Pay Grade).
Please see the query set up in the screenshots attached. Can someone help?
Request clarification before answering.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.