Skip to Content
Author's profile photo Kamal Kumar

Workbook adaptation for cost-driven planning in SAP Commercial Project Management

Motivation

A project planner is concerned about cost-driven planning. Hence the user wants to see only related key figures such as Quantity and Cost.

Solution

One can use the following approaches to achieve this:

  1. Create a new BW query and replace the standard query in the workbook.
  2. Adjust the existing query in the workbook.

Please refer to the standard RDS document for information about the first solution approach.

The second solution approach is explained below:

  1. Launch the standard workbook that you want to adjust.
  2. Select any cell of crosstab2 (cell A8 in screenshot) and click on Display button in the Analysis tab.
    1_screen.JPG
  3. In the Columns section, select Measures.
  4. Right-click and filter by member.
    2_SCREEN.png
  5. Deselect Revenue and Margin.
    3_SCREEN.JPG
  6. Double-click on a structure element (for example, cell A13 in the screenshot)
    4_screen.JPG
  7. Select cell G21 to view the properties of this query in the display panel.
  8. Repeat steps 3, 4, and 5.
  9. Delete the value of cell H21.
  10. Save the workbook using the instructions in the SAP note 1985150.

The above solution results in the removal of revenue-related key figures from the workbook. However, the standard valuation still performs calculation of both cost and revenue.  If you want to perform valuation only for cost, follow the instructions given below.

(Optional) Steps to Adjust Valuation

  1. Launch transaction SPRO and navigate to the Customizing node SAP Commercial Project Management -> Project Cost and Revenue Planning -> Project Valuation -> Define Valuation Strategies.
  2. Copy the standard valuation strategy (0STRTG_KP26_MONTHLY) to a new entry (for example, ZSTRTG_KP26_MONTHLY).
  3. Select the new strategy and click on node Assigned Valuation Method.
  4. Remove entries 0REV_RATE and 0VAL_FUNC_CALC_REV (sequence 4).
    /wp-content/uploads/2015/10/5_screen_818563.png
  5. Assign the new strategy to your plan scenario, in the Customizing path SAP Commercial Project Management -> Project Cost and Revenue -> Define Plan Scenarios.
    /wp-content/uploads/2015/10/6_screen_818579.png

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo amit mishra
      amit mishra

      Thanks Kamal its really very helpful... Have a question as well . is it is possible that we can use custom Workbook as well because on our case client make quotation based on different item he buy from other vendors, mean to say to complete project he has to buy N no of item from N no of vendor. so if we can make vendor as a one column  then in a  single quotation we can compare by which combination I can give best quotation to my customer..

      Author's profile photo Kamal Kumar
      Kamal Kumar
      Blog Post Author

      Hello Amit,

      Thanks for the feedback!

      Yes, It is possible to use custom workbook as per your requirement.

      Best Regards,

      Kamal

      Author's profile photo Former Member
      Former Member

      Dear Kamal,

      I followed your solution, I removed the Revenue columns,the workbook is getting saved. but when I reopen the workbook  I see the Revenue columns. It seems the changes are getting removed automatically. Please let me know the possible solution for this

      Author's profile photo Kamal Kumar
      Kamal Kumar
      Blog Post Author

      Hello,

      Could you specify the Analysis office and CPm version used?
      Regards,

      Kamal

      Author's profile photo Former Member
      Former Member

      Hi,

      Analysis office version is 2.3.1 and CPM Version is 1.0 SP09

      Author's profile photo Kamal Kumar
      Kamal Kumar
      Blog Post Author

      Hi,

      It is working fine for me. you could uncheck the  "Reset datasource option", and see.

      regards,

      Kamal