Reg. material BOM

[Former Member]

Hello,

I have a material and i want to know if it has BOM or not?

Can you tell me the table where i can find all the list of materials which has BOMs? if not, can you tell me what is the best way to find out if the material has BOM or not?

I appreciate.

Thanks,

Krishen

[Former Member]

Use FM CS_BOM_EXPL_MAT_V2 to get detailed BOM explosion for Material, if no entry in STB mean no bom

Lakhbir

[Former Member]

do u have any sample code please?

thanks.

[Former Member]

also if anybody can tell me the table where all the materials (that has BOMs) will be stored, that will be great!

I am also trying to find the list of materials which has BOMS..

Thanks a lot!

[Former Member]

Hi ,

THIS WILL GET THE BOM IF YOU KNOW THE MATERIAL AND PLANT.

data: begin of itab_item occurs 0,

idnrk like stpo-idnrk,

posnr like stpo-posnr,

meins like stpo-meins,

menge like stpo-menge,

end of itab_item.

data: w_stlnr like mast-stlnr.

parameters:

p_matnr like mseg-matnr,

p_werks like mseg-werks.

select stlnr into w_stlnr from mast

where matnr = p_matnr

and werks = p_werks.

endselect.

if w_stlnr is initial.

message Material is not a bill of material

ENDIF.

select idnrk posnr meins menge

into table itab_item

from stpo

where stlty = 'M'

and stlnr = w_stlnr.

REWARD POINTS IF HELPFUL

THANKS

[Former Member]

Hi Krishen,

Please check tables.

MAST - Material to BOM Link

STKO - BOM Header

STPO - BOM item

You can also use transaction CS15 to find material BOM.

Hope this will help.

Regards,

Ferry Lianto