problems during filling of the material which is assigned to REAL_SUBs

[Former Member]

Hello everybody,

During the filling(DGE5) with the materal which is assigned to several real substances(each real substance has a reference to a substance of dangerous goods classification), there is a problem coming out.

When I checked the filling logs, it shows:

" Material 200-270 is assigned to several real substances

Message no. DGA412

Diagnosis

You attempted to fill data records in the dangerous goods master with data from data records in specification management.

However, the material 200-270 is assigned to several real substances.

System Response

The material 200-270 is not filled.

Procedure

Ensure that the material-real substance assignment is unique and start filling again."

I did the assignments according to the information here: http://help.sap.com/saphelp_45b/helpdata/en/3e/60957d0d1311d286e7080009b98822/frameset.htm

" Filling the Dangerous Goods Master "

and " DG Classification (Classification Key) "

Here says, the material-real substances assignment can be m:n relationship. (If I understood correctly)

I'm quite confused now. Who can help me?

Regards,

Li

Edited by: Li Cheng on Mar 30, 2010 12:00 AM

[Former Member]

Hello,

For DGfilling to work -- One material should be linked to one REAL Substance. It seems you have linked many real substances to one material. Navigate to Substance workbench and search the substance based on material and see for " Material Assignment tab" and remove redundant assignments

Thanks

Jayakumar

[Former Member]

Hello Jayakumar,

I know what you said " For DGfilling to work -- One material should be linked to one REAL Substance " is in accordance with the truth which I've met.

But I still don't understand what " SAP Online Help " describes:

http://help.sap.com/saphelp_45b/helpdata/en/3e/60957d0d1311d286e7080009b98822/frameset.htm

" DG Classification (Classification Key) "

" The realationship between material and REAL substance is m:n "

Is this realationship carried out using material-substance assigenment?

Just like what another " SAP Online Help " page describes:

http://help.sap.com/saphelp_45b/helpdata/en/3e/60957d0d1311d286e7080009b98822/frameset.htm

" Filling the Dangerous Goods Master "

"Assignments between materials and substances of substance category Real substance or Dangerous goods classification are carried out using material-substance assignment. "

Is that means, one material can be assigned to several REAL substances with have their own reference of Dangerous Goods Classificaiton (the realationship between REAL substance and Dangerous Goods Classification is 1:1 ) ??

Thanks a lot!

Li

[george_ainiveettil]

Hello Li,

One specific material will be linked to one REAL_SUB only.However you can have multiple materials assigned to same REAL_SUB(n:1)

In CG02 you can enter the material and in the search field provided and press enter.Now the specification to which the material is assigned will be displayed.In your case the same material is assigned to multiple specifications( REAL_SUB) which should not be.

One material should be assigned to one REAL_SUB only .How ever You can have the same UN Listed substances in more than one REAL_SUB( By referencing)

You can first run a Simulation run (DGE6) to check the filling to DG master from specification management.Then run DGE5 for final filling.If filling is proper,it will display a message.Now check DG master and find if the Regulations are in released( status 10) Status.

Thanks

George

[Former Member]

Thank you all!

Your answers are actually very clear.

Here may I ask WHY one material can only be linked to one REAL_SUB for DG filling???

Regards,

Li

[christoph_bergemann]

Hello Li

the relation material <=> specification key (REAL_SUB) is the "critical" factor so that EH&S can work in any sub module.

It is not allowed o create a link of material number A to spec REAL_SUB A and at the same time in addition to REAL_SUB B and it does make no sense to do so ( I am not sure if EH&S hinders you to do so).

This relation must be done so that DG filling is possible (not talking about exceptions in DG filling)and that e.g. MSDS delivery is possible. Example:

You are using SAP SD module to create an order for customer. Now you use material number A. Now EH&s tries to find later a WWI report (MSDS) to be shipped corresponding to this material number. Now if the same number would be linked twice (REAL_SUB A and REAL_SUB B) the MSDS delivery process is not possible because no unique relation is found. The same is true in DG filling. There must be a unique material <=> REAL_SUB relation.

PLease take a look here:

http://help.sap.com/erp2005_ehp_04/helpdata/en/de/5174db4c4b11d18a110000e816ae6e/frameset.htm

Chapter "Dangerous Goods Basic Data (EHS-DGP-BD)"

Hope that this helps.

C.B.

[christoph_bergemann]

Hello Li

the relation material <=> specification key is the "critical" factor so that EH&S can work in any sub module.

EH&S does not allow to create a link of material number A to spec REAL_SUB A and at the same time in addition to REAL_SUB B and it does make no sense to do so.

This relation must be done so that DG filling is possible and that e.g. MSDS delivery is possible. Example:

You are using SD to create an order for customer. Now you use material number A. Now EH&s tries to find later a WWI report (MSDS) to be shipped corresponding to this material number. Now if the same number would be linked twice (REAL_SUB A and REAL_SUB B) the MSDS sdelivery process is not possible because no unique relation is found. The same is true in DG filling. There must be a unique material <=> REAL_SUB relation.

Hope this helps.

C.B.

Edited by: Christoph Bergemann on Mar 31, 2010 6:06 PM

[Former Member]

Thank you very much, Christoph!

Your explanation is really clear.

Best regards,

Li