Upload new phrases in the system

[Former Member]

Hi,

We are currently upgrading from 46c to ECC604. In 46C we use a very small functionality of the dangerous goods master. Just some info for entering UN numbers, hazardous substances and user defined texts (5x). We have our own forms and print some fields from this masterrecord.

According to SAP we have run DGCONVERT to convert the texts into phrases.

- UN numbers in 46C was customizing and now they are maintained in phrases. Every key gets CUST-xxxxxxxxxx numbers, but the link with the UN number and the description of the UN number is not 1:1 anymore. You could enter an other description for the same UN number. So UN numbers is not customizing anymore, just masterdata in DGP2. Is that correct? Or can I make a direct link to the description?

- Because running the conversion report, every text (hazardous substances and user defined texts) are moved to phrases with CUST-xxxxxxxxxxx key. For us a problem because for us that key does not say anything, so probably we need to create new phrases. I have seen that there is CG3Y and CG3Z for uploading/downloading, but it expects /usr/sap/EHS_DATA/stocker/substanc.dat file for downloading. So is there an other way to upload our own phrases? so we can do a data migration from 46c to 604 without using the conversion report.

- In the tab 'printed text' of DGP2, you see the description of user defined text (UsDefTxt 1). Is there a way to change this description as this was possible in 46C.

- Is it possible not to use CUST- in for the phrases?

Any info would be appreciated! Thanks!

[christoph_bergemann · Accepted solution]

Hello,

it seems to be that you (and your customer) have used in the past only module Dangerous Goods Management (EHS-DGP) without using the other EH&S modules. Normally I would assume that you can stay with this process, even in a release upgrade process.

I assume you did an OSS etc. check before you used the "DGCONVERT" report?

In any case: I can give you only an idea regarding the "CUST" topic (as I have no experience in using Dangerous Goods Management (EHS-DGP) without using the other submoduels of EH&S).

Phrases are a key concept in Environment, Health and Safety. To create a phrase some primary set up is necessary.

e.g. you need a phrase catalog (and CUST is a phrase catalog). Furthermore you need phrase groups. And you must check customizing as phrases does have phrase texts which are language sensitive. So you nee to specify the languages you would like to use.

In SAP EH&S standard normally the UN number and the descpition are "texts" (identifiers) maintained on a UN_LS_SUB object. The noraml SAP process is than to convert the identifiers to phrases (this is done completely automatic). These phrases are then used in th SD papers to print some texts on the document. I assume because of your conversion that you now need to check you printing programs and may be adapt them.

May be take a look here regardgin the standard DG process in SAP EH&S: http://help.sap.com/erp2005_ehp_04/helpdata/en/de/5174db4c4b11d18a110000e816ae6e/frameset.htm

According to this documentation there is no different possibility as to use phrases.

May be someone different does have an idea how you can go on in your situatoin. It is clear that you now "loose" the link (UN number to etxt) in some sense.

With best regards

C. B.

PS: yes you can upload phrases which you would like to use. Take a look in online help in the area of "Basic Data and Tools (EHS-BD) ". Here you will find a process how you can upload phrases into your system

PPS: Yes in my opinion you can use something different than CUST (but only one active phrase catalog !! but many passsive ones)

Edited by: Christoph Bergemann on Mar 17, 2010 7:01 PM

Edited by: Christoph Bergemann on Mar 17, 2010 7:03 PM

Edited by: Christoph Bergemann on Mar 17, 2010 7:06 PM

Edited by: Christoph Bergemann on Mar 17, 2010 7:06 PM

Edited by: Christoph Bergemann on Mar 17, 2010 7:07 PM

Edited by: Christoph Bergemann on Mar 17, 2010 7:07 PM

[Former Member]

Hi, I set my question as answered as most of my questions have been answered or we have done some things differently. I just saw an other posting directing to this one so I sum up a little what we have done.

Please take in mind that we have the EH&S module but only use a small portion of the dangerous goods master (DGP2) as in only being able to put some info in the dangerous goods master, into the delivery documents. As I experienced from all the other sites this will be a bigger issue, but for the moment this is from the upgrade part:

1) Start first with setting the enhancement switch EA-PLM in customizing, else it will not work properly. See note 1157472 as in our case the menu structure was not visible in SAP menu.

2) Starting point (for us) has been note 692664. This report describes the steps you have to make to convert your texts with reports DGCONVERT used in the dangerous goods master (like texts maintained in DGTU and DGTD , specific and user defined texts). Read carefully as it seems that you must not run DGCONVERT for the same checkbox so do this step-by-step.

3) The UN number is not customizing anymore, you would have read it in note 1157472 already. This leads to converting. But the result is that you get stupid phrases (CUST-10000000012312). As the direct link to UN number and the description has been broken, we have finally created new phrases in the format like CUST-UN1133, so that the users at least know which description is the correct one.

4) For running the DGCONVERT you maybe endup in strange errors. The main cause was that the customizing and the texts must be maintained in the old system at least with AN translation in the language you run the report. Like the tables TDG33 (with text table TDG34) and TDG66 (with text table TDG67), we did not maintain every key in a language. So no empty values allowed. When one of them is empty in that translation, program stops. So we already prepared this in the old system. This also applies for the user defined text and standard text. At least the text translation must exist (and text maintained with at least an empty line) in one language. So if you have 100 texts maintained in DE and 2 are empty, we added the 2 in the system and run the program in DE language. That should work. Hope it's clear. Else ask an abapper, that's why I know this.

5) UN number / phrases / translation. In our case we do not get content (I do not know how this works and how and why). So our content is the old SAP version. Basically we did the DGCONVERT, then found out UN number was not nice, so downloaded TDG66/67.

