Entering content frameConceptual documentation User Exit: Elimination of Internal Business Volume Locate the document in its SAP Library structure

A user exit is available to enable an elimination of internal business volume in drilldown reporting. With this enhancement you can, for example, eliminate the turnover between characteristic values (for example, between sender company and receiver company) on the basis of rules in the user exit.

Setting up the User Exit

The user exit can be called up from the SAP menu under Tools ® ABAP-Workbench ® Utilities ® Enhancements ® Project management ® Utilities ® SAP Enhancements.

  1. Enter the name KKDR0002 in the field Enhancement and select Program ® Execute.

    2. The name of the enhancement is displayed.

  2. Position the cursor on the enhancement name and choose Edit ®
    Components +/-    . The available enhancement components are displayed.

    3. Position the cursor on the line "Technical name of the enhancement is displayed.

  3. Position the cursor on the line "Drilldown user EIS: Elimination of Internal Business Volume" and select Edit ® Display SAP Docu.

Here you will find the necessary technical information to set up an exit, and a note about example coding.

Rules for Elimination of Internal Business Volume

There are four different rules for elimination in the user exit. These can be used individually or in conjunction with one another. The rules are explained in the following section. The technical formula and an example are given for each rule:

  1. The characteristic values in the sender and receiver data records are identical.

    2. Formula notation: Data record (sender) = Data record (receiver)

    If, for example, company X sells to itself, no revenue is generated from an external point of view. This value will be eliminated in the report according to rule 1.

    Sender

    Receiver

    Amount

    Result

    X

    X

    50,-

    is eliminated

           

  2. The sender characteristic value in the report cell is the same as the receiver characteristic value in the data record.

    3. Formula notation: Report cell (sender) ® = ® Characteristic value ® = ® Data record (receiver)

    If the sender characteristic value in a certain cell of the report agrees with the receiver characteristic value in the data record then the value is eliminated in the report.

    Rule 2 is normally used in conjunction with rule 3. See Example of Elimination with Rules 2 and 3.

  3. The sender characteristic in the cell is not fixed.

    4. Formula notation: Report cell (sender) = ® *

    If the sender characteristic is not specified in the cell, the value of the key figure is eliminated in the cell.

    Rule 3 is dependent on the current drilldown level. It is normally only meaningful when used in conjunction with another rule. Otherwise elimination is usually carried out entirely or not at all in a whole column depending on the current drilldown characteristic. See Example of Elimination with Rules 2 and 3.

  4. The sender characteristic value in the report cell is the parent node of the receiver characteristic value in the data record.

Formula notation: ® Report cell (sender) ® = ® Node ® = ® Parent of data record (receiver)

In a master data hierarchy, the characteristic values A1 and A2, for example, are subordinate to characteristic value A. Characteristic value A1 achieves a revenue of 200 DM in a business transaction with characteristic value A2. From the point of view of characteristic value A1 external revenue was achieved, but from the point of view of characteristic value A however, the business transaction was internal. The amount is eliminated in cell A. See Example of Elimination with Rule 4.

When do I use which Rule?

Rule 4 is mostly used in reports which display a master data hierarchy,. This rule eliminates along a master data hierarchy.

If the hierarchy of the characteristic values is set up in the database, you should use a combination of rules 2 and 3.

Setting Elimination Conditions

The elimination rules can either be used individually or in conjunction with others. They can be switched on for either a single characteristic pair (for example, sender company and receiver company) or for several characteristic pairs. It also possible to form various combinations of rules and characteristic pairs.

Maintaining Simple Conditions

By simple conditions we mean a single combination of rules(s) and characteristic pair(s), which determine the elimination.

Example

Elimination of the key figure Ext. revenue according to rule 4 for the characteristic pair Company.

The first step when maintaining an elimination condition is the selection of the key figure to be eliminated. This should be a formula key figure defined for the elimination, for example, EXREVEN = REVEN.

Then you must decide for which characteristic pair or pairs the values are to be eliminated. A characteristic pair consists of a sender characteristic value and a receiver characteristic value, for example, sender company and receiver company.

In the third step, you select the rule to execute the elimination with. You summarize this data in an elimination group

If you enter more than one rule, the system checks whether at least one rule, for example rule 2 or 3 has been fulfilled at time of execution of the report. This is because rules are combined in a simple condition using ‘OR’.

Maintaining Complex Conditions

Example

You wish to eliminate according to rule 2 or 3 for the characteristic pair "Company", but only if rule 2 or 3 is fulfilled for the characteristic pair "Profit Center".

The following graphic should clarify the relationship between the elements of this elimination group.

This graphic is explained in the accompanying text

In this example, the key figure EXREVEN is assigned to the elimination group 1. Within this elimination group there are two subgroups, one for the characteristic pair "Company" and one for the characteristic pair "Profit Center". Two rules are assigned to each subgroup. In this example these are rules 2 and 3.

According to this condition, an elimination is only made when at least one rule in both subgroups is fulfilled:

Subgroup 1

Company:

 

 

Subgroup 2

Profit center

(Rule 2 OR rule 3)

AND

(Rule 2 OR rule 3)

 

When executing a report the system checks in each cell whether rule 2 or rule 3 is fulfilled for the characteristic pair "Company". Then it checks if rule 2 or 3 is fulfilled for the characteristic pair "Profit Center". If at least one rule is fulfilled in each subgroup then the value of the affected cell is eliminated in the report. See also Example of Elimination with Rules 2 and 3.

By a complex condition we mean several simple conditions which, in conjunction with each other, determine the elimination. From a technical point of view, the simple conditions are combined with a logical ‘AND’. If you want to connect these conditions using ‘AND’, you must assign each simple condition to a subgroup.

A subgroup consists of one simple condition, which is one or more characteristic pairs and their corresponding rule(s). All subgroups to be evaluated in conjunction with one another make up an elimination group.

Within a subgroup the rules are connected by ‘OR’, so when executing a report the system checks whether at least one condition is fulfilled. The various subgroups are connected by ‘AND’. This means that the system only eliminates the affected value when at least one condition is fulfilled in all subgroups of an elimination group.

 

 

 

 

Leaving content frame