Skip to content

Using SAP PPM to manage projects and portfolios that have a Capex/Opex split

July 25, 2012

Some people may (and often do) argue that from a project management point of view the capex/opex split is not important; it’s the project manager’s job to deliver the project on time and within budget irrespective of whether or not its capex or opex.  While this is true it is also very helpful for the portfolio manager to be able to check variances in capex AND opex budget vs. actual.  Particularly in the regulated utility industries where capex adds to the asset base and is a key reporting requirement to the regulator and opex is expensed and has a direct impact on shareholder profitability.  When balancing the selection of projects for a portfolio it would be necessary to ensure that the appropriate capex and opex spend is incurred and that the correct projects are delivered.

Within core SAP ERP it has traditionally been awkward to split capex and opex at the cost element level.   What I mean by this is that the cost element can in some cases, but does not generally, represent capex or opex.  So when consuming material, buying from 3rd parties or using internal labour the cost element that hits the cost object (order, network, etc.) doesn’t indicate if the spend is capex or opex.  It’s only on settlement that the cost is ‘marked’ as capex or opex based on the receiving object.  Cost centres (or other non-asset receivers) are opex and those settled to an asset (or an asset under construction) are capex receivers.  What some organisations do to assist in identifying capex or opex before settlement is to create either project types in PS or order types in PM to indicate whether the expense is a capital or operational cost.

Now SAP PS is being used to collect actual costs and settled to either capital cost receivers (assets or assets-under-construction) or operational cost receivers (cost centres) and the question is: can SAP PPM be used to provide a portfolio wide view of both capex and opex.  The answer is yes, but it’s tricky because the financial planning is shown by a combination of view/category/group and when feeding PPM with the costs from SAP PS the costs are characterised by, amongst other things, cost element, cost element type, version, value type, controlling area and date.  None of the characteristics specifically allow us to mark the cost as capex or opex and hence on the portfolio item we cannot report by capex or opex.  Although, from a portfolio management view, this is the requirement.

How did we do the ‘split’?  Well before the project cost  IDoc was sent to the PPM system the cost needed to be ‘marked’ as either capex or opex by manipulating one of the standard fields.  The BAPI was used to change the contents of the IDoc based on the project type that the cost was incurred on, which was either of capex or opex type.

So with the correct configuration of the view/category/group structure in PPM5.0, a small enhancement on a standard BAPI to update the generated IDoc  with a capex/opex indicator for all the costs and running the standard extract and roll-up programs, like magic, the capex/opex split will appear in the correct place within the portfolio item financial reporting.   And one last point.  This split is needed when costs come from SAP ERP (or another ERP system) but for top-down budget distribution the split is done within PPM in the correct capex or opex group.

Advertisements

From → PPM

3 Comments
  1. Kevin permalink

    Any more on this? We are running PPM 5.0 and have need of this type of functionality. Our Project group would like to split out the cost of the project according to the expense and capital portions of a project. In PS we have one Proj Def for the project, and separate sub-WBS elements for Capital and Expense portions of the project. The main reason for pulling all this into one spot in PPM is so that baseline planning, forecasting and tracking of actuals for a project can all be done in one place, allowing monthly updating to be done here. One idea has been to create separate projects for the capital and expense portions, then put these two projects togther under an initiative, but this seems to be a clunky workaround and not a true solution. Any advice?

    • Duncan permalink

      Hi Kevin – we’ve been live for 6 months with this solution – customer happy. It’s a fairly common design to have separate WBS elements for capex and opex. Agree that the other option is clunky – PPM needs to be used as a portfolio management tool. If a single portfolio item uses both capex and opex then the solution should reflect that. As mentioned in the blog we’ve done this split in the cost roll up and we can see the split in the view/cat/group on the portfolio item. You need to think about how to transition from the way you do it now to the new capex/opex split. Good luck with it, let me know how it goes – I’m on LinkedIn au.linkedin.com/in/duncanjmills/
      Cheers,
      Duncan

  2. Furstrated PM permalink

    Hi Duncan,

    That’s the first clear statement of how it’s designed that I’ve heard. (I’m not a SAP expert, but I am a project manager).

    From a theory/principle point of view I see OPEX/CAPEX as a description of the resources that are supplied to the WBS element in question.

    So I would expect that both CAPEX / OPEX type resources could be applied to the WBS element by means of a Purchase Order or something.

    Cheers,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: