With this function you can eliminate the internal business volume by executing a BEx query. Internal business volume is then no longer displayed in the report.

You have an InfoProvider that contains two InfoObjects (sender and receiver) that have the same master data.

To eliminate internal business volume in an InfoProvider, you have to create a key figure with a reference. You then include these in the InfoProvider.

When creating a key figure, you can also select Key Figure with Reference. In the InfoObject maintenance you have an additional tab page, Elimination. Enter one or more characteristic pairs here regarding the key figure to be eliminated. The characteristics of such a pair must have the same reference characteristic. You can also enter the names of the navigation attributes here.

You can display permitted characteristics for an elimination characteristic by using the input help.

If several characteristic pairs are maintained, you still have to specify one of the following, using the selection buttons:

• all characteristic pairs need to be eliminated (then the key figure value is only eliminated if the elimination condition described above is fulfilled for all characteristic pairs)
• each individual characteristic pair needs to be eliminated (then the key figure value is already eliminated as soon as the elimination condition for a characteristic pair is fulfilled)

A typical application would be eliminating hierarchies. For example, if the sender characteristic is not restricted and drilled down with a hierarchy (while the receiver characteristic is restricted in the filter at the same time), then the key figure for a row with a hierarchy node is eliminated. This happens exactly when the value of the receiver characteristic is also in the hierarchy node and when the sender value is in the filter of the receiver.

Characteristic pairs, such as ‘Sent Cost Center’ (0SEND_CCTR) and ‘Received Cost Center’, are eliminated as follows:

A specific cell is viewed in the report. This has a selection S for the sender characteristic ‘Sent Cost Center’ and a selection E for the receiver characteristic ‘Received Cost Center’. These selections are made of the global filter, the dynamic filter, and the cells, as well as the column definition of the cell.

For all InfoProvider data records that qualify to be valid for this cell_ The characteristic value ‘Sent Cost Center’ is included in selection S, while the characteristic value ‘Received Cost Center’ is included in selection R. The key figure value for this data record is only then eliminated if the record were also to qualify for the cell when swapping the sender and receiver. This means if the characteristic value ‘Sent Cost Center’ is included in selection R and the characteristic value ‘Received Cost Center’ in selection S.