topic Re: material components in Application Development and Automation Discussions

material components

Former Member — Mon, 27 Mar 2006 10:22:08 GMT

for each material find whether the components exist for that material. In case it is a production BOM retrieve all the components from the MAST, STPO and STKO tables.

how to fetch that and what is production bom means

Re: material components

Former Member — Mon, 27 Mar 2006 10:58:23 GMT

Hi Janardhan,

A production BOM refers to the BOM usage (STLAN).

All the components that are needed to produce a material will be a part of the production BOM.

The easiest way to retrieve data is to do a select join on the three tables ( MAST, STKO, and STPO )

If you know that the BOM Category ( STLTY = 'M') then you can also use the function module :

CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'

EXPORTING

capid = space

datuv = sy-datum

mtnrv = material number

stlal = '01'

stlan = '1' "prod bom

werks = space

mehrs = 'X'

IMPORTING

topmat = v_topmat

dstst = v_dstst

TABLES

stb = vit_stb

EXCEPTIONS

OTHERS = 1.

Regards,

Urmila

Re: material components

Former Member — Mon, 27 Mar 2006 11:16:34 GMT

Hi,

Pass '1' to field STLAN while querying MAST to get the BOM number, pass the bom number to get components from STPO.