Skip to Content
avatar image
Former Member

Need to find cost for activity

Hi,

I am an ABAPper. I created an ALV report to show costs by period. I think this part of the report is correct. I joined tables COSS, COKA, CSKU, PRPS, PROJ. I found the cost by period in COSS. The report is sorted by the secondary cost element.

Now my user wants to "drill-down" on a period and for that period (and SCE) wants to see the detail (in dollars). I know that the individual activity is stored in AFRU, and I found a view which joins AFRU to COBK, COEP. I tried this, hoping I could get the detail, but the amounts don't match against the totals I see in COSS.

Can anyone help me? Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 26, 2011 at 01:34 PM

    Hi,

    Normally the activities are linked to WBS Elements. So using the WBS OBJNR you can get the list of activities that are linked to it from AFVC. From AFVC you take the activity OBJNR and pass the same to COSS (if it is an internal activity) or COSP (if it is a general cost or external activity) to get the plan / actual costs. Both COSS & COSP has the periodic values. Hope this helps.

    Regards

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sreekanth,

      I load activity from the external system through a different program I wrote. I use the same activity type to set the rate for each record. In addition, my client wanted me to "blend" the rates, so that in my example of $800 of straight time and $400 of overtime, (assuming an hourly employee) I would divide $1200 by 40 hrs, to get a "blended" rate of $30. I would then set the activity rate to $3 and load the hours the employee worked. Because my client wants this, I cannot change the design. Besides, it was a 'fixed bid' installation of PS, and I don't have time to rewrite the programs.

      I have limited understanding of PS (this is my first project with it), but it is my understanding that activity type only retains the current value. Is there a history of what was the type was set to (and when)? If so, then I could (re)calculate using that times the AFRU hours.

      You have told me much more than the functional analyst I'm working with, so I awarded you partial points for pointing me in the right direction. I appreciate your help.

      Regards,