Example of Elimination with Rules 2 and 3 (SAP Library - Executive Information System and Business Planning)

Example of Elimination with Rules 2 and 3

Before you look at this example you should read the section called Setting Elimination Conditions in the chapter User Exit: Elimination of Internal Business Volume. The example shown there refers to the same data as used below.

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

The following information is necessary for maintaining the user exit:

Element

Technical Name

Meaning

Elimination group

1

Subgroup

1

Sender characteristic

SCOM

Sender company

Receiver characteristic

RCOM

Receiver company

Rules

2 and 3

Key figure

EXREVEN

Ext. revenue

and

Element

Technical Name

Meaning

Elimination group

1

Subgroup

2

Sender characteristic

SPCTR

Sender profit center

Receiver characteristic

RPCTR

Receiver profit center

Rules

2 and 3

Key figure

EXREVEN

Ext. revenue

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)

In the following graphic you can see the posted data records and two pages of the report for the characteristics Sender Company, Receiver Company, Sender Profit Center and Receiver Profit Center with a comparison of the eliminated and total revenues.

This graphic is explained in the accompanying text

Using the following table, you can see which rules are fulfilled in the three rows on the first report page:

Row	Subgroup 1 (Company) Rule 2	Subgroup 1 (Company) Rule 3	Subgroup 2 (Prof.Center) Rule 2	Subgroup 2 (Prof.Center) Rule 3
X	not fulfilled	not fulfilled	not fulfilled	fulfilled
Y	fulfilled	not fulfilled	not fulfilled	fulfilled
Y2	not fulfilled	not fulfilled	not fulfilled	fulfilled

Only in row Y is a rule fulfilled for both subgroups. Let’s look more closely at the row Profit Center Y. The characteristic Sender Company is specified in the report header (A1). Therefore, rule 3 is not valid for subgroup 1. Rule 2, however, is fulfilled in this case as the sender company in the cell is identical to the receiver company in the data record. Therefore, one rule is fulfilled for subgroup 1.

Then the system checks the rules of subgroup 2. Rule 3 is valid for this cell and subgroup 2 as the Sender Profit Center is not specified. One rule from both subgroups has been fulfilled and thereby the value of cell Profit Center Y / Ext. revenue eliminated.

As the elimination using rule 3 is dependent on the drilldown level, row Profit Center Y is now drilled down in the report. On the second report page you can see that the characteristic Sender Company (A1) and the characteristic Receiver Profit Center (Y) are defined in the header. There is now an external revenue in the cell Profit Center X / Ext. revenue. This is due to the fact that, although rule 2 is fulfilled for subgroup 1 (Sender Company identical to Receiver Company), no rule is valid for subgroup 2. In this case therefore, the value is not eliminated.


Element	Technical Name	Meaning
Elimination group	1
Subgroup	1
Sender characteristic	SCOM	Sender company
Receiver characteristic	RCOM	Receiver company
Rules	2 and 3
Key figure	EXREVEN	Ext. revenue

Subgroup 1 Company:		Subgroup 2 Profit center
(Rule 2 OR rule 3)	AND	(Rule 2 OR rule 3)