Customizing for Setting Up Ratios 

Use

The following steps let you look at the Customizing settings that need to be made in order for you to use ratios and ratio schemes in planning. You do not need to change these settings.

Procedure

  1. Call up the transaction as follows:
    2.

    Menu Path

    Tools ® AcceleratedSAP ® Customizing ® Edit Projects.

    Transaction Code

    SPRO; KE1L

  2. Choose SAP Reference IMG.
  3. Call up the transaction as follows:
    4.

    Menu Path

    Controlling ® Profitability Analysis ® Planning ® Planning Aids ® Define Ratios and Ratio Schemes

    Transaction Code

    KE1I

  4. In the dialog box, enter the following data:
    5.

    Field

    Data

    Operating concern

    IDEA

    Type of Profit. Analysis

    costing-based

  5. Choose .

    6. You see the ratios that have been defined thus far.

    The ratio ERL represents the formula "revenue divided by sales quantity". Value field VV010 (revenue) is the numerator and value field VVIQT (invoiced quantity) is the denominator. The ratio ES represents the sales deductions, while HK shows the cost of goods manufactured.

    These ratios are defined as follows:

    Sales revenue / Quantity = Price per unit

    Customer discount / Quantity = Sales deductions per unit

    Cost of goods mfd / Quantity = Cost of goods mfd per unit

    These ratios must be assigned to access-level characteristics, which define the level at which the values should be stored (the sales organization, customer, and product, in this example).

    The three ratios with a "1" on the end represent the same as the above three ratios, except that they are assigned to the access-level characteristics "Sales organization" and "Material group". Prices are calculated as the average prices at the material group level instead of per customer and product in one sales organization.

  6. Select the row of ratio ERL, then double-click on Ratio Schemes.

    7. You see that various schemes have already been defined. Scheme PPDB defines the prices at the customer/product level, while scheme PPDG defines them at the material group level.

  7. Select the row of ratio scheme PPDB, then double-click Assign Ratio.

    8. You see the ratios that have been assigned to this scheme.

  8. Select the row of No.10, then double-click Assign access-level characteristics.

    9. The System shows you the levels at which these ratios are to be calculated.

  9. Choose until the overview tree appears.