Skip to Content

EHS report export from CG54 to be automated

Hi all,

I have an issue regarding exporting the EHS report via CG54.

The EHS reports that are in released state are exported using the export option which shows a pop-up to select the exit for exporting.

The order gets generated and the order is further set to complete via CVD1.

Now, i have a requirement to automate this entire process of exporting i.e. the process of CG54.

I tried using a BDC by recording the steps and then creating a batch job for it.

But, it didn't work, as the job finishes successfully but does not export any report.

The recording was as per the steps followed but still no idea why it didn't work.

Also, executing the recording in foreground via SM35 showed a timed out error.

So, if any one has come across and resolved such an issue or have any idea regarding this, then please help and share your inputs.

It would be of great help as I am struggling for quite sometime.

Thanks a lot in advance. Looking forward for your replies.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 18, 2014 at 06:50 PM

    Dear Dharmin

    check e.g.:

    Bulk MSDS Download

    and

    SAP EHS Management for Beginners

    you will find a lot of useful tipps/tricks. Your topic/demand is quite "old"

    C.B.

    PS: e.g.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2014 at 10:58 AM


    Hi Dharmin,

    In CG54 the"final" report is generated using your local WWI client, for this reason you can't run CG54 in background, there isn't communication with your local computer, the "final" report can't be generated.

    You can download the documents that have been crated with WWI, RTF docs in DMS.

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

    Regards.

    JCD

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Dharmin

      you still "misinterpret" the differenct scenarios. CG54 can be used "only" if you have some "static" approach (user action based interaction). In most cases this is not the "real "situation"

      The report you mentioned is explained here:

      Report Export by Program - Basic Data and Tools (EHS-BD) - SAP Library

      This report is on most cases a good starting point; but it depends on your specific requirement.

      According to my understandin: once again it is a "user" driven action; In most cases companies have "automized" thge whole process so that you need not to check Al11 etc.

      If you do not have a good picture of report distribution then you will not succeed in finding a solution. Check e.g.

      C.B.

  • avatar image
    Former Member
    Sep 19, 2014 at 01:22 PM

    Hello Dharmin,

    Since you have embarked on a way to to a BDC program for automating the entire process, I would say it is a right step but not a right approach.

    Yes you would need to have a program to run as a job or as a ad hoc mode to export reports. The technique which may be used here is to

    Step 1 -Find newly relased reports . The API C1F3_REPORTS_FIND_FOR_SUBSEQ could be used. I would not recommend a direct table read of ESTDH

    Step 2 - generate report shipping call (EXP_CALL) . API CVEA_RDOS_CREATE_BY_EHS could be used .

    The next step would be processing the EXP_CALL function. So you need to have a proper customising for report shipping in SPRO so that the EXP_CALL processing routine is called. The standard function module to generate key file (meta data) as well as the report document (as a PDF or otherwise) is CVE9_RDO_DOKX_EXPORT

    However in these steps you would need to have your adaptions of the APIs based on the business requirement. For example do you need an export when there has been no relevant change in the report. Do you need a export when there is a change in a substance and so on..

    Comments from community / you are welcome.

    Add comment
    10|10000 characters needed characters exceeded