One material has two entries in DGTMD table

[devdatt_khedekar]

Hello Experts,

I found very strange phenomenon in our production system. There were two or sometimes more than two entries for one material one was showing as Dangerous and other as non dangerous. I mean in DGTMD table in DGNHM field is X for one entry and blank for other entry of the same material. I think this is the cause of previous issues which I posted where same material was shown as Dangerous and non dangerous for same regulation.

My question to you is what is the resolution for this if this is the cause. How to get this data corrected?

[Former Member · Accepted solution]

Hi Devdatt

As Geihl said , we can have multiple entries for one material in DGTMD , but these all are regulations (which refers MOT) specific.

Balajee

[Former Member]

Hi Devdatt,

just as an addition to what Pietro answered:

the concept of DGTMD is to be able to have one valid entry for each relevant regulation for each material:

- you might have several entries for one regulation in case of different time ranges

- you might have several entries for different regulations

The key is not the material number. Please check if the entries you are mentioning are

- regarding the same regulation and

- the same time range.

Best regards,

Christoph

[Former Member]

Hi Devdatt, maybe I didn't catch your problem but I think that you can have too many records for the same material in that table, because I suppose it used by SAP like a "Document Flow" !!! Infact you have the fields RECN and ACTN as a key and not the Material Code ...