Skip to Content
author's profile photo Former Member
Former Member

Calling an RFC (or transaction) via a URL using BSP

Hi,

I wish to be call a transaction in our BW system via a URL. ITS isn't an option with BW - but I believe there is a way to do this via Business Server Pages which can be delivered by the Web AS.

The Transaction we wish to call is RRMXP (which starts up Excel and the Bex Analyser and opens a specific workbook via a supplied parameter for Workbook ID).

We have also created an RFC wrapper (which is remote-enabled) around this transaction as I saw in one thread that BSP can only call an RFC.

Can someone give me a idea of the correct syntax for the URL.

For example purposes, let's say:

RFC = Z_RRMXP_START (Transaction = RRMXP)

Parameter = ABCDEFGHIJKLMNO1234567890. (WorkbookID)

Server = bwprod.company.com:8000

We don't wish to include a Username/password in the URL string - Instead for them either to be prompted to logon or access the Workbook via Single Sign-On.

Also, do I need up to set up any services or anything else for this to work (assuming this is possible)?

Many thanks

Adrian

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2005 at 05:20 AM

    HI Adrian,

    YOu can call your Transaction using the wrapper RFC that you have created from the BSP page using the CALL to the RFC as is normally done in ABAP.

    You would have to create a Logical destination from Transaction SM59 for your BW server using which you can call the RFC and supply the parameters as import parameters.

    If you want to call the transaction via a URL if you have your Transaction Web enabled,like by creating web template using the Web Application Designer.Thyen you can call the URl from the BSP application.

    Hope this helps,

    Regards,

    Siddhartha

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Durairaj Athavan Raja

      Thanks again Raja,

      We now have our BSP page opening an individual workbook in Excel based on a passed parameter of WorkbookId.

      We now just have to find a way to also start the BEx toolbar (with Excel) and we will have a full solution.

      Regards

      Adrian

  • Posted on Sep 26, 2005 at 05:17 AM

    Since you are working in a web application (BSP) why do you want to go for BEx analyzer. you could simply call it as webquery. the results will be shown in browser. you dont even need to create webtemplate (from web application designer).

    just construct the url and call it. let me know if you need help in constructing the url.

    sample url.

    http:// . xxx.com: /sap/bw/BEx?sap-language=EN&CMD=LDOC&INFOCUBE= &QUERY= &var_name_1= &_var_val_ext_1=

    for showing the workbooks on the BSP application, check out the following thread for a complete code sample.

    Access Workbook via Webreport

    Regards

    Raja

    Message was edited by: Durairaj Athavan Raja

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.