topic Re: Reg. material BOM in Application Development and Automation Discussions

Reg. material BOM

Former Member — Fri, 05 Jan 2007 19:38:32 GMT

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

Re: Reg. material BOM

Former Member — Fri, 05 Jan 2007 19:44:44 GMT

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

Lakhbir

Re: Reg. material BOM

Former Member — Fri, 05 Jan 2007 19:45:46 GMT

do u have any sample code please?

thanks.

Re: Reg. material BOM

Former Member — Fri, 05 Jan 2007 19:46:47 GMT

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!

Re: Reg. material BOM

Former Member — Fri, 05 Jan 2007 19:49:03 GMT

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

Re: Reg. material BOM

Former Member — Fri, 05 Jan 2007 22:03:51 GMT

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