Skip to Content
author's profile photo
Former Member

Web App Designer: Handing over variables

Hi,

Lets say I have two reports, 1. "Sales last 5 years" and 2. "Sales this year per month". Both only require the customer number from 0CUSTOMER. The end user wants a link in the 1st report to invoke the 2nd report for the same customer. Without entering the customer number again.

How can i realize that with the WAD? I already tried the "VARIABLE_SCREEN="-command, but i didnĀ“t worked properly.

Can someone give my a hint? Thanks!

Regards,

Sebastian

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • author's profile photo
    Former Member
    Apr 22, 2004 at 01:24 PM

    You don't. You want to use tx <b>RSBBS</b> for the Report-To-Report Interface. That will allow you to define a jump query to go from query 1 to query 2 and pass customer number.

    Its documented in online" target="_blank">http://help.sap.com/">online help, and a "3.0B" target="_blank">https://websmp201.sap-ag.de/~sapidb/011000358700004677132003">3.0B Report-Report Interface" document in the BW" target="_blank">http://service.sap.com/bw/">BW section of the service marketplace under documentation

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 22, 2004 at 06:17 PM

    Hi Sebastian,

    My recommendation would be set up a jump target to the corresponding R/3 tran/screen that would display the customer details.

    Abdul

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 23, 2004 at 07:05 AM

    Hi, thanks for your help!

    I already thought about the report-2-report interface and implemented it the way you suggested. But the end user wants a link in the first report to invoke the second import without entering the customer-id again. So, how can i get the value of the variable, that stores the customer-id, to generate an URL?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 23, 2004 at 01:08 PM

    Hi,

    You can achieve this by using tabs in your web template. Using javascript behind those tabs, you can toggle between one report to another report.

    You can also hide the 1st report, when 2nd report is clicked & hide 2nd report when 1st report is clicked.

    then, coming to entering variables only once, take advantage of MELT_VARIABLES property of web tempalte with which you need to enter same variable value only once for different queries.

    You can also pass variable values from one web template to another web template (I used drop down box wrapped in a select statement with javascript coding and passed the selected value to another web template).

    this might not be straigt forward but hope it helps you to ponder for more options.

    thanks

    hari

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 26, 2004 at 10:13 AM

    Hi Hari,

    thanks for your suggestion. I read the example in the "Tips & Tricks for my SAP BI Web Applications" presentation. But: How can i toogle between the reports. As far as i understood, i always have to invoke the template that i want to see if i change the tab. And that causes excactly the same problem as before: How to give over the variables.

    I implemented my test-file with an IFRAME for the respective template, which was chosen from the tabs.

    tab1

    tab2

    tab3

    ----

    -


    ...

    ----

    -


    So if you click on one of the tab-links, you always invoke a template with target in the iframe.

    I didn´t find another way how to implement it. MAybe you can send me a code example, if you have one, to my email:

    strugholtz@cetas.de

    That would be fantastic!

    Regards,

    Sebastian

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Apr 28, 2004 at 06:38 AM

    Thanks Heike,

    everything works fine!

    Regards

    Add comment
    10|10000 characters needed characters exceeded