Conversion ABAP Report to BSP Application

[Former Member]

Hello,

I'd like to create BSP Application based on ABAP

report developed for SAP GUI environment.

For developing easily, is some tool available ?

regards, Takayuki

[Former Member]

1- My first question.

My main attention is to give a selection screen to the user for input. The ABAP report screen is very flexible and having different options to user like(< , > => ..etc). is it possible that we can catch ABAP report selection screen in BSP as I did earlier. But if it is not possible how can I give a selection screen (like ABAP report) to user. So user input as per requirement and pass it to the ABAP program to do its normal execution ?

[athavanraja]

<b><i>is it possible that we can catch ABAP report selection screen in BSP</i></b>

no automatic way! you have to code it yourself. the only to capture that without muchcoding is using ITS (external or internal).

Regards

Raja

[Former Member]

<b><i>The only to capture that without muchcoding is using ITS (external or internal).</i></b> sorry i didn't get you. can you please exlpain how to do this.

thanks in advance Raja

[athavanraja]

If you are on WAS6.40 there is Integrated ITS (Internet transaction SERVER) else you need standalone ITS.

If you have them, then having a abap report delivered for WEB with all the selection screen everything is done without any further coding.

Tell us which version of WAS you are on. if your on WAS6.40 i can just give you the URL pattern using which you can all any transaction for web.

REegards

Raja

What happend to your other question

is it solved? if so close it

[Former Member]

yes Raja, i have WAS6.40.

so i can get the selection screen of my ABAP Report or FM from BSP.

please let me know if it is possible.

i will close my other question, working on it.

[athavanraja]

<i>i have WAS6.40.</i>

good you can use integrated ITS

<i>so i can get the selection screen of my ABAP Report or FM from BSP.</i>

this technology (ITS) enables you to call SAPGUI transaction from the web easily. to place it inside a BSP you amy put it inside a frame.

for example. try the following url.

http://<yourwas server>.<domain>.com:<port>/sap/bc/gui/sap/its/webgui/!?~transaction=se38

for the above to work. some basic steps are required for that check the following weblog

/people/durairaj.athavanraja/blog/2005/08/21/running-your-first-its-webgui-application-in-sap-netweaver-04-abap-edition--nsp

Regards

Raja

[Former Member]

Thanks Raja,

i am able to called SAP transaction (SE38) by ITS. But i need to access a <b>user clicked <u>ABAP report or FM Selection Screen</u></b> in my BSP and show reports result again in my BSP.

is it possible to give a programe name as parameter in ITS Service or URL else where....?? trigger directly pop-up Report's Selection Screen.

[guillaume-hrc]

Hi Noman,

Just so you know, it is a bit complex to "convert" ABAP Selection-screen into a BSP page (as you can see some nice examples in Thomas Jung's weblogs ;-).

I am currently trying to do a simple version of it where I get the structure and labels of the selection-screen and build it dynamically.

The Key steps are :

1. <b>Getting the structure</b> : I use the LOAD_SSCR subroutine from the standard program RSBRUNT (I have know SAP system to check the name, sorry)

2. <b>Getting the labels</b> : the READ TEXPOOL statement is quite useful !

3. <b>Building the Selection-Screen in BSP</b> : it is just looping through the structure basically. For the moment, I only handle Select-Options (for single value and interval only) and Parameter

4. <b>Passing parameters to the page responsible for the reporting</b>

5. <b>Executing & Displaying the data</b>

As far as I am concerned, I have restricted this tool to Queries, so it is quite easy to execute and get the result as a data reference.

Best regards,

Guillaume

[athavanraja]

Yes that can be done but you need a standalone ITS for that. the Integrated ITS dosent support that. (its called webrfc)

Regards

Raja

[Former Member]

Hi Raja for your solution. i have couple of Questins

I called ABAP Report from BSP (pages with Flow logic) successfully. Today I execute my BSP, now I am getting error (run time) message “TH_RES_FREE”. Even I didn’t any change in my program. This error means that Selection screen in ABAP program cause this problem. If I comment “CALL Selection-Screen ” command from ABAP report then it works fine. But I need selection screen for user input. before it’s running fine.

2- To read data from Memory and convert into html by 'WWW_HTML_FROM_LISTOBJECT' the out put is very odd, as a string. How can I edit the template 'WEBREPORTING_REPORT' to get a better look. I couldn’t find this in SE38 in my system. Please let me know is there any other way to read data from memory and get result in a good way.

To get a better result’s view, I used IMPORT itab TO it_BSP FROM MEMORY ID 'XY’, use this internal table in my Page-Layout. Build a HTML table <tr><td> by loop on internal table. Is this good approach, please guide me.

[athavanraja]

1. i have no idea about this at the moment , need to check.

2. webreporting_report template can be found from transaction SMW0.

3. the whole purpose of going this approach is to avoid change to the report program. so i f you can modify the program you can as well wrap the program code in a FM in such a way that the FM would return the result data which you can use it in your BSP as a tableview or something like that.

Regards

Raja

[thomas_jung]

If your ABAP programs are reports I have done the following in the past. I write a RFC in R/3 that accepts the input parameters for the report. I then run the report from the RFC using a SUBMIT ... EXPORTING LIST TO MEMORY. I then convert the list to HTML using SAP Function module WWW_HTML_FROM_LISTOBJECT. I return this HTML to my BSP application and output it there.

[athavanraja]

Hi,

We dont even need an RFC. Just submit the program exporting list to memory and read and convert the content to html and pass it to a variable.

Then use <%= <string containing the html> %> in the layout.

We will not have any control over it.

Sample:

submit zfr01062

using selection-set 'TEST'

exporting list to memory and return.

call function 'LIST_FROM_MEMORY'

tables

listobject = list

exceptions

not_found = 1

others = 2.

call function 'WWW_HTML_FROM_LISTOBJECT'

exporting

template_name = 'WEBREPORTING_REPORT'

tables

html = html_st

listobject = list.

clear: report_html , html_wa .

loop at html_st into html_wa.

concatenate report_html html_wa into report_html.

clear html_wa .

endloop.

You can copy 'WEBREPORTING_REPORT' template and modify to have different look and feel.

Regards

Raja

[Former Member]

None that I have seen, there are some tools that come with SEM and so that people have mentioned in this forum.

I haven't seen a tool per se but it's usually very very quick to transfer the code over that I tend not to worry about it.