Show TOC

Exceptions concerning segment-level characteristics

Exceptions concerning segment-level characteristics

The aim of this function is to reduce the quantity of profitability segments generated. This is achieved by only updating in detail those values that are also relevant for running an analysis. You specify an exception for a characteristic that you generally do not wish to be involved in the creation of profitability segments. In the exception, you define the conditions (in other words, you specify the characteristic values) dictating when the characteristic should be not be included among the segment-level characteristics.

In this way, it is possible for an engineering company to arrange for the heavy machinery division to be updated at the detailed product level, while the spare parts division is updated at a higher level, that of the product group. In this example, the characteristic for which the exception is defined is the product. It is hidden when the division receives the characteristic value spare parts.

Another useful example of how an exception can be applied is the distinction between key customers and other customers. It makes sense to analyze and update key customers at the detailed customer level, whereas other customers can be summarized at the customer group level.

When the exception is applied, the number of profitability segments generated is reduced, thereby improving performance in reporting and in the system in general. However, to ensure that system performance is actually enhanced, you should use this function sparingly and only use it in specific cases. Once applied in a productive system, an exception should no longer be changed, because changes to it would cause inconsistencies in your data, especially if you remove an exception and thereby include the corresponding characteristic in the creation of profitability segments.

It is essential that you apply the following rules when using this function:

Characteristics that are hidden due to an exception are still updated in the line item table (CE1xxxx). Furthermore, they remain visible when you display the line items with the current structure.

If a line item contains such a characteristic, the system always accesses the line item list to display the line items.

This is equally the case if you call up the line item display from a profitability report with the current structure. In the profitability report, the affected characteristic has the value "initial" because the report accesses the segment level (CE4xxxx).

This value is also used to select the line item. Since a value for the characteristic exists in the line item table, the system cannot find the correct line item.
You can circumvent this problem by calling up the function Goto -> Line Item at a higher expansion level in the report. In this way, the hidden characteristic is not selected.

Examples of typical uses

1. Hiding all products in the spare parts division

As in the case described above, an engineering company produces large machinery to order but also sells spare parts. Detailed analyses at the product level are only necessary for heavy machinery. The operating concern contains the divisions heavy machinery and spare parts that are determined by appropriately defined derivation steps.

In this case, an exception is defined for the characteristic product . Depending on the type of profitability analysis used, this involves setting the Costing-based or Costing-/Acct-based indicator and selecting the Exceptions pushbutton. In the following screen, the condition for hiding the data is specified: when the characteristic Division takes the value Spare parts.

2. Hiding "other customers" by defining the new characteristic Key customer indicator

A repetitive manufacturer does not want to analyze all their data at the customer level. Instead, only a selection of key customers should be looked at in detail. However, there is no characteristic in the operating concern that makes any such distinction. Not only is it not possible to define an exception along the lines of "Hide characteristic "Customer" when customer = A and customer = B and ...", but this would not be practical either. Hence a new characteristic - with which a distinction can be made between key customers and other customers - needs to be created. It is possible, for example, to define an additional characteristic Key customer indicator and then, by means of characteristic derivation, to set it to X for the key customers and leave it empty for all other customers. For data that has already been posted, it is necessary to run a realignment during which these other customers are set to the initial value. The following exception can then be defined: The characteristic "Customer" is hidden when the key customer indicator = initial (for the initial characteristic value, enter # in the entry field). Once this exception has been applied, no further analysis can be run on the other customers at the customer level because the exception cannot be canceled.