Product Lifecycle Management Blogs by Members
Get insider knowledge about product lifecycle management software from SAP. Tap into insights and real-world experiences with community member blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
christoph_bergemann
Active Contributor
3,200

Introduction

Quite regular there is the question coming up:

- Can I share/exchange data via XML in SAP EHS Management?

- Can I share/exchange data using XML regarding Safety Data Sheets

In theory answer is: Yes (but with some but)

But you need methods etc. to do so and there is no international standard available.

E.G.: http://www.sdscomxml.eu/ as well as http://www.sdscomxml.eu/english/details/

discuss the sharing of Safety Data Sheet data using XML.


The same on: http://www.ilpi.com/msds/faq/partc.html#xml

or http://www.denix.osd.mil/shf/upload/Initiative-to-Develop-Material-Safety-Data-Sheet-MSDS-XML-Standa...

or this nice "White paper": http://www.msdsmart.com/MSDSmart%20White%20Paper.pdf

XML is used as well in context of:

IUCLID interface to SAP EHS Management (as part of SAP Product and Reach Compliance Suite)

XML data can be used as well in the context of Open Content Connector.

http://www.consolut.com/en/s/sap-ides-access/d/s/doc/YY-EHS_MD_300_10

You can create XML data streams using SAP standard methods; no problem; You can link SAP ERP to SAP PI/XI and getting an XML file via SAP PI/XI. No problem.

But why is this so "problematic" in context of Safety Data Sheet?

First we need to understand SAP EHS Management approach to create a "Safety Data Sheet". Any body knows the answer: this is done using a WWI layout together with a generation variant. The result is a WWI report (which is a RTF file). This type of document can not be used "direct" as the data sharing via XML is only possible if the XML data is valid regarding a Schema.

But is there really no option to generate the report in such a way that a "XML" document is generated which is valid regarding a Schema? Answer might be: yes there might be an option.

With EnhPack 3 the busines function OPS_EHS_CI_1 is delivered in the area of EHS. Here it is stated:

The Business Add-In BADI_ESS_REPORT_GEN enables you to use an individual implementation to generate, display, and print reports without using WWI.

I believe this option can be used to get an Safety Data Sheet as XML data stream. But there is no "default" implementation available so therefore you have to do it by your own.

What are other options? Answer: the use of an own developped output variant. Here you can select the data you want and the convert the data in such a way that you will get a XML data stream.

This is clearly a challenge as you need to develop something which works as like WWI (collect the data etc.) but it is a clear option.

As OCC is implemented as an "UserExit" (Secondary Data Determination) it is clear that you can try to develop something to support the other direction as well. That means using an XML stream and then instering/updating/deleting data in SAP EHS Management.

The use of XML to share data will clearly be the future trend. Let us hope that SAP will support us in the future with some "default" implementations or provide additional tools for data sharing.

PS:

May be check as well: these function modules (which are only available under several circumstances):

/TDAG/CP_IM56_FILE_PREPROCESS
CP: Preprocessing for REACh XML file
/TDAG/CP_IM56_MAP_SAVE
CP: Map and Save Exit for REACh XML file
/TDAG/CP_IM56_PROCESS
CP: Process REACh XML file

and e.g.

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

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

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

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

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

http://scn.sap.com/community/chemicals/blog/2012/10/18/sap-product-compliance-managers-summit

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




5 Comments