how to get the correct BOM usage

[Former Member]

dear all

I want to know how can I get the BOM usage ? I search in table MAST and STPO

but it can't be decided only one record.

if do so , I can't use the FM ' CS_BOM_EXPL_MAT_V2'.

So can anybody help me

thanks in advacne !

Kind Regards

Nick

[naveen_kumar116]

Hi,

We have used to get the bom usage for material.

SELECT a_{matnr a}werks a_{stlnr a}stlal a~stlan

b~stlty "STLNR STLAL

b_{stkoz b}datuv b~aennr

FROM mast AS a INNER JOIN stko AS b

ON a_{stlnr = b}stlnr

and a_{stlal = b}stlal

INTO CORRESPONDING FIELDS OF TABLE ig_bom

FOR ALL ENTRIES IN ig_matno

WHERE a~matnr = ig_matno-matnr AND

a~werks = ig_matno-werks AND

a~stlan = '3' AND

• b~stlty = 'M' and

b~datuv <= p_datuv.

and use same FM to explode Material BOM

Cheers,

Naveen

[Former Member]

Hi Naveen,

First , Thanks for your reply . But I think your solution doens't meet my request .

I want to get BOM usage (STLAN) , and the BOM usage is not fixed .

Kind Regards

Nick