cancel
Showing results for 
Search instead for 
Did you mean: 

How to find out whether material is tie to a BOM

Former Member
0 Kudos

Hi everyone,

I would like to know how do i find out whether a particular material is tied to BOM (as in is it part of a BOM structure)?

Accepted Solutions (0)

Answers (5)

Answers (5)

ferry_lianto
Active Contributor
0 Kudos

Hi Bernard,

You can use this FM <b>CS_WHERE_USED_MAT</b>.

call function 'CS_WHERE_USED_MAT'
  exporting
   datub                      = sy-datum
   datuv                      = sy-datum
   matnr                      = wa_matnr
   werks                      = wa_werks
  importing
    topmat                     = i_topmat
  tables
    wultb                      = i_wultb
    equicat                    = i_equicat
    kndcat                     = i_kndcat
    matcat                     = i_matcat
    stdcat                     = i_stdcat
    tplcat                     = i_tplcat
  exceptions
    call_invalid               = 1
    material_not_found         = 2
    no_where_used_rec_found    = 3
    no_where_used_rec_selected = 4
    no_where_used_rec_valid    = 5
    others                     = 6.

Hope this will help.

Regards,

Ferry Lianto

Former Member
0 Kudos

Try transaction CS15. This is a where used listing.

Former Member
0 Kudos

Hi Bernhard,

I think the easiest way to find out if and where a material is used in a BOM (as a header and as a BOM position) is to display the product structure.

Open the material in MM03, then in Menu Environment->Product Structure.

You will see all dependencies.

Best regards,

Andreas

Former Member
0 Kudos

How do I know to which header material it is asigned/tied to?

Thanks

Ravi

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

That's pretty basic thing, just check against the table MAST with material number and plant, if there is a record, then this material is tied to a BOM.

data: xmast type mast.

select Single * from mast into xmast
           where matnr = p_matnr
             and werks = p_werks.

Regards,

Rich Heilman