cancel
Showing results for 
Search instead for 
Did you mean: 

Want to connect MSDGen tool legacy data to SAP EHS (Master data upload)

satya11719
Active Contributor
0 Kudos

Hi ,

I just want to upload the complete data from MSDGen tool legacy data to SAP EHS (Master data upload).

MSDGen Tool having connection with ADM(Ariel already)

following things i'm going to do,

Division of substances REAL,PURE & LIST .

Upload phrase libraries & phrases

Templates upload.

Here to upload the data or connect the legacy system what are the possible ways i checked with OCC.

i was downloaded that from market place.. what are the next things to do can i download it into local PC ? how is will be used in group cause im new to SAP OCC

Accepted Solutions (1)

Accepted Solutions (1)

christoph_bergemann
Active Contributor
0 Kudos

Dear Satya

you never received an answer for your last question. Sorry. To make it short:

EHS set up start with the "components" first (e.g. LIST_SUB, PURE_SUB, sometimes REAL_SUB) (but it is possible to set up first REAL_Sub and assign the REAL_SUB to Material number); you need as well not only "components" but e.g. "LS_UN_SUB" and "DG_CL_SUB"; the whole process depends a little bit: do you start

a.) from scratch?

b.) do you have a "legacy system" you would like to get rid of

c.) etc.

Check may be: https://blogs.sap.com/2017/09/04/data-migration-in-ehs-classic/

If you have the "PURE_SUB" / "LIST_SUB" in place:

then you create "compositions" or "spec listings" using the new spec ids

Example: REAL_SUB should describe coffee + milk + sugur (including water)

1.) create first "Coffee", "Milk" and "Sugur" and "Water" (as e.g. PURE_SUB)

2.) then write down the "spec id"s of all of them (including values of content like 10% etc.)

3.) Then decide: which property to go (e.g. STANDARD COMPOSITION); define as well "usage" for upload

And then by using spec id of REAL_SUB and of spec Ids of e.g. PURE_SUB" "Coffee", "Milk" and "Sugur" you can use either "OCC" or SAP Standard import so that the REAL_SUB does have a "composition"

10% Milk, 10% sugur and 10% "Coffee" (and may be 70% water) as a composition

C.B.

PS: it should be clear. for the EHS set up: you do not need only "components"; you need phrases as well and a lot of other stuff (e.g. customzing like: Regulatory list, User Defined TExt, Identifers etc. etc.)

Answers (7)

Answers (7)

christoph_bergemann
Active Contributor

Dear Satya

I can not "catch" your topic (why is OCC/DataEditor/Expert etc.) is so confusing

To make ist simple:; forget about DataEditor

If needed use OCC (for upload of data)

Expert Server: Topic should be clear if you have read online help and checked SAP customizing. Expert Server is needed to execute "Expert" based rule sets.

Expert Server is installed on "external" hardwares. OCC is installe din most cases locally. For "Expert" part. based on (I believe Enh Pack5) you can now do better "sizing" (performance increased etc.)

