How to download MSDS documents to pc desktop and convert to pdf.

[Former Member]

Dear all,

Actually i have a doubt regarding download of MSDS documents to frontend system.

can any one tell how can i make that process to run? i done it by using dms_kpro_read in which i filled the structure ls_phio and called one perform to download the reports in cg02 enhancement point but problem is when i run and create report in cg02 then it is directly showing destop folder but report is also not coming .

can any one help me out were i need to write this enhancement to achieve that functionality. the need is when i create a report in cg02 it should go to cg50 and it should also save in active directly.

when i run this in cg02 it is taking document type as SBV but i need to take SBE and tell me how to solve it .

Please find the document which shows what i had done.

Help me out with an explanation if possible document.

Thanks in advance.

  DATA : object_id like sdokobject.
  DATA : ls_phio like sdokobject.
  DATA : gf_phio like sdokobject.
  DATA : ls_doc2lo1o like dms_doc2loio.

  LOOP AT l_gen_report_tab.

    ls_phio-class = l_gen_report_tab-ehsdoccat .
    ls_phio-objid = l_gen_report_tab-dmskey .

  ENDLOOP.

  gf_phio = ls_phio.

  export gf_phio to MEMORY id 'MUM'.

  PERFORM phio_check_out IN PROGRAM dms_kpro_read IF FOUND.

I had done the above coding which fills the class and object id and saves document but the problem is I am achieving the functionality but not the result.

Were I need to write the code in which enhancement that’s is CG50 or Cg54 or CG02.

In some documents if I see they are showing EXP_Call what is it.

It is filling in table as DMSkey  and dms cat.

I used this fields and filled the structure.

Once I execute the following popup is blinking but not able to save report .

This is what I had done.

[Former Member]

Hello Nick,

Greetings for the day!!

my requirement is once the report has been created in cg02 it should also send the created msds report to desktop and save as a pdf file.

Here they are not doing automatic report shipping so i need to enhance by sending the released reports to destop and save in one folder.

So please suggest me for further process as it is the main and urgent requirement.

Thanks in advance.

[nick_valeriano]

Hello Akula,

I would question the business process or business need for downloading MSDS Word Document to a Front End PC and THEN convert to PDF.

Report Shipping of an MSDS is Standard EHS functionality and provides a business process within SAP for automatic conversion to PDF. It also provides a history of creation, by who and the dates that the report was sent/shipped. This ensures trace-ability of documents sent to potential customers or clients within SAP, also ensures that no users have changed the data, accidentally or otherwise, on the MSDS Word Document.

I cannot assist in regards to the code you have provided otherwise.

-Nick

[Former Member]

Hello Nick,

Greetings for the day!!

my requirement is once the report has been created in cg02 it should also send the created msds report to desktop and save as a pdf file.

Here they are not doing automatic report shipping so i need to enhance by sending the released reports to destop and save in one folder.

So please suggest me for further process as it is the main and urgent requirement.

Thanks in advance.

[christoph_bergemann]

Dear Akula

with your code you will get "nothing" (clearly not what you would like to get); you need to understand the use of "SBV", "SBR", "SBE" documents (and how the process runs)

PLease check the many similar threads here:

and

You willfind many references to similar topics (and references to SAP standard options)

You need to understand how EHS is generating the "final report". And you need to understand WWI process etc.

C.B.

[Former Member]

Hi Christoph,

I had written as a way to get reports because its a standard report which generates documents to desktop and it works in one system.

i need a way to do it i read all links but not able to find a way . can u please help in detail had u anytime this time of requirement.

if yes please send me the document which will be helpful.

Thanks in advance. So please explain in detail.

[Former Member]

Report shipping can be done but they are asking do with one enhancement in cg02 or cg50 so need an clear explanation.

So please can u explain i ndetail.

[christoph_bergemann]

Dear Akula

not sure to what kind of approach your are referring here:

"I had written as a way to get reports because its a standard report which generates documents to desktop and it works in one system."

Starting CG02 you have only two options: "Create report" or "Create report from templat", The last one does not generate a report in database.. PLease explain your approach

C.B.

[christoph_bergemann]

Dear Akula

if you have read carefully the links provided: i would assume >90% of SAP customers using "Report shipping" to solve the demand. This is needed because of SAP design and architecture. Using CG54 you have additional options; but nothing like your customer is requesting (that means a kind of automatic mechanism starting from CG02)

If there might be an alternative, then it can be only in CG50. I have never ever heard about a SAP customer trying to do so. Once again: this is related to the SAP design of EHS (and how EHS in integrated in SAP MM etc.)

C.B.

[Former Member]

Dear ,

My business process is i need to bring a copy of released reports into one folder which they will link that folder to their web services and based on search criteria it will pick report from that particular folder and display to them in pdf format.

[Former Member]

Dear ,

My business process is i need to bring a copy of released reports into one folder which they will link that folder to their web services and based on search criteria it will pick report from that particular folder and display to them in pdf format.

[Mark-Pfister]

Hello Chileveru,

Your scenario is exactly what report export should be used for!

You need to understand that just downloading the documents from DMS / Kpro will not give you correct results.

In DMS /Kpro only RAW (incomplete Word Files) reports are stored  - you need to involve WWI to create the final report and convert it to PDF.

This is what the report export process does for you - and much more like evaluating which reports have been created newly or updated. In addition the report export writes so called key files containing information like product name, SDB Version, language etc so that you can index the SDSs and make them searchable...

Kind Regards

Mark

[christoph_bergemann]

Hello

this is exactly what report shipment can do / will do (as explained by mark as well); the "standard" is to do the download in a "server" (application server) etc.

PLease check the links as provided. Nearly nobody is "reprogramming" the tool if SAP delivers what you need (after some set up and some additional framework clearly).

Your topic is discussed so often here..

C.B.

PS: check e.g.