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?
Edited by: RohitBora on Feb 27, 2012 8:40 AM
Edited by: RohitBora on Feb 27, 2012 7:27 PM