Skip to Content
avatar image
Former Member

Table for confirmed hours after posting to CO

Hi Experts,

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.

Thanks,

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 22, 2015 at 02:08 PM

    You can use COEP, CO document line item table.  It is the lowest level of detail.  COEP will only have data after successfully posting to a WBS.  But for CATS time transfers it does not contain the workdate, only the posting date of when the time was transferred.

    Are you looking for individual time entry dates to a WBS?

    RPSCO is the PS reporting structure table that should match COSS, COSP (the CO summarization tables) but doesn't always, hence transaction CJEN.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 05:43 PM

    Hi Krishna,

    I would disagree with Terence about CATSDB and CATSPS.

    1. First it will cover only CATS and not confirmations outside CATS.

    2. None of these tables will guarantee you that same hours are really posted (and for example not failed a financial document).

    You should have all the quantities of what is really posted in CO line items table.

    Regards,

    Paulo

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Krishna,

      Even in summary tables there always will be the Period field, no need to derive it from a Posting date.  From performance perspective it is always better to use summary tables when possible.

      Have a look at this discussion:

      Regards,

      Paulo

  • avatar image
    Former Member
    Oct 23, 2015 at 04:40 PM

    Ok..I think its not as simple as its below, but this is what I found based your all your suggestions..

    Start with the WBS and find all the child WBS for it

    Then go to AFVC-PROJN with those WBS and get all activity and activity elements from AFVC- OBJNR

    Take that OBJNR to COEP and get your actual quantities(hours)  from MEGBTR or MBGBTR ( not sure the difference between these two- both seem to have quantities captured)

    It might be bit more complex logic finally but I think that's the way.

    Thanks,

    Krishna

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 05:34 PM

    Hi Krishna,

    Check CATSDB or CATSPS

    Regards

    Terence

    Add comment
    10|10000 characters needed characters exceeded