Drilling Down to the Lowest Level (Including Line Item Detail) 

Use

A profitability analysis report can contain multiple levels of detail (profitability segments). The CO-PA reporting tool provides you with easy-to-use functions for navigating through the data. For example, you can move from one profitability segment to the next, deactivate a level, switch between an overview and a detail report, or display the origins of the data.

At the top of the screen, you see the company logo (IDES), which every organization can define and include in reports.

In the Navigation area (first area in the middle of the screen), you see the characteristics that were selected in the report definition. The second area in the middle of the screen displays the values for these characteristics.

At the bottom left of the screen, you see the detailed list, which displays the detailed key figures for a characteristic combination.

At the bottom right of the screen, you see the graphical display of the characteristic values. All of this display is set in report definition, see Output type.

You can set the size of individual the screen areas by using the left mouse button to move the vertical and horizontal screen bars.

 

Procedure

  1. In the second area in the middle of the screen, double-click the 01 Pumps division.
  2. Double-click the distribution channel 10, Final customer sales.

    3. You see the material groups.

    To see the characteristic values, you can select the characteristic in the Navigation area and move it to the second area on the right side using drag and drop.

  3. Move the characteristic ProdHier01-1 to the second area using drag and drop.

    4. Material Group and ProdHier change places.

  4. In the Navigation area, position your cursor on the division 01 and press the right mouse button.
  5. In the menu, choose Choose Characteristic Value.
  6. Double-click 04 Lighting.

    7. The characteristic values have been adjusted to suit the characteristics displayed. Hence you see distribution channel 12 (and no longer 10) because 12 is relevant for sales in division Lighting; the product hierarchy has also been changed.

  7. In the second area, double-click Lighting.

    8. The system displays the product hierarchy 2.

  8. Double-click bulbs .
  9. Position your cursor on the graphic, then press the right mouse button.

    10. You can change the formatting individually.

  10. In the division Cumulated Actual data;1-Sales quantity, select the row containing the value for the product L-40C.

    11. The cell is highlighted.

  11. Choose Goto ® Line Items.

    12. The system displays a warning indicating that your selection is not very specific and that it could take a while to read the line items. This is because you selected a column that spans multiple periods.

  12. Choose .

    13. The system takes you to the Display Actual Line Items: List screen. A list of all the billing line items is displayed. Selected information (e.g. posting date, user id) is displayed for each line item.

    The fields that are displayed are defined in a layout. In addition to the standard layout which you are currently displaying, you can also define additional custom layouts. These layouts can contain any information available on the CO-PA line item, including all the profitability segments and value fields.

    You now change the layout of the line item list.

  13. Choose Extras ® Change line item layout... .
  14. Select IDES-04 Cust./Mat.Values, then choose .

    15. Note that the same line items are displayed, but with different information for each line item, such as the customer and product number and selected value fields.

  15. Double-click any document number.

    16. The line item detail is displayed.

  16. Remain on this screen.