Table for confirmed hours after posting to CO
I am looking for a table which gives me number of hours booked on a WBS/network activity. Booked either via CATS timesheet or direct confirmation of activity.
We are planning to use this hours for a custom report/program, but I want to make sure that I only pick it after it is posted to the WBS.
RPSCO I believe just gives me the Value, not the quantity?
I do see the quantity filled up in CJI3 for the labor confirmations. Which table should I use for quantity?
I think we can find it in CATS database table, but I want to pick it only after CATS-CO job is run and its posted as expense on project.
Please let me know if you hv any clarifying questions.
Ken Melching replied
COEP will have the Network Activity Object number.
Try to use COSS and COSP first.
COSS and COSP will already have the aggreation by period. That will save you a lot of work.
COSS is seconday cost elements, so it will have internal labor and manual confirmations. COSP has primary cost elements, so it will have external labor. The object number in these table will be the Network activity, so you will need to do the aggregation by WBS within your report.
As actual postings are made, COEP gets new records, and the records in COSS and COSP are updated. So be aware of that.