SAP altenate BOMs Quality check

[adityanishant]

1) Please help me identify the BOMs in the production system which are not being used.

Ex Case: I have 5 BOMs but my system is only using 3 BOMs during production. How do I identify the 2 BOMs that are lying idle in my database? Please help me with the flow to identify it so that my developer can write a query to extract the required info.

2) How do we compare the difference between a products BOM that is in the database and the one which was used to produce it.

Ex Case : Lets say I have a BOM which says that I require 4 items to manufacture a final product but while producing some users add extra items to the product. How do I find out this difference.

[raviraj_sharma · Accepted solution]

Q1:  When you say you have  5 BOMS,  do you mean you have 5BOMs for the same finished product?  In that case i assume you would be working with alternative BOMS and Production versions.  You can check in C223 Tcode, which production versions are active for a  material.

IF however, you just want to know out of Total 5 BOMS  in the syatem ( 5BOMS of any 5 materials) , you want to know which one is being used,  you need to check which  of the Header materials  have had Production/Process orders created for them.(COOIS gives u this info of orders created)

Q2: To check  Planned VS Actual consumption i.e.  qty to be consumed as per BOM  and  qty actually consumed against the order,  you can tally by checking the Component requirement as Per BOM (CS11 can give u this ifo) , VS the actual consumption which you can get from MB51  mvt typ 261.

[adityanishant]

Hi Raviraj,

Thanks a lot for your suggestion.It helped me a lot.

[muhammad_umar2]

Dear Aditiya,

You can check in CO03, Tab Master data, where Alternative BOM no. is define. You can check below.

[Former Member]

Did you get any specific report?  or is C223 and COOIS sufficient?