Hello

if i remember correct; this is standard behaviour. Because of lot of reasons: NETHER EVER detach a material from a spec ! Yuu will have so many issues. This is the "worst" you can do.

C.B.

Hello

never ever detach a material from a spec. The issues you will get are "endless" to be listed.

This is the "worst" action you can do in EHS (more ore less.it is "forbidden" to do it like that (or you must accpet the consequences)

The behaviour you have found is standard (if i remember correct)

C.B.

Hi Christoph,

Thanks for your response and completely agree with you.

But suppose business user link material by mistake and DG Master got created during filling So what is corrective option we shall have.

1. De-link incorrect materials
2. Then delete DG master manually through DGP2

Hello

Let us start with the "material" part: If the material is "environmental" active (flag is set); then some relation to EHS should be available.

If the material is no delinked from spec (REAL_SUB etc.), this link does not exists anymore

The story depends now on"philosophy" of the company using EHS.

May be they have decided this; if an "environmental" active material is detached from REAL_SUB => this indicates a" dead" material (should not be purchased, produced, etc. material). In this case: you can (may be) accept the statsu in EHS (and do nothing). ; may beyears later the material should be "activated" again to be purchsed, produced etc. IN this case; you just link it to a REAL_SUB and e.g. DG filling will run (and data will be updated)

But if the material was "linked" by error:: this is somthing different. There is no EHS process available to handle this. One option would be:

check all "environmental materials" that they have a link to REAL_Sub and if not. generate an error

This logic can be implemented in an ABAP report which could run daily, weekly, monthly etc. Some user need then to check the result and initiate measures so that the material will get link to REAL_SUB again

If the material is not used anymore in SAP SD you can delete on top the DG master... bute there is no "real benefit"

The material / spec link is used in many other scenarios as well (e.g. SVT). Especially SVT should be checked. All the relevant important table contain a "material / spec" relation (hvaing some meaning)

The "most" worse in "detaching" a material: you can not use CG02/CG02BD to seacrh for a spec with this material number anymore; and if you do not use "change numbers". then you are ina kind of "deadlock" (and only SVt and DG data remain; in DG: ther is no relation material spec)

C.B.