Show TOC Start of Content Area

This graphic is explained in the accompanying text Example of a BEx Query as a Receiver  Locate the document in its SAP Library structure

The following example contains two peculiarities: The queries linked using the RRI use different hierarchies, and the basic characteristic of the hierarchy in the receiver query is a compounded characteristic.

From a query on a cost element, you want to display the corresponding account. The queries are based on two different InfoCubes.

The sender query uses a hierarchy that is based on the basic characteristic cost element (0COSTELMNT). The receiver query uses a hierarchy that is based on the characteristic account number (0ACCOUNT).

Note

Hierarchies that are based on different characteristics cannot normally be transferred. However this a special case: The characteristics cost element (0COSTELMNT) and account number (0ACCOUNT) have the same key and are recognized by the system as similar characteristics whose values can be transferred to one another. The same link exists between account number (0ACCOUNT) and general ledger account (0GL_ACCOUNT). If this was not the case, the hierarchy in this example could not be transferred with the RRI.

Defining your receiver query:

As the hierarchy basic characteristic is a compounded characteristic (account number is compounded to chart of accounts), you have to create a variable for characteristic account number so that the values can be transferred correctly.

Note

If you define the query without this variable, the dynamic filter will be used and the hierarchy will be deactivated because the InfoObject is compounded.

By using this variable, which cannot be changed, the RRI can transfer the value to this variable and the display hierarchy remains active.

Create a variable with the following properties for characteristic account number:

Variable type

Characteristic value variable

Processing type

Manual entry / Default value

Variable represents

Selection option

Variable value is

Optional

Ready for input

Switched on

Changeable with query navigation

Switched off

Creating sender/receiver Assignments

Create a sender/receiver assignment for both of your queries. You do not need to maintain the assignment details.

Executing the jump

When the hierarchies for both queries are structured in the same way, the jump from the sender query to the receiver query appears as follows:

This graphic is explained in the accompanying text

When the hierarchies for both queries are structured in the same way, the jump from the sender query to the receiver query appears as follows:

This graphic is explained in the accompanying text

 

End of Content Area