Skip to Content

SAP Results Analysis for Beginners:

When I was picking up Project systems skills, Results Analysis was one of my challenging areas to understand. In this document, I tried to explain RA in a simpler manner with Professional services scenario.

Why Results Analysis?

In any customer projects with more lead time (at least 3 months), RA plays an important role. Results Analysis is to valuate ongoing unfinished activities, in projects during period-end.

If you look at profit and loss of such ongoing unfinished activities, you will see costs only and therefore your P&L shows loss. If you look at this in the period-end, the project’s ongoing activities will have an unfavorable effect on the company’s results. Accurate, timely recognition of project profitability, for each project, for every period end, is very important in any company.

SAP Results Analysis is used to show a more realistic view of your ongoing activities by capitalizing the value added so far in the balance sheet.

How to capitalize?

SAP has supplied fifteen RA methods as standard. Results analysis methods contain the rule for calculating the results analysis data. These methods will help you to capitalize the costs/revenue.

Professional Services Scenario:

Consulting, audit & tax, legal, and IT services businesses use professional services scenario in SAP. This would efficiently manage people, client relationships, maximize resource utilization, improve project and operational efficiency, drive profitability and adhere to government regulatory requirements.

Method 3 – Cost based Percentage of Completion (POC) method:

In this document we will look into Method 3 – Cost based Percentage of Completion (POC) method.  This method is primarily used in large customer projects and is used to capitalize revenue instead of costs. With this method, you assume that the costs incurred to a project will lead to an amount of revenue equal to the costs. For example, if you realize 15% of your percentage of completion, you will capitalize 15% of your planned revenue. This enables you to report a profit before any revenue has actually been received. Some countries will not allow unrealized profits to be reported. Legal requirements in different countries stipulate that unrealized profits can be capitalized or that they cannot be capitalized.

How RA Method – 03 works?

The following are the parameters used to calculate:

  1. Planned Revenue
  2. Actual Revenue
  3. Planned Costs
  4. Actual Costs

Output parameters:

  1. Calculated Costs (Cost of Sales)
  2. Calculated Revenue
  3. Revenue Surplus (Reserves for unrealized costs). ( In SD Revenue Recognition term this is called Deferred Revenue)
  4. Revenue in Excess Billing (Capitalized costs (WIP)). (In SD Revenue Recognition term this is called Unbilled receivables)

In this method, system has to calculate Percentage of Completion (POC) based on planned costs and Actual costs.

Percentage of Completion (POC) = Actual Costs / Planned Costs

1. Calculated Costs = POC X Planned costs

                                  = (Actual costs / Planned Costs) X Planned Costs

                                  = Actual costs

Therefore, in this method, Calculated Costs (Cost of sales) will be always Actual Costs.

2. Calculated Revenue = POC X Planned Revenue

                                        = (Actual Costs / Planned Costs) X Planned Revenue

If Actual Revenue > Calculated Revenue

System creates Revenue Surplus

3. Revenue Surplus = Actual Revenue – Calculated Revenue

If Actual Revenue < Calculated Revenue

System creates Revenue in Excess Billing

4. Revenue in Excess Billing = Calculated Revenue – Actual Revenue

———————————————————————————————————————————–

Now let us take an Example. I have taken a happy path where there is no loss in the project.

A project with sales contract is created with planned revenue $ 100. You plan labor and service costs in the project for $80.  Assume, the project will have lead time of 4 months (periods).

In the first period, few services were performed in the project and therefore the actual costs $20 incurred in the project. No invoice was raised to the customer.


RA-1.jpg

Although NO revenue is received, Profit has already been capitalized. This is the specialty of this method.

—————————————————————————————————————————————————————-

In the period 2, you send an invoice of $40 to your customer and also your actual costs in the project increased to $40.


RA-2.jpg

Profit is capitalized during this period.

—————————————————————————————————————————————————-

In the period 3, you send another invoice of $40 to your customer and actual costs increased to $60.

RA-3.jpg

—————————————————————————————————————————————————-

In period 4, you complete the project technically and send the final invoice to your customer.

Total actual costs incurred is $80 and total invoiced amount is $100.

RA-4.jpg

Based on this method, you can learn other methods easily. Hope, I have explained you simply.

Enjoy SAP..

To report this post you need to login first.

32 Comments

