To get the list of materilals whose BOM exists

[Former Member]

Hi,

Can u help with this problem.. I want to see te list of materials whose BOM exists . Is there any direct T.code to se this or i have to see a query.

I am at clients place. Please help.I will award points.

Regards

Jimmy

[former_member184655 · Accepted solution]

Dear Mr.Jimmy,

There's no standard SAP T code to find out this.

Better get the details from table MAST - by giving the list of materials for a plant or

for a plant.

If exists a BOM,it gives the Material,plant,BOM no.

or else You can create a simple query,using table MAST.

IF useful reward points.

Regards

Mangal

[Former Member]

Hi Jimmy

check CS15

Thanks

Bala

[Dsk]

This is one of the method to find the Materials which has BOM

1.Go to MM03

2.Put a f4 help on the material number

3. There select the search criteria as " Materil By Bill of Material"

4. Now give the Plant and the Bom category

5. This will give you the list of BOms available for the material in that Particular plant.

6. Now you can download to the system.

Hope this will solve your problem ..if so close this thread accordingly.

thanks

[Former Member]

Hi Jimmy,

Actually you can see only the material codes whoes BOM is created.So you can identify which material is having BOM.You can go to cs02 and there you can select material view as "Material by Bill of Material" and when you will execute, it will show only the material codes which is having BOM.

If you really want the components of the materials which is having BOM, you can develop a report for which these are the helpful tables.You have to join this tables.

MAST - Contains Material which is having BOM

STPO - Contains component details

STKO - Contains parent material details

STAS - To link with MAST

[Former Member]

Hi Jimmy,

Goto transaction SE16 and use table " MAST" for the same.

Here you can find all the materials and their respective BOM's along with their usage.

You can also create your query based on the same.

Reward points if it helps.

Regards

Karan

[Former Member]

Hi Jimmy,

There is no standard t.code to see a list of materials whose BOM exists as far as i know. You have to develop a Z programme for it.

Regards,

Satyajit Kumar