UN Phrase Key / Description Import into SAP system for Dangerous Goods Master

[former_member230136]

Hi Guyz,

We are implementing Material Master in MDG. Setting up the Dangerous Goods Master is also required. Almost everything is done, but we are not able create the Master Data for Phrase Key / Description ( which is required to create a DG Master Record). As we are not implementing EH&S Module here, so I am not aware of terminoligies used here.

My Client is already using the DG Master in ECC system from last 10 yrs. And they have the UN library for Dangerous Goods updated in the ECC system which contains 2400+ records for DG Phrase Key.

I don't have any idea how to upload the 2400+ records of UN phrases. I have checked in the forums, and I came to know that we have to purchase the UN library from SAP & upload using CG31 t-code.

Can anyone share some light in this.

Thanks,

Rohit

[christoph_bergemann]

Dear Rohit

never have seen such a demand. This is my story:

a.) You have anb SAP ERP (with EHS installed)

b.) you have a separete SAP MDG.system

According to my knowedge this would be the "high level story".

1.) If you start in MDG you generate the "material number"; Then you would use e.g. ALE to distribute it to SAP ERP system

2.) IN SAP ERP systens you would like now to use only DG. I believe even then you must "tag" the materials as "environmentally relevant" (this is, accordsing to my knowledge) not possible in MDG

3.) Now you would like to set set up DG Master data using the EHS set up

Honestly: not a good idea; but in theory possible.

First; you need to think about: which regulation you would like to support (e.g. IATA, ADR etc.)

Second: per regulation you must ! create the DG master data. To do so: you need lots of phrases. Most of them ! will not come with "regulatory content" but you have to handle them by yourself

Third; any of them would need in most cases translations e.g. for regulation ADR a must !

To set up the needed phrases and the needed master data for DG is not the work of a "IT consultant" but the work of business.

As explained: not a good idea to use this approach (you need more ressources) but it is possible

This type of set up is not discussed often here. May be you will find not more than 10 similar threads

Sorry to say: the details for "DG" set up is to long to describe it here. If you haver never done it before: look for some external company for help.

C.B.

[former_member230136]

Hi Christoph,

This is almost a 2 year old post.

However, thanks for responding. Yeah I know it was a weird requirement but it was implemented and running successfully till now.

The idea was, creation of DG Master should happen in MDG and then go to ECC ( if the new material is Hazardous ). To create the DG Master, you need to have Phrase Master available.

I have implemented the whole case as custom entities in MDG which is now working as expected.

PS: Closing this thread too

Cheers,

Rohit

[christoph_bergemann]

Dear Rohit

one topic i missed. It is not "good" enough to get "UN description" (etc) if you buy SAP content. I can not explain the details here but you need more, And this more is not provided by SAP but must be handled by your self or you are not compliant according DG regulations. Only as e.g. one key word: "Hazard Inducer" data can NOT be bought by SAP. An on top: you need to understand 100% perfect the "DG idea" (that you mave more than one regulation to consider etc.

Please check

- SAP online help

- and the many threads discussing DG topics here

C.B.

PS: to make it clear: your client need DG expertise as well (e.g. for packaging stuff) and there is a good chance that you client must maintain data by his own (as this data can not be bought from SAP (may be as only looking on the cloud solution service) => get in touch with SAP if needed

[former_member230136]

Dear Christoph,

Sorry for the confusing post. Let me explain it clearly, then it might help.

I am implementing MDG-M. Its a separate system. Client is using ECC as of now. Idea is to provide governance to the material creation & management. As part of their current process, any material which is ticked for Hazardous Goods, they manually create the DG Master for that material. When they create the DG Master Record, they provide the regualation, class, subclass etc etc. They are only using 1 Identification Type which is 'UN'. When they create a DG Master Record in the Description field they provide the Phrase Key.

The available phrases for UN is given below in a screenshot.

NOTE : They have not implemented EH&S module in the ECC system, they are just using Phrases as part of DG.

Now, in MDG we have implemeted the material management & also creating the DG Master Record. Replication we are doing via MATMAS & DANGEROUSGOOD. It's working which is not a problem.

Challenge:-

We are not having the Phrase Master Data for the UN in MDG.

Phrase Master Data get stored in the table.

ESTPJ ESTPS ESTPH ESTPP

I am having only 2 entries in ESTPP table, which I created them manually using CG12 t-code.

But in ECC system, ESTPP is already filled with 2400+ items.

Out of so many threads, I came to know about the Phrase library which we have to upload. But now I am thinking of distributing the Phrases from ECC system to MDG system using PHRMAS.

Please share a good way if you think there is any

Thanks,

Rohit

[christoph_bergemann]

Dear Rohit

1.) MDG => do you really talk about "Master Data Governance"solution? https://help.sap.com/erp_mdg_addon61/helpdata/de/77/29ad50e6542f3ce10000000a44538d/frameset.htm

2.) I am not aware of any option in "MDG" refer to 1.) to use "EHS" topic without customizing EHS. Therefore: you must implement/use EHS (DG Master data is an EHS topic)

3.) And they have the UN library for Dangerous Goods updated in the ECC system which contains 2400+ records for DG Phrase Key. => my interpretation of this sentence is as: the client is e.g. using SAP content; even if this is not the case the next topic still applies

4.) If you really would like to use only EHS DG Module then you must customize EHS partially. You can extract (using phrase export) the phrases from source system and using phrase import you can import in target system. And then you are ready (but to use only EHS DG is not the best choice !)

For the "upload" in target system you have now two options

a.) Phrase import

b.) Use of current version of OCC

In your situation a.) is the better option (as you extract from SAP and you import in SAP. For extraction: you have to get the "dat" file. Why then trying to convert that to an "OCC" like upload file? This is waste of time

C.B.

PS: refer to the many threads regarding "import/Export" etc. in the EHS forum