Cannot Delete a Specification

[Former Member]

Hi All,

I have a spec in EHS that gives me the C$215 error message when I try to delete it.  There are no inheritance relationships.  All of the reports are set to historical, and there is no material assignment.  When I get the spec in the hitlist and do a where used, it comes up blank for direct and indirect.  I do not believe the spec is in use anywhere yet I cannot delete it (set the deletion flag via CG02BD).  Can anyone offer some advice on this?

Thanks,
Jason

[Former Member · Accepted solution]

Hi Jason,

I have come across this same concern as well and in my case this was due to usage in a historical report.  This does not show up in the where-used check but still prevents deletion.  If you are inclined to check code, you will see that include LC102F04 contains the logic to carry out checks preventing deletion.  Beginning at line 367 (for my patch level), is check # 5 which calls function C1F2_SUBSTANCES_USED.  Historical reports are identified here and restrict deletion.  In fact, the comment in the code before the call states "*     CHECK 5: Is this substance used in a rel. or hist. report?"

Not sure if this is controllable by config but you could certainly implement an exit to ignore historical reports.  Hope this helps.

Adam

[Former Member · Accepted solution]

Hi Adam,

This is exactly what my issue is.  The reports are historical and we're stuck there.  I'm not sure why this hasn't happened before, or why now.  I'd like to understand what we did in order to avoid it in the future.  Anyway, thank you for the help.  Thanks to everyone for the help.

Thanks,
Jason

[Former Member · Accepted solution]

Hi Jason,

to delete reports, you can try 'playing' with function C14S_DOCUMENT_DELETE

along with reports RC1PHDEL, mentioned above, and MCDOKDEL.

Hopes this helps.

Have a pleasant day,

      François Blanck

[Former Member]

Hi Jason,

Although you must have taken care of below points but please do recheck once again..

To be able to delete a specification, the specification must not be:

• Used by another specification as the source in a reference or inheritance relationship
• Part of the composition of another specification
• Part of a listing (for example, hazardous ingredients)
• Used in a report

In Customizing for Product Safety in the IMG activity Manage User Exits you can also define a user exit (user exit category SUB_USED, where-used list) that executes a where-used list when you want to delete a specification. The where-used list supplied in the standard system checks whether a material was assigned to the specification (function module C1F2_SUBSTANCES_USED_BY_MAT).

Regards

Amol Joshi

[Former Member]

Hi Jason,

One of the method to delete the specificaiton is as belows

• Run the Program  RC1PHDEL
• Set the Flag 'Set deletion indicator'
• or set Flag 'Physically delete'

Please do refer to SAP Note Note 1043546 has details on this program...

Please find the attached screen shot.

I hope this helps.

Regards

Amol Joshi

[christoph_bergemann]

Dear Jason

only as an idea: you need not delete the specification by "hard" update. You could move it to a substance authorization group there no user (only support) does have access rights. This is best practise in my opinion.

You need to understand. Even if you would delete the specification "physically" (using the approach as provided by Amol and Adam etc.) there are a high number of e.g. "change docs" generated (as the spec has been used etc.). These will stay in the data base. And on the top: the specification may have been used by others a component etc. (here as well change docs exists) may have had reports (which may have been shipped to customer etc.) => there it is in my opinion not a good idea to "delete" it.

Especially if there is any report related to the specification you should not delete it (or you should delete as well the reports by "hard" update to the corresponding tables). If the specification has had in the past a mterial link: there will still be the DG master and other objects in place which have a "indirect"link  to  the specification which you have deleted.

Therefore: you should not delete the specification using hard updates etc.

C.B.

PS: On the top: if you use ALE scenario thing are worse..

[Former Member]

Dear Jason,

you to be able to delete a specification,but the specification must not be

1) Used by another specification as the source in a reference or inheritance relationship

2) Part of the composition of another specification

3) Part of a listing (for example, hazardous ingredients)

4) Used in a report

In Customizing for Product Safety in the IMG activity Manage User Exits you can also define a user

exit (user exit category SUB_USED, where-used list) that executes a where-used list when you want to delete a specification. The where-used list supplied in the standard system checks whether a material was assigned to the specification (function module  C1F2_SUBSTANCES_USED_BY_MAT).

Procedure

1) choose Specifications -----> Edit specifications(The Edit Specification: Initial Screen appears)

2) Select the specifications you want to delete

3) then Delete.(Ensure the specifications you want to delete should Edit mode. (  not in display mode)

Try this one

Many thanks

Emma.