Creating a Report 

Use

Once you have created the form, you can go ahead and define the report. Here you decide which levels you want to report on. You also have the option of specifying concrete values for the variables defined in the form, and can decide which value fields you want to see, if you have not already done so in the form.

Procedure

  1. Call up the transaction as follows:
    2.

    Menu Path

    Accounting ® Controlling ® Profitability Analysis ® Information System ® Define Report ® Create Profitability Report

    Transaction Code

    KE31

  2. Enter the following data:
    3.

    Field

    Data

    Report

    Any

    Report name

    Any

    Report with form

    Select

    Form

    Name of your form

  3. Select Create.
  4. The variables displayed here are those defined in the form. You can now enter characteristic values for these variables.

    5. The characteristics you choose determine how the data should be broken down or summarized in the report. You can choose characteristics both in the form and in the report definition.

  5. On the Characteristics tab page in the Char. List area, select Sales Org., Division, Distr. Channel, and Product.
  6. Choose .

    7. The selected characteristics appear in the Selected characteristics area.

  7. Select Sort user-defined chars.
  8. Make sure that the characteristics appear in the order shown in step 7. If not, change the order.
  9. Choose .
  10. Position your cursor on the Sales. Org. field.
  11. Choose .
  12. Enter the following data:
    13.

    Field

    Data

    Local variable

    1000

  13. Choose .
  14. Choose the Variables tab page.

    15. This is where you enter the variables for the report. The variables from the form created earlier or from characteristic definition have been copied over and you can enter values for them.

  15. Enter the following data:
    16.

    Field

    Data

    Sales org.

    1000

    From fiscal year

    Current year

    From period

    001

    To period

    Current period

    You can not select key figures in this report, since they are already defined in the form.

  16. Choose Extras ® Basic List... .
  17. In the dialog box, enter the following data:
    18.

    Field

    Data

    Drilldown list

    select

  18. Choose .
  19. Choose the OutputType tab page, then select Classic Drilldown.
  20. Choose the Options tab page.
  21. In the Performance area, enter the following data:
    22.

    Field

    Data

    Display current data

    select

    Execute report

    select

  22. Select .
  23. Choose until the overview tree appears.