PS: Custom Project Detail report, budget, actual, variance etc

[Former Member]

Hi All.

I am implementing a report that needs to display the project, all the WBS's and the activity (if there is one linked to a network which in turn linked to a WBS) on a report. The report columns include budget, planned cost,

actual cost and other fields that I can calculate if

I have the first three fields.

Does anybody know which tables I can use to get the

planned and actual costs associated with a project.

The structure of a project looks something like this:

Proj

->WBS

->Network

->Activity.

The costs are normally associated with the activity, and it "rolls" up to Proj level?

I have already found the budget values in table BPGE for

each WBS.

Another related question:

How does the activity link up with the project-

what tables can I use and how does it relate to table

PROJ or PRPS?

I appreciate any help.

Thank you

Ryno

[Former Member · Accepted solution]

Try:

* Costs
 
  call function 'K_DATE_TO_PERIOD_CONVERT'
       exporting
            i_date  = sy-datum
            i_kokrs = 'ZZZZ'
       importing
            e_gjahr = cur_year.
 
  select *
    from  pmco
    into table pmco_int
    where  objnr  = objnr
    and    cocur  = 'USD'
    and    beltp  in (1, 2)
    and    wrttp  in ('01', '04')
    and    gjahr  = cur_year.
 
  clear: est_cost,
         act_cost,
         est_rev,
         act_rev.
  loop at pmco_int.
    do varying sav_tot
        from pmco_int-wrt01
        next pmco_int-wrt02.
      if sy-index > 12.
        exit.
      endif.
      if pmco_int-beltp = '1'.
        if pmco_int-wrttp = '04'.
          act_cost_p = act_cost_p + sav_tot.
        else.
          est_cost_p = est_cost_p + sav_tot.
        endif.
      else.
        if pmco_int-wrttp = '04'.
          act_rev_p = act_rev_p + sav_tot.
        else.
          est_rev_p = est_rev_p + sav_tot.
        endif.
      endif.
    enddo.
  endloop.
 
  write     act_cost_p to act_cost_c.
  translate act_cost_c using ', '.
  condense  act_cost_c no-gaps.
  move      act_cost_c to act_cost.
  shift     act_cost   right deleting trailing space.
 
  write     est_cost_p to est_cost_c.
  translate est_cost_c using ', '.
  condense  est_cost_c no-gaps.
  move      est_cost_c to est_cost.
  shift     est_cost   right deleting trailing space.
 
  write     act_rev_p to act_rev_c.
  translate act_rev_c using ', '.
  condense  act_rev_c no-gaps.
  move      act_rev_c to act_rev.
  shift     act_rev   right deleting trailing space.
 
  write     est_rev_p to est_rev_c.
  translate est_rev_c using ', '.
  condense  est_rev_c no-gaps.
  move      est_rev_c to est_rev.
  shift     est_rev   right deleting trailing space.

Rob

[Former Member · Accepted solution]

Hi good morning.

can u send the complete coding of this program.

Thanks & regards,

Venkat

[Former Member · Accepted solution]

It's a custom program and although it deals witht the costs, it doesn't look at the budgets. So I think the code I posted will help for the cost portion, but there is nothing there for the rest of your requirements.

Rob

[andreas_mann3]

Hi,

look table rpsco: field wrttp

wrttp           description
 
41              budget 
11              (Statistical)actual
22              Purchase Order Commitment

___

disposable = 41 -11 - 22.

and look to this link :

regards Andreas

[former_member181962]

HI Ryno,

Check the tables COEP COEJ Chcek all coe tables in se11).

Also check BPGE table.

Regards,

Ravi