cancel
Showing results for 
Search instead for 
Did you mean: 

RFC to display MSDS reports

Former Member
0 Kudos

Hi,

We are trying to set up a website to query and display MSDS reports from SAP. One RFC is to return hitlist from web query, and the second RFC is to display the specific report upon clicking an icon/link. Can I use this function module C12H_WWI_DISPLAY_DIRECT in the RFC to display the report? Will it work or is there a better way to do this?

Thanks,

David

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi David,

first of all, I have to say that I am not an expert with WebGUIs.

Second, the task you have at hand is already developed by my GLM team. We offer a web interface for all sorts of reports (including MSDS) as a predefined service. I developed the latest version of it and I'd be happy to give you a demo if you want.

The technique behind it is a search for the MSDS on the SAP site and a RFC communication using the SAP Java Connector library to the webserver

http://help.sap.com/saphelp_dm40/helpdata/de/6f/1bd5c6a85b11d6b28500508b5d5211/content.htm

The advantage is that you are able to set up a slim and fast JSP site which is easily included in every existing web platform. If you go through the documentation you can set up an easy application within a few days.

The other very easy way to get data from SAP into your browser could be to use the framework of Success Factors. I saw a lecture recently how to develop an easy HTML5 app. That could maybe be abused for your purpose.

cheers

J

Former Member
0 Kudos

Thanks, I'll look into the SAP Jave Connector.

Anyone has info on EHS Web Interface?

christoph_bergemann
Active Contributor
0 Kudos

Dear David

i am no sure but I believe Julian is referring to the "EHS Web Interface" (or the servive/product which is now shipped by SAP). This product / service was part of TechnIData portfolio before the aquisition of TechnIData by SAP.

In principle you have a number of options to go on:

a.) use solution by SAP (I do not now it exactly) as proposed by Julian

b.) try to use the proposal fo Kamal

Without insight in the SAP solution as mentioned by Julian:

What are the demands of the customer today in using internet?

My answer would be: preferred would be to get SDS as pdf in a short time. Now if you prepare a set up with "dynamic" call of WWI servers using the information as entered in the portal you will generate on the fly either RTF or you will get the pdf as a result. This process must be used any time. Any use of the portal will lead to traffic in SAP EH&S system. Therefore if you use e.g. report distribution with EXP_CALL directly generating any PDF file and storing that somethere with some key information (e.g. material number, language etc.) you can pass back in WebGui (User Interface) direct the pdf without use of WWI servers. Here you need no SAP EH&S system, you need not any WWI server etc.

A new final report is only generated if a new version is released by user. You need some adaptions of SDS distrubation process so that not only major versions of SDS are supported.

C.B.

0 Kudos

Yep, I've been talking about the EHS web interface.

As said before, if you are interested in it, I can give you a quick online demo of the newest version. Maybe that would answer a lot of your questions.

As Christoph explained, the MSDS are searched on live data and then generated on the fly on the WWI server. For inbound MSDS, this of course does not apply.

Former Member
0 Kudos

Thanks for all your answers. We only want the users to query Released SDS from SAP, and converted to pdf during the query and display it on the web. I believe there are some function modules that will perform the conversion in SAP, or maybe it will be done on the web server.

christoph_bergemann
Active Contributor
0 Kudos

Dear David

to my knowledge there is no function module in SAP which generates a pdf file using a WWI. The conversion is done as explained by Kamal using the WWI together with additional software on the WWI server. PLase use the threads as mentioend by Kamal etc. They will explain you what is needed. Depending on the Web User INterface you are thinking about: in principle the user will specify some data which can be used to select the report in SAP EH&S. Then by using some function modules etc. you will be able to select the appropriate WWI report and then pass that on to WWI gen Server. Normally you will get back a WWI file.

Now if we are not talking about WegGui but SAP GUI then the local WWI is started to display the WWI report. In the SDS distrubution process now the final report would be converted on WWI gen Server into a pdf file and passed back to SAP. Therefore you can fetch this pdf file and start in Web the Adobe reader to show direct the pdf file. The only "con" of this approach is, as mentioned: if we are talking about a 24 hours and 7 day SAP system should not be down as well as WWI server should not be down or the user will not get any report shown.

May by Julian could give some insight about recent status of EHS Web interface. May be such a functionality to show direct a pdf file using the WWI report is still available as part of the service / product as distributed by SAP (or may be wil be talen into account in the next version of the service / tools / product). Then it might be simpler to buy the solution as to reprogram the logic etc. May by Julian could help EHS community to get a fealing about how the solution works. E.g. what will happen if there is no report found in EHS database? I assume a nice warning etc. should be shown. I have now idea if the EHS Web INterface support many languages on the User Interface and if other language are suporrted in the "Warning part"

If i do not misinterpret Julian the solution might support actually the selection of inbound pdf files as well (which are stored in the EHS database). Here no WWI process is needed to convert the report as the report is yet stored in database as pdf.

C.B.

Former Member
0 Kudos

Hi David,

Why don't you think in a different way of dealing this with DMS. MSDS generated reports are storing in DMS repository. from there you can update the documents to your website.

Function modules -

CV150_SAVE_DOC_TO_URL

CV150_SEND_R3_DATA

CV150_UPDATE_DOC

By google - you may find some more function modules which are very friendly to your requirement.

In this case, it may be dealing with the raw reports.

you must give some identification for each document while updating to URL, by tweaking the standard programs.

In web based solution, most of the users interested to select the document based on very few parameters like Brand name, commercial product name, Material Name/ Material No. and finally the language and version of the document.

You can ignore the version, as we can control the multiple versions in SAP itself and only latest version will be displayed.

If you could give a correct identification to each MSDS document with the above parameters, while updating to URL............may get positive results.

This is just a overview from my side and not sure how it works and never tried.

Regards

kamal

Former Member
0 Kudos

Thanks Chris and Kamal, we'll try all the suggestions you provided and will let you guys know how it works out.

Julian, if you can provide more information on the EHS Web Interface that will be great! Thanks!

0 Kudos

OK, write me an email and we set sth. up!

0 Kudos

Dear David,

I just realized that my email address has not been visible for users. I changed my privacy settings and it should be visible now.

cheers,

Julian

Answers (1)

Answers (1)

christoph_bergemann
Active Contributor
0 Kudos

Dear David

if you try to "replace" to a recent extent using a "website" CG54 you may be now that you need some parameters to get a really final WWI report. In case of SDS in most cases you need

a.) a sales organization

b.) a material number

c.) a released WWi report

Normally using the standard CG54 approach you need a local WWi. Regarding C12H_WWI_DISPLAY_DIRECT is (to my knowledge) a good starting point to find a solution to display the report in a website but regarding the WWI "server" etc. I am not "sure". You will find a number o similar threads in this FORUM discussing the "nearly" same demand as in your example.

May be check as an example

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0b85f25-d99f-2e10-b8a2-96e0b54cc...

or

http://scn.sap.com/thread/967785

C.B.

Former Member
0 Kudos

Just to clarify, we are creating a website for external business users to query Released SDS, need to know if anyone has experience in creating RFCs for the query and display the reports.

Another question, can the report be converted to PDF before displaying on the web? Any function module to convert the SDS from word document to PDF?

Former Member
0 Kudos

Hi David,

for your second question, can be converted into PDF files......by doing small changes in wwi.ini file.

check the sap note - 1535067

and you can find couple of threads related to this.

http://scn.sap.com/thread/3163164

http://scn.sap.com/thread/1558114

Regards

kamal

Former Member
0 Kudos

We still want to keep the files in word format for workflow purpose in SAP. Only needs to be converted to PDF when displayng on the web.