Projects allocated to BP in NWBC

[former_member290536]

I have Business partners and would like to see what all projects authorizations he has against which he can perfrom time sheet entries...?

Is there any table where i can refer this???

[ravi_ekambaram · Accepted solution]

Hi Maruti,

Instead of looking directly into tables, you can have a look that the standard feature in PPM, "Replace user/Resource' to find out the project which the user is authorized or projects which the resource is staffed.

This WD component is available in the standard SAP delivered role 'SAP_BPR_PPM' and the path is PPM application-->Portfolio & project administration-->Replace User/resource.

If this is not appearing in the NWBC menu, then make it visible in the above PFCG role menu.

Hope this helps ans suffices your requirement.

Regards,

Ravi

[former_member290536 · Accepted solution]

Hi Ravi You are correct but due to my project restrictions i am not able to do the activity which you have stated above. Also let me be more clear in my question. User is trying to do his time sheet entries thorugh NWBC but he is not able to find the project for which he needs to do time sheet entries. As per my analysis i think this user is not added in to authorization tab of the project hence not able to do timesheet entry he is able to see some other projects for which he doesnt want to do time sheet entery. Now as we dont have direct production access i want to check it in tables. Hence it would be helpfull if u can guide me here

[ravi_ekambaram · Accepted solution]

Hi Maruti,

Can you please confirm whether you use CAT2 for time confirmation or through Project Management-->Tasks-->My tasks.

Authorisations is required only for the later process and this can be achieved either by assigning the 'Resonsible Role' to the task or by manually adding the authorisation to the task. Tasks will be listed 'My tasks' tab only if user has write access to the task.

If user is not able to get the task/project list, then you need to open the project and see the details of authorisations. Through table it is difficult to understand since task will have GUID's rather than descriptions of the task.

Regards,

Ravi

[hanspeterbaier · Accepted solution]

Hello Maruti,

there are several options, why a user can't do time recording, e.g.

1. No staffing in project
2. No role/resource-task assignment
3. No authority
4. Status management (e.g. closed tasks or not-released tasks)

Since you have no access to production system and you want to check these points, try the following:

1. For correct staffing and role/resource-task assignment look at the tables DPR_BUPA_LINK and DPR_ENTITY_LINK. The table DPR_BUPA_LINK contains the linkage between role and business partner. Here you can also find the field PARTICIPANT_GUID that corresponds to the BUPA GUID in table BUT000.
   In Table DPR_ENTITY_LINK you have the linkage of the PARTICIPAN_GUID to the task GUID (ENTITY_GUID = GUID of tasks; ENTITY_TYPE = 'TTO' for tasks).
   So you can check if there is correct linkage of BUPA.
2. For checking authorities you can look at tables ACO_USER (Authorities defined on tab 'user'), ACO_USER_GROUP (Authorities definied on tab 'usergroup'; here you also need ACO_GROUP_USER for checking users in usergroup), ACO_HR_OBJECT (Authorities definied on tab 'org.unit'); ACO_ROLE (Authorities defined on tab 'role'). Inside these tables you have e.g. the GUIDS for the tasks an the values (like admin, write, no_auth, read, financials, etc...)
3. For checking status management of tasks (e.g. not released or closed) simply check the table DPR_TASK for the field 'PROC_STATUS_OWN'. It shows you, if a task is closed or not-released or cancelled (00, 20, 21, 40, 41), The value has to be 10 or 11 for time recording (if integrated with CATS and accounting).

I hope this will help you solving your issue.

best regards,

Peter

[former_member290536 · Accepted solution]

Hi Ravi thanks a lot for resposne. Currenlty, for a project the person handling project would go to authorizations tab add all the users who can work on it. Now only the users added in authorizations tab would be able to do time sheet entries. As we did not have direct access to production system i was trying thourgh tables. As you said its really difficult from tables as it has GUIDs