on 04-07-2014 10:07 AM
Hello,
We have compliance data REACH & RoHS in SQL data base. Now, we are implementing SAP EHSM. How can we map sql db and SAP attributes? what are the things to be considering ? Could you please help? Thanks!!
Regards,
Saravana
Hi Saravana,
Data model of EHSM is fairly different than classic EHS as EHSM is based on BOPF data model. Since you have mentioned reach and ROH data which makes me believe that you are talking for EHSM Product Compliance implementation. Please look at compliance data node in BOPF workbench to see what are the database tables that ties so it so that you can map it accordingly.
Attributes to map for data conversion for EHSM very much ties to its BOPF structure.
LSMW can be used to import data from SQL to EHSM however we are opting for XML load. You can use program R_EHFND_BO_XML to use XML load file from your sql database and import into EHSM.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear D M
according to: consolut - R_EHFND_BO_XML - Dump BO as XML you could use the report you mentioned to prepare an XML output; but it can not be used for import. Do you have different informaiton according to that?
C.B.
Hi Saravana,
The master guide provides the information about required/optional system landscape elements, integrated applications details, etc
Your answer is here :Page # 39 - 4- Business Scenario : Product Compliance below master guide.
Edward
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your replies!!!
Yes I'm using "Component Extension for EHS Management 4.0, Product Compliance".
Could you please tell me how the configurations happening in component extension for EHSM. Thanks!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I want to know what are the EHS attributes to be considered to map between SQL db and SAP?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Saravana
please make it more specific. Do you implement SAP EHS "classic" or Component Extension for SAP EHS Management? Term EHSM is in most cases used in context of Component Extension for SAP EHS Management.
Regarding Component Extension: the discussion of "migration" of data has been discussed E.g. here:
Regarding EHS classic: just refer to SAP on online help. E.g.
Import and Export - Basic Data and Tools (EHS-BD) - SAP Library
Regarding yoru general topic: Any source system does have a specific structure (data base structure). EHS and EHSM have their own structure. Any project regarding the topic oif data migration is therefore "special" and no general answer can be provided for your demand).,
C.B.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.