topic Re: Finding Duplicate Material in Application Development and Automation Discussions

Finding Duplicate Material

Former Member — Thu, 27 Mar 2014 21:13:23 GMT

We have found a few different materials with the same BOM.
As we find them, we make one of them obsolete. We probably have quite a few that we don't know about.

Is there a standard SAP report that would give me a list of all materials that contains the same BOM?

CS14 will not work (unless I don't know how to use it)

Thank you

Re: Finding Duplicate Material

Former Member — Thu, 27 Mar 2014 23:37:53 GMT

Not sure what you mean by a few materials with the same BOM. A material can have multiple BOMs and can appear in multiple BOMs of other materials but different materials in the same plant pointing to the same internal BOM number I don't think this should happen. As far as I understand PP and I don't claim to be an expert If this did happen it would represent a serious internal inconsistency and so there isn't a standard transaction to find them. The transaction CS14 is just to compare two BOMs side by side and so won't meet your requirements. The table MAST connects material and their BOMS (i.e. the ones that build them not the ones they are components of) so you might be able to extract the information you are looking for from there but I don't think I can be of more help without understanding your requirement better.

I think this question might do better in the SAP ERP Manufacturing - Production Planning (SAP PP) space rather than the ABAP space. Maybe a moderator could move it or you might want to try re-posting it there.

Re: Finding Duplicate Material

Former Member — Fri, 28 Mar 2014 14:43:58 GMT

Jamie, Thank you for the reply,

My appologies. This is the first time here and I'm not sure yet how to navegate on this forum or where to place questions.

I don't know if this information helps. We have upgraded to a new SAP version and we tranfered (I'm not sure how this was done) all the data from the old SAP.

Here is the scenario:

I have material 1234567 with a BOM xyz

I also have material 1237654 with the same exact BOM

This meens I have a duplicate material in the system. 1234567 = 1237654

The materials we found to be duplicate were WIP and we were keeping unecessary stock of both. We combined stock and obsoleted one of them, minimizing stock management (and cost).

We would like to find out if we have more so we can do the same. With the volume we have, doing this manually would be very dificult and time consuming.

Re: Finding Duplicate Material

Former Member — Fri, 28 Mar 2014 15:08:41 GMT

Now that I found my way around (at least a little), I'll repost this in ERP.

Thank you very much Jamie

Re: Finding Duplicate Material

Former Member — Fri, 28 Mar 2014 17:21:07 GMT

Hopefully you get the answer you are looking for there. If all else fails it should be a very straight forward task to develop a simple report that display BOMs used by multiple materials, provided you have somewhere there with a developer key of course. Describing a BOM as uniquely identified by BOM Usage (stlan), Bill of material number (stlnr) and the Alternative BOM number (stlal) the following code should extract all BOMS in a give plant that are for multiple materials:

REPORT zbomreport.

TYPES: BEGIN OF tys_boms,
         stlan TYPE stlan, "CHAR 1 0 BOM Usage
         stlnr TYPE stnum, "CHAR 8 0 Bill of material
         stlal TYPE stalt, " CHAR 2 0 Alternative BOM
        END OF tys_boms.

DATA: gt_boms TYPE TABLE OF tys_boms.
FIELD-SYMBOLS: <gs_bom> TYPE tys_boms.

PARAMETERS pa_werks TYPE werks_d.

START-OF-SELECTION.

   SELECT stlan stlnr stlal INTO TABLE gt_boms
     FROM mast
     WHERE werks = pa_werks
     GROUP BY stlan stlnr stlal
     HAVING COUNT( DISTINCT matnr ) GT 1.

   loop at gt_boms ASSIGNING <gs_bom>.
     WRITE:/ <gs_bom>-stlan, <gs_bom>-stlnr, <gs_bom>-stlal.
   ENDLOOP.

By that way I think I was a bit hasty to say that this situation necessarily represented a data inconsistency thinking it over again I think that materials should be able to share BOMs but like I say I'm not a PP expert but I think the above code should identify your duplicates as described.

Points are appreciated if you feel an answer has been helpful.