You must be Logged on to comment or reply to a post.

  1. Saurabh Tiwari

    Dear Srinivasan,

    I really enjoyed reading this document of yours. Earlier it used to be my dry area in PS but now it has cleared my many doubts on RA.

    The only few doubts here is,how down-payments are handled with this method? And if there is a return on delivery then how it will impact on RA calculation?

    And what if the project goes on Loss side?

    It would add great value to this learning if you can support it by providing/creating a new document on its mapping(configuration setting) in SAP.

    Also, please let us know which are the mostly used RA methods across industries and which is the most recommended method.

    Many thanks for such a wonderful document. Really enjoyed seeing those handwritten practice of concepts on paper. Reminds us of those academic days where we use to prove every algorithm while learning a new concept. 🙂 😀

    Thanks & Regards

    Saurabh

    (0) 
    1. Srinivasan Desingh Post author

      Hi Saurabh,

      Thanks for your comment.

      I don’t want to include many concepts and complicate this document. That is the reason I have mentioned ‘Happy Path’.

      If loss is incurred in the project, then another parameter called ‘Reserves for Imminent loss’ will come into this concept of Results Analysis.

      I will try to write another document with config and transaction to support this document.

      It is very difficult to pinpoint a method used across industries. But most commonly used methods (according to my knowledge) are Revenue based RA with/without profit realization, Cost based POC method, Completed contract method.

      Regards

      Srinivasan Desingh

      (0) 
      1. Saurabh Tiwari

        Hi Srini,

        Waiting for yet another document from you on the said topics .

        I was thinking of Configuration because the doubt came to my mind was that How the posted GL / Group of GL are recorded in RA, How the system record individual values per area like Cost, Revenue , Deferred revenues and so on.

        Would be interesting to know about it.

        Regards

        Saurabh

        (0) 
  2. Sunil Yadav

    Hi Srini,

    Thanks for such nice explanation of RA and its Method (Cost Based POC Method).

    This Document will help all members to understand simple calculation of Values and related posting in Finance.

    Regards

    Sunil

    (0) 
  3. Víctor Manuel Vargas Yamauchi

    First, thanks for the explanation, it is very easy to understand as the method POC  works. I have a problem and I would like to help me. The problem is when the user enter a reclassification of costs, or a provision or just manually enter a value of IRIR in t code KKA2 and in subsequent periods the system no longer calculated properly. Any idea why and possible solution?

    Thanks in advance.

    Víctor

    (0) 
  4. D SINGH

    Hi Srinivasan,

    Thanks a lot.Just got very good idea  from your RA document and exploring it further.

    Thanks,

    DSP

    (0) 
  5. Methee Puegkhao

    Thanks for such a great content. One quick question. Can I get actual cost settlement as well? I just want to transfer all expense into a single G/L for P&L report

    (0) 
    1. Ken Melching

      Hello Methee,

      You can configure all costs in RA to be on one Line ID (LID) and settle on a single cost element.

      You need to understand the difference between FI (G/L) and CO (cost elements).  Settlement is a purely CO function which posts on secondary cost elements.  Are you settling to COPA?  With a single LID you would settle to COPA on a single value field.

      Ken

      (0) 
      1. Methee Puegkhao

        Hi Ken,

        Thank you for your reply. I did configure RA in my system(regarding SAP Revenue Recognition for Projects (446)). Unrealized cost and profit is calculated and posted correctly. The actual cost is not transferred from WBS to cost center as I wonder if the actual cost can be transferred out of WBS. If yes, what will happen to the next period run in case of WBS is not completed yet.

        Methee

        (0) 
        1. Ken Melching

          When you implement RA, how values are settled is controlled through the RA Cost Elements not through the original postings.

          So you have to configure the settlement Allocation structure source to include the RA Cost elements. 

          (0) 
  6. Angelique Smith

    Hi Srinivasan

    Excellent work.

    I have a one question that have been puzzling me for a while. Why would results analysis revalue postings according to the exchange rate changes? We use R\A type B (dynamic line items) and R\A category POCI. How does the exchange rate revaluation work ?  Should costs/ revenues be revalued every time the exchange rate change? Is there any way that I can switch of the automatic revaluation of the WIP during the R/A runs? My client is a service organisation that use RA type B (dynamic line items) and R\A category POCI. They do not want the costs revalued based on the daily exchange rate

    your assistance is appreciated

    Regards

    Angel

    (0) 
  7. Rahul Kulkarni

    Hello Srinivasan,

    Excellent document. Appreciate the effort of putting complex scenario in simple words.

    I tried mapping the scenario, however I have couple of questions. Your guidance will really help..

    1. During Settlement system is capitalizing both, revenue and cost.

    2. After RA from KKA2, while performing settlement of project CJ88, system is asking for settlement rule. Is it really required to give settlement rule during the tenure of the project?

    If you could share the configuration of RA Version that will really be helpful.

    Regards,

    Rahul Kulkarni

    (0) 
    1. Srinivasan Desingh Post author

      Hi Rahul,

      1. It is up to your client’s requirement, whether you want to capitalize rev or cost or both. In RA settings you have to configure accordingly.

      2. Settlement rule is must for performing CJ88 / CJ8G.

      Hope this helps.

      Thanks

      Regards

      Srini

      (0) 
  8. Denise McGough

    Do you know of a way to calculate RA on the basis of a percentage input by the user? For example, in the case of a POC contract, the user maintains a gross margin percentage of 10%. Assuming actual costs incurred to date are $50,000, RA would calculate revenue of $55,555,56.

    Actual costs / inverse of GM % = Revenue

    50,000 / .90 = 55,555.56

    Any guidance is appreciated.

    (0) 
  9. Arvind Pereira

    we have 2 keys, one RA under US GAAP and one under IFRS, customer wants to perform RA on sales orders using 2 different methods, i have 4 options now

    1. use 2 RA in one SO
    2. use 2 requirement class in one SO
    3. use 2 RA versions
    4. use 2 SOs.

    please guide me.

    Thanks

    Arvind Pereira

    (0) 
  10. THEOT Vincent

    Hi,

    Very good description, easy to understand. Thanks.

    I’m looking for a description of result analysis with usage of profit indicator P in order to try to mix revenue bases and POC cost based methods in the same WBS element?

    Did somebody have such thing ?

    Vincent

    (0) 

Leave a Reply