Skip to Content

Report-to-Report interface variables

Hi Experts,

I have the following requirement:

I need to create a report, which displays all General Ledger accounts for a selected year. It should also be possible to drill-down on line item level.

The problem is that those two are based on two different DataSources – 0FI_GL_6 for General Ledger Transactions Figures and 0FI_GL_4 for direct line items.

Using the new GL DataSources 0FI_GL_14 is not an option.

Anyways, long story short: we decided to implement a report-to-report solution.

I created a simple example with two flat files (the data is completely made up).

First, there is the accounts query:

Now I filter to the data of the year 2014 with “keep value on axis”. Afterwards I right click on an account and jump to the Line Item Query:

At the Line Item Query it shows me the data for the specific account I selected for all years:

So far so good, but here is the issue:

If I filter on the year 2014, I just want him to show me the data from 2012 to 2014.

How can I realize that?

In BW on the Report-to-Report settings (T-Code RSBBS) I selected to delete Calendar year. If I don’t do this it automatically filters the Line Items to 2014 only. However, I want the period 2012 to 2014.

At the field assignments, I already saw that you are able to set a variable:

What should I type in for the field name? How do I have to configure it that it only select the years after the filtered year?

one.png (78.5 kB)
two.png (57.1 kB)
three.png (87.2 kB)
four.png (47.7 kB)
five.png (17.5 kB)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Mar 07, 2017 at 09:40 AM

    I found a solution for this problem:

    You have to define the variable in the Query of the Line Items (in the Query Designer). So that the Line Item Query has a variable that filters the years from the first year (in this case 2012) until the selected year.

    When you now jump with your report-to-report interface to the other query it automatically gets the selected year and filters it.

    You don't have to anything in the field assignments.

    Add comment
    10|10000 characters needed characters exceeded