Creating a Report with a New Hierarchy 

  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

    Hierarchy

    Name

    Sales region

    Basic report

    Selected

  3. Choose Create.
  4. In the dialog box, select Operating concern currency.
  5. Choose .

    6. You are now in the Characteristics tab page.

  6. In the Characteristic list, select Country+Region and Sales organization.
  7. Choose .
  8. To display the sequence in which the characteristics are to appear in the report, choose Sort user-def. char.

    9. Ensure that the characteristics in the Sort characteristics dialog box are listed in the following order: (1) Sales org. and (2) Country+Region. Correct the sequence, if required.

  9. Choose .
  10. Enter the following data:
    11.

    Field

    Data

    Sales org. / value

    1000

  11. Choose the Key figures tab page.
  12. In the Available key figures area, select the Revenues key figure.
  13. Choose .
  14. Choose the Variables tab page.
  15. Enter the following data:
    16.

    Field

    Data

    Period from

    001 current year

    To period

    Current period, current year

    Plan/act.ind.

    0 (actual data)

    Version

    		  

    Record type

    F

  16. Choose the Output type tab page.
  17. Under record type, select Classic drilldown.
  18. Choose the Options tab page.
  19. In the Performance section, enter the following data:
    20.

    Field

    Data

    Display current data

    Select

    Execute report

    Select

  20. Choose .
  21. In the Choose hierarchy: screen, use the possible entries function to select the hierarchy you defined under Hierarchy, then choose .
  22. On the Create Profitability Report: Initial Screen, choose .

    23. The system proposes the variables entered during report definition.

  23. Without changing the variables, choose .

    24. The report shows you the planned sales in Germany for sales organization 1000.

  24. Choose the plus sign in front of Nonassigned (x).

    25. The characteristic values that were not defined in the hierarchy are also displayed. Depending on the sales orders, sales revenue coming from US customers who ordered in Germany, for example, are then displayed in this way.

  25. You can navigate in this report as described in the step Displaying a Report with the Characteristics Hierarchy.
  26. Choose .
  27. In the dialog box, choose Yes.
  28. Choose until the overview tree appears.