Skip to Content

Automatic Determination of Revenue Plan in CPM workbooks from Sales Order pricing

Hi All

For the Financial Plan ID we want the Revenue Plan to be updated from the Sales Order Pricing for the Baseline Version Monthly Planning Workbooks.

How to derive the revenue in the Monthly Planning Workbook? I have tried to execute the Valuation in the AFO Workbook but it does not work. We have assigned a standard Valuation Strategy 0STRTG_SD_MONTHLY and assigned it to the resource type.

Ideally if I see the Valuation Methods which are used for this strategy it takes care of both Revenue Rate and Quantity as well as Normal Method for SD Revenue.

What may be wrong in this set up? Can anybody please share.

As far as I understand and after raising a seperate OSS with SAP on this I changed a few configurations as mentioned below:

1. Resource Type changed to Class Material and Plan/Forecast based on Quantity

2. In the Plan Scenarios configuration assigned valuation strategy

ZZSTRTG_KP26_SD_MONTHLY which is a copy of the standard valuation strategy 0STRTG_KP26_SD_MONTHLY for the Planning Function /CPD/PFP_A02_PF08.

3. Assigned the following methods in the above Valuation Strategy in the below sequence:

ZZMETH_SD_REV (copy of the standard)
0VAL_REVRATE_QTY
0CAL_FUNC_AO_CURR_CONVER
0METH_KP26_COST
0VAL_FUNC_CALC_COST

4. The output values for pricing are mapped according to our companys needs.

5. Mapped Pricing Values for the Valuation Method ZZMETH_SD_REV accordingly and changed the Field Values to map with the present system.

I maintain the resource in the workbook with Quantity and Revenue rate to be picked up automatically from the sales pricing but then it says Valaution completed but no revenue rate is determined.

capture3.png (107.6 kB)
Add a comment
10|10000 characters needed characters exceeded

  • Hi All,

    If anybody has an input it will be great. When we analyzed from our end through the Implementation class for the valuation method for SD pricing we found that the Key Figure /CPD/FTSRATE which is the Revenue Rate to picked up from the Sales Pricing is Zero.

    In the Monthly Planning Workbook we are only feeding the Quantity. Expectation is the Revenue rate will be determined automatically. And Revenue Rate * Qty will be the Revenue Plan.

    Regards,

    Suman Misra

  • Hi All,

    Any suggestions on the above issue? Please help if somebody has worked on a similar scenario.

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.