Skip to Content
avatar image
Former Member

Bulk MSDS Download

Dear Experts,

As per one of the requirement, the client wants to download the MSDS to local system and the manually distribute the same vai e-mail to end user.

Can you please advise me, how we can perform the bulk download of MSDS ( Released Reports)

Regards

Amol

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 23, 2012 at 07:13 PM

    Dear Amol

    a.) in cg50/cg54 normally you will see the "raw" report

    b.) after selection of material number and sales organization you can generate the final report (normally only one by one)

    c.) one approach to fulfill (may be) your requirement ist starting in cg54. Here the user can prepare a "report shipping request" based on hit list to start a MSDS shipment via e.g. eMail to a "recipient" which can be a user (but need not to be) in SAP; the pro of this solution is. The user is informed (if request is placed correct) if there is a new raw report if subsequent shipment is selected by the user

    Normally with the raw report you are not really taking into account the business need; a further pro of the solution as proposed is, that the user can prepare as many requests as needed (per material and sales organization etc.).

    Now question could come up: why should the user not direct send (distribute) the MSDS to the "end user" => SAP EH&S will support this process as well (the end user is here no "customer" (business partner" but could be a "sales person" etc. depending on your needs

    The download is done "indirect" as the reports will come to the "end user" via eMail (if set up is done like that)

    Check

    http://help.sap.com/erp2005_ehp_06/helpdata/en/a7/2877830a6c11d28a220000e829fbbd/content.htm

    and this:

    http://help.sap.com/erp2005_ehp_06/helpdata/en/a7/2878530a6c11d28a220000e829fbbd/content.htm?frameset=/en/a7/286c410a6c11d28a220000e829fbbd/frameset.htm

    and

    http://help.sap.com/erp2005_ehp_06/helpdata/en/a7/2878530a6c11d28a220000e829fbbd/content.htm?frameset=/en/a7/286c410a6c11d28a220000e829fbbd/frameset.htm

    as well as:

    http://help.sap.com/erp2005_ehp_06/helpdata/en/a7/28774a0a6c11d28a220000e829fbbd/content.htm?frameset=/en/08/57c007197f11d286fc080009b98822/frameset.htm

    A further option is to use an user exit in cg54 so that the "final report" is not distrubed via eMail but generated on WWI server direct and downloaded direct to client (but you need to prepare an user exit and you are "reprogramming" MSDS distribution process)

    It is possible in both processes to generate the MSDS either as MSDS; PDF etc. document type (matter of set up).

    PLease perform an inquiry in this FORUM. You will find a number of "similar" demands regarding this or similar topics

    With best regards

    C.B.

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Amol

      the proposal of Kamal is useful if the customer is satisfied to get the "raw report" and not the "final report" and clearly you need to prepare a "one and onyl" SAP report using the function modules mentioned. If the customer is interested to download the final report you need different solutions.

      Here now you need to define the "real" business need.

      a.) please describe/check if it is necessary to have the file downloaded with different "sales org" informations (normally by sales organization different "logos" are used and different emergency and contact adresses

      b.) please describe/check if there is the need to have the "material name "in place (which is normally realized as paramater symbols).

      Depending on the result of analysis and comparison with the business demand either you should go on using the proposal from Kamal or at least try to use one of the options mentioned by myself.

      Now if we talk only about may be 1000 released reports and there is no need to take care about sales org or material name then you should use a "student" which will simply use cg54 to retrieve te reports locally (using the local WWI) (clearly if you have more report you need to use more "students" but you need not to prepare a "one and only" ABAP report

      by the way. Thanks to Kamal for the suggested solution; might be helpful for further projects etc.

      C.B.