cancel
Showing results for 
Search instead for 
Did you mean: 

Confirmed Work Report

rhuben007
Explorer
0 Kudos

Hi Experts,

Is there a way we can see the total confirmed work(dates and works tab) for each Project at least in the Projects Dashboard?

Sample Dashboard view we want:

Project (Number)Project DescriptionPriorityTotal Confirmed Work

We also want to see the total hours of confirmed work allotted by a resource in the Resource Overview in the Resources tab of the project.

Sample Resource Overview we want:

ResourcesDistributedStatusRem. AvailabilityAvailabilityAssigned EffortUnitTotal Confirmed Work

Thanks,

James

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I'm afraid you'd have to write some code to roll the data up. Another (possibly easier) way would be a BW or BCV report.

Answers (2)

Answers (2)

rhuben007
Explorer
0 Kudos

Hi Everyone,

Thanks for the replies.

Yes creating a customized report is actually my objective, I asked this question hoping if you could suggest which tables to use.

I already had my research and came up with the idea of using the ff. tables:

DPR_DASHBOARD - for the actuals, and person responsible

DPR_PROJECT - for other information regarding the project

DPR_PHASE - for other information regarding the project

DPR_TASK - for other information regarding the project

CGPL_TEXT - for the names of project, phase and tasks

-James

former_member201206
Active Contributor
0 Kudos

Hi James,

I think, the hierarchy information is missing (which tasks belongs to which project).  I think, you can either use cgpl_entity or cgpl_hierarchy to get it.

Kind regards,

Zhenbo

rhuben007
Explorer
0 Kudos

Hi Zhenbo, it's already in the DPR_DASHBOARD table

former_member201206
Active Contributor
0 Kudos

Yes, own report would be solution, it should be not difficult.

In order to get the hierarchy, you can use BAPI BAPI_BUS2172_GET_TREE or take a look & reuse part of the report dpr_get_tree .

Kind regards,

Zhenbo