Skip to Content
avatar image
Former Member

History of activity rates?

I'm creating an ALV report which shows activity by period. The column on the left is essentially the secondary cost element. It joins several tables (COKA, PRPS, PROJ, CSKS, CSU), but the amounts come from COSS. I think these amounts are correct.

The user wants a drill-down to see the detail (in dollars). The period is a month; the activity is loaded weekly, so I would need to show 4 weeks of activity. I know the hours within the period are stored in AFRU. Can someone tell me where the activity rate is stored for those hours?

Thanks for your help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 29, 2011 at 03:24 PM

    Hi,

    The activity rates are maintained in KP26 transaction and it is normally maintained for a combination of "Cost Centre" and "Activity Type". You can see the same in COST table.

    Regards

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sreekanth,

      Thank you. I think that the document(s) may be stored in COBK/COEJ.

      Based on your response, I saw that when I tried extras--->line items, it listed document numbers. Did a little digging and found that COBK is the document header, which will have the posting date, and that COEJ contains the detail.

      Now I have to figure out how to relate this back to when the user clicks on a gl/acct and period/year, how to know which detail it relates to.

      I awarded you partial points for pointing me in the right direction. Thank you.