So like WWI; you need to install additional software on some e.g. "Windows" based hardware (check SAP markeplace for details

C.B.

christoph_bergemann
Active Contributor
0 Kudos

Dear Satya

in one of the many threads on OCC an OSS note is mentioned (check teh blog please). There you will find a quite good document. Not explaining the details (Same as with WWI9 but this is teh best you can get by SAP:

C.B.

satya11719
Active Contributor
0 Kudos

Hi Mark,

Could you please create some document on OCC, which will be helpful for folks .... about how to upload the data into property tree.

It's very much confusing between Data editor Tool & OCC(New version & old version), Expert server.

Thanks

Satya

Mark-Pfister
Active Contributor
0 Kudos

Hi Satay,

It is simple and straight forward: If you want to load data into SAP EHS use the OCC functionality that was taken over / included from the DataEditor. The old TechniData DataEditor is not available anymore!

This document was written by SAP and explains in detail on how to use the OCC for data load:

OCC_Specification_and_Phrase_Import.pdf

Hope this helps!

Mark

christoph_bergemann
Active Contributor

Dear Satya

did you really checked the blog https://blogs.sap.com/2014/11/13/rule-sets-secondary-data-determination/

?? Forget about "DataEditor" nobody will use this tool. OCC is the tool of "choice" now.

As expalined by MArk: the document is one of those thre we can be lucky to get such a good documentation.

For any "new" topic: it is not easy to learn. And for OCC the "same". There are clearly pitfalls. But as OCC (current version) is based on experience of "DataEditor" we can assume that thge process will run properly.

C.B.

Mark-Pfister
Active Contributor
0 Kudos
But as OCC (current version) is based on experience of "DataEditor" we can assume that the process will run properly.

It sure does! We recently migrated all data from a legacy system (ChemGes from DR Software) into SAP EHS using only the OCC - DataEditor for loading the data...

satya11719
Active Contributor
0 Kudos

Hi Mark,

The same i needed here want to transfer data from MSDgen tool to SAP EHS, That MSDgen tool doesnt have vendor substances so i'm uploading them with OCC,

Could you please provide some helpful links for migration.

Thanks

Satya

Mark-Pfister
Active Contributor

Hi Satya,

What's wrong with the SAP documentation provided?

The EHS data structure is complex and therefore the data loading tool is complex and therefore the documentation is not a one pager...

EHS data loading is not something you'll learn in a couple of hours. After your first data load project you'll have a good idea of the capabilities. After mutiple projects you'll have figured out what works best in regards on how to re-load data, load deltas, delete loaded data etc...

Cheers

Mark

christoph_bergemann
Active Contributor
0 Kudos

Dear Satya

regarding topic "Could you please provide some helpful links for migration." this is my feedback

Now "linked" to EHS since years clearly I have lot of experience regarding "migration topics": Honestly. It is n t"easy" to prepare a kind of "Best Practise" document. On top: the "issue" is as well the "target" scenario.

E.g. will the company use in future SAP content? etc. Such questions (an dthe answers) are the "key facts" to decide: what is the best option for migration. Now as we have EHS and EHSM the topic is "worse" in comparison to the past.

C.B.

Ralph_P
Advisor
Advisor
0 Kudos

Hi Satya,

If you read the documentation Mark posted you will know about the technical aspects and you can start migrating a small amount of properties for a small amount of specifications. That in turn will give you the ecperience to turn to more complicated things like reference structures or DG data. But as Mark rightly pointed out, you will not learn data migration in a day.

Ralph

satya11719
Active Contributor
0 Kudos

Hi CB,

Can you please tell me the what is standard Import & if want to import real_sub & assign them as components in specification what is the best way ??

Thanks

Satya

christoph_bergemann
Active Contributor
0 Kudos

Dear Satya

with OCC you can not create the REAL_SUB. BUt if REAL_SUB exists you can use OCC for the topics you look at. PLease check the discussions (just check the blog). In any case: standard EHS import is as well an option

C.B.

PS: Dear Satya: based on feedback of Mark in some thread: you can create new spec with OCC as well

Mark-Pfister
Active Contributor
0 Kudos

Hello Christoph,

OCC has in the current version the old DataEditor tool included. Therefore you can create REAL_SUBs - or any other substance type - with OCC.

Kind Regards

Mark

christoph_bergemann
Active Contributor
0 Kudos

Dear Mark

upps. Then i really need to invest some time in checking OCC. I was on the "wrong track" and still assumed that you can not create new spec using OCC. Thanks for your hint.

C.B.

satya11719
Active Contributor
0 Kudos

Hi CB,

I just want to upload some materials as specification in CG02 because i will get the composition in BOM.

i just want to upload through OCC only the vendor materials and composition ...

For others existing in 3E i will run secondary data determination through user exits.

OCC is the best option to upload ?

Thanks

Satya

christoph_bergemann
Active Contributor
0 Kudos

Hello

your question and explanation and yoru "doubts" are not clear. If you use 3E content you will not use OCC for upload. But there are lot of threads discussing OCC.

May be just check: https://blogs.sap.com/2014/11/13/rule-sets-secondary-data-determination/

PLease explain what you are really looking for

CX.B.