- First we created LSMW to create the phrases in CG11. Ask your abaper to create one where you can maintain multiple languages.

- Next we linked the phrases to the correct phrase set in LSWM with CG12 to phrase set PHRASE_SET_UN_IDENTIFIER.

- Then we did an change DGP2 LSMW. Please be aware: slow!!! As we have couple of thousands materials we have to link to the new UN phrases, the performance is slow --> 20 hrs for us. (4400 materials).

6) Basically we did the same for our user defined texts. Only SAP converts them not in the correct fields, also the user defined texts are in 1 phrase set available (SAP_EHS_1022_042_TEXT). We have 5 user defined fields, and to be able to print correctly we have created 5 new phrase sets SAP_EHS_1022_042_TEXT_1 until SAP_EHS_1022_042_TEXT_5. Put the correct values in the phrase sets and then did a fresh change of masterdata DGP2 into the correct fields. In CGAB transaction you can change the phrase set to a new one (see note 632534 and look at the part: important information). In our case we linked in DGTM2:

PDGF5 User-Defined Text Key 5 SAP_EHS_1022_042_TEXT_5

PDGF4 User-Defined Text Key 4 SAP_EHS_1022_042_TEXT_4

PDGF3 User-Defined Text Key 3 SAP_EHS_1022_042_TEXT_3

PDGF2 User-Defined Text Key 2 SAP_EHS_1022_042_TEXT_2

PDGF1 User-Defined Text Key 1 SAP_EHS_1022_042_TEXT_1

7) As the conversion from 46C to 6.04 with DGCONVERT also created phrase sets for UN we actually did not want, it seems that the big amount of phrases in the phrase set is therefore slow, see point 5. So we deleted these, but also take into mind, with LSMW delete a phrase is also slow. So we think of the option not to convert this with DGCONVERT so we just do a fresh upload and link. Maybe this is faster. Currently busy with this.

😎 During testing creating phrases, if you delete a phrase and create a new one with the same name SAP will give message. Run program RC1PHDEL to actual delete this from the database. See also note 1043546.

After this, we finally have everything back as we wanted and now we are able to print the data (with new selections on phrases) on our forms.

Hope this helps

Edited by: K. Peters on Apr 2, 2010 3:30 PM

[Former Member]

Thank you for the input!

Ofcourse we checked the OSS regarding the DGCONVERT, all prerequisites have been met and we were able to run th program to convert the texts into phrases.

As we are only use a small portion of the dangerous goods master, it was for us sufficient for some fields to print the neccesary things on delivery notes / bill of ladings.

I have seen now that CUST is sort of mandatory, ofcourse we could use only a "Z" variant, but we do not want to mix everything up, and we have agreed now on that we keep this.

The UN numbers, we have seen that there is no 1:1 relation anymore so we change these phrases to a more "readable" phrase (CUST-UN1333 instead of CUST-1000000001212 or similar). So for this we need to change the phrases or do a complete new upload and delete the phrases created by DGCONVERT to avoid confusion.

The user defined texts have been partially converted, so we have to do a new upload and into the new texts as the number CUST-100000001231 does not say anything for us so we have to create new keys which are more readable. Also we have already changed the phrase groups per field (user 1 , user 2 etc.) to new phrase groups as we have a clear difference what to fill in usertxt1 and usertxt2 etc.

At least we need now all papers and output to be changed

In general we need an upload if possible. The transaction CG3Y is downloading to local file on frontend. Problem is that we do not have a source from what to download. We try to do something LSMW like...

But any more input would be appreciated. Thanks.

[christoph_bergemann]

Hello

It is not clear to me what you mean with:

"In general we need an upload if possible. The transaction CG3Y is downloading to local file on frontend. Problem is that we do not have a source from what to download. We try to do something LSMW like..."

Do you mean you need a content provider there you will get the phrases (and content)?

In principle you could do a download of the "old phrases" and do an upload to create new phrases. IN any case this is in my opinion not a "small project". I have no experience in using LSMW in EH&S are. MIght be a good idea.

Assuming that you created your new phrases I have no idea how you will move / change the DG master from the old phrase key to the new key. The "problem" is that per regulation you will have one mater data record (ADR, ADNR etc.). So you need to replace the old phrase key at any place by the new phrase key. I believe there is no "mass transaction" available in EH&S with which you can do that in one step (and to do that manually seems to be no option).

Hopefully Jayakumar does have some tips/hints etc.regarding this for you. He seems to have some experince in using DG master only.

With bets regards

C.B.

Edited by: Christoph Bergemann on Mar 21, 2010 8:29 AM

Edited by: Christoph Bergemann on Mar 21, 2010 8:34 AM

Edited by: Christoph Bergemann on Mar 21, 2010 8:36 AM

Edited by: Christoph Bergemann on Mar 21, 2010 8:41 AM

[Former Member]

Hello

Here's the information

1) So UN numbers is not customizing anymore, just masterdata in DGP2. Is that correct?

Yes u2013 Its just Master Data i.e., Phrases

2) So is there an other way to upload our own phrases? so we can do a data migration from 46c to 604 without using the conversion report.

You can overwrite the path and provide a new location during file upload and use the new location for data import. Its not a mandatory that you use the same file location.

3) ). Is there a way to change this description as this was possible in 46C.

Yes u2013 You can change the information in Customization under DG Check Box structure

4) - Is it possible not to use CUST- in for the phrases?

By default system assigns CUST for all phrases that belong to phrase library CUST. So It is not possible not to use, whatever phrase library is set to active sytem uses similiar prefix.

Thanks

Jayakumar