Project Status Report using CATSPS. Billable/Non-billable Hours?

[Former Member]

I am working on a Project Status Report and am using CATSPS table instead of CATSDB table since thatu2019s the cross-application table for PS module. But I am facing a small problem in using CATSPS table. There is no field in CATSPS table that tells me if the hours are billable or non-billable. Table CATSDB had a field u201CBill Typeu201D (Billable/Non-Billable) but I donu2019t see anything like that in CATSPS. If I use CATSDB table and filter out status "30" for only approved hours, I am getting duplicate entries for actual hours in Crystal Report 2008. What is the correct table to be used in this case and also what is the mapping field(s).

Also, looking to display the billing type for the document in VBRP table. I am able to display the document type code but not the description itself. Which table will have this mapping?

Also, in Crystal I have the total Purchased hours at the 3rd level WBS but the total actual hours are coming from the 4th level WBS (Activity level). Each 3rd level WBS can have multiple 4th level WBS (difference networks). How do I know (logic) which 4th level WBS total to pick up and add to which 3rd level WBS total? Also, how do I display the total actual work hours form the 4th level WBS to display at the 3rd level?

Here is an example:

WBS , Level , SKU# , Network# , Activity# , Purch. Hours , Act. Bill. Hours , Remaining Hours

EP-2927-AMB-0001 , 3 , 600-310-100000 , N/A , N/A , 100.00 , N/A , 55.00 (=100.00 - (30.00+15.00))

(Purchase Hours from this line) - Total Act. Bill. Hours from level(s) 4 below: A+B)

EP-2927-AMB-00011 , 4 , N/A , 000004008303 , 10 , N/A , 5.00 , N/A

EP-2927-AMB-00011 , 4 , N/A , 000004008303 , 20 , N/A , 6.00 , N/A

EP-2927-AMB-00011 , 4 , N/A , 000004008303 , 30 , N/A , 15.00 , N/A

EP-2927-AMB-00011 , 4 , N/A , 000004008303 , 40 , N/A , 4.00 , N/A

(A) Total Billable Hours = 30.00 (5.006.0015.00+4.00)

EP-2927-AMB-00012 , 4 , N/A , 000004008304 , 10 , N/A , 6.00 , N/A

EP-2927-AMB-00012 , 4 , N/A , 000004008304 , 20 , N/A , 4.00 , N/A

EP-2927-AMB-00012 , 4 , N/A , 000004008304 , 30 , N/A , 5.00 , N/A

(B) Total Billable Hours = 15.00 (6.004.005.00)

If you notice there are two level 4 WBS (EP-2927-AMB-00011 & EP-2927-AMB-00012) in this example that are under level 3 WBS (EP-2927-AMB-0001). The Purchased Hours are coming from level 3 which means the hours are assigned per project at the WBS 3 level. Within each project there are different activity levels where actual hours worked by each employee are coming from. I need to sum the actual hours from all the available level 4 WBS and bring them over to the corresponding level 3 WBS in order to calculate the remaining hours. My challenge is how do I know which level 4 WBS belong to which level 3 WBS since there are more than one level 3 WBS in a Project and each level 3 WBS can have multiple level 4 WBS?

Please advise.

Regards.

-Rohit

Edited by: RohitBora on Feb 27, 2012 8:40 AM

Edited by: RohitBora on Feb 27, 2012 7:27 PM

[Former Member]

Hi,

My personal suggestion to you is try to describe problem very crisp and easy to understand so that you will get quick responses. Its very difficult to read and pin point what you are aksing and finally you will miss readers attentions.

As standard practice, hours planned at indiviudal activity level and actual costs posted on each indiviudal activity will roll up and display the aggregate values at corresponding higher WBS element level. At the same time system will let you know reamining hours at indiviudal level and not higher level as rolled up.

Your WBS structuure is bit confusing me, in what way you are encoutring problem in identitying level 3 and level 4 WBS elements. Key will clearly denotes which is level 3 and level 4. As cited by you, EP-2927-AMB-0001 this should be level 3 and EP-2927-AMB-00011 is level 4. I am sorry to say that structure key was not maintained proper way and bit confusing.

Regards,

PSR

Edited by: PSR on Feb 27, 2012 11:05 PM

[Former Member]

Hi PSR,

I am creating this report in Crystal Report 2008. It does not automatically give me the total hours at the higher level from the levels below it. I have to do the calculation. If it was as easy as doing the sum from 4th level WBS and displaying it at the 3rd level WBS, I would have done it myself but the problem is that there can be more than one 3rd level WBS. Yes, the "Level" field tells me which hierarchy level I am on but I still need a way to tell which level 3 WBS does a given 4th level WBS fall under, perhaps something like matching the WBS name? You said the structure key was not maintained properly, what do you mean by that? And if so, what would you suggest I should have done instead?

Regards.

-Rohit

Edited by: RohitBora on Feb 27, 2012 11:19 PM