Displaying Profitability Reports 

You can display the rebate data in the profitability report. However, before you do that, the following provides you with an overview of the single line items that were transferred to Profitability Analysis and whose data you can call up with the different views in Reporting.

Product hierarchy 2

Customer

Article

Rebate provisions

Rebate payments

Difference

0011000105 Gloss paint

6002

Y-352

500

3000

-55 (actual rebate is greater than provision)

 

6006

Y-353

2000

    

0011000110 primer

6002

CH_5103

490

595

+238 (actual rebate is smaller than provision)

 

6006

CH_5103

343

    

Total

    

3333

3595

- 312

 

  1. On the SAP R/3 System screen, select Accounting ® Controlling ® Profitability analysis.
  2. On the Profitability Analysis screen, select Information system ® Execute report.

    3. If this is the first time you are carrying out a profitability analysis transaction, the R/3 System displays the Set Operating Concern dialog box.

    Complete the input fields:

    Field

    Data

    Operating concern

    IDEA

    Type of Profit. Analysis

    costing-based

    Confirm your entries.

    This dialog box will only be displayed once during the scenario. Once you have made this selection, the R/3 System automatically selects the correct operating concern and profit analysis type.

  3. On the Run Profitability Report: Initial Screen , enter the following information:

    4. Field

    		    

    Reports

    IDES-170

    Rebate

  4. Select Execute.

    5. The IDES-170: Volume-based Rebate should display the parameters from the report. If this isn’t the case, enter the following data:

    Field

    Data

    Description

    Period from

    Current month

    		  

    Period to

    Current month

    		  

    Plan/act. ind.

    0

    Actual data

    Version

    Leave blank

    		  

    Record type

    F

    Billing data

  5. Select Execute.

    6. In the top line of the Execute Drilldown Report "IDES-170": Drilldown list , you can see that sales organization 1020 and distribution channel 20 have been determined for this report. You can page through the other characteristics as you require. The value fields displayed are for the billing quantity, revenue and rebate value.

    For more information about the functions in Reporting, see Executing an Existing Report in CO-PA and Getting to Know Reporting Functions.

  6. The first characteristic that you can navigate freely is the division, which is division 03 (paints). To select it, double-click and the R/3 System displays product hierarchy 1. The total value of the rebate payments equals 3.595,-- DM.
  7. Double-click on line 00110 (paints) to view product hierarchy 2, where you can see how it is divided between gloss paints (article Y-352 and Y-353) and primer (article CH_5103). In the Rebate value field, you can see the amounts that were paid out as rebates (3.000,--DM + 595,--DM).
  8. Double-click on line 0011000110 primers to see an overview of the articles in this product hierarchy. Article CH_5103 is the finished product that was sold and 178 is the settlement material for this product hierarchy. The 833,-- DM corresponds to the provision value for article CH_5103 (490,--DM + 343,-- DM), while the 238.--DM corresponds to the difference posted between the rebate provision and the rebate payment, leading to a reduced payment amount for product hierarchy 2 to 595,-- DM.
  9. Double-click on article CH_5103 to see an overview of the customers in the RIWA company that ordered this article (the amounts mentioned in the previous step for 490,-- DM + 343,-- DM combine).
  10. Double-click on customer 6002 where you can see that product hierarchy 3 is assigned to article CH_5103.
  11. Go back two steps to reach the article display again. Double-click on settlement material 178. The customer is the central office with customer number 6000. The difference between the rebate provision and rebate payment has been offset for this customer, which gives rise to a difference amount of 238,-- DM.
  12. Double-click on this customer where you can see that product hierarchy 3 has not been assigned to the article because the settlement material is only defined for up to product hierarchy 2.

    13. You can see the product hierarchy for gloss paints in the same way by going back three steps and implementing steps 7 - 11 for product hierarchy 0011000105.

  13. Leave the report by selecting Cancel. Confirm the Exit Report dialog box with Yes.
  14. Return to the SAP R/3 System screen.

End of the process chain.