Skip to Content
avatar image
Former Member

Is there any SAP transaction that shows the where-used list for a mass of materials?

Dear SAP users, is there any SAP transaction that shows the where-used list for a mass of materials?

I'm looking for a transaction to get the BOM in which multiple materials are used.

I’m using CS15 but unfortunately it can be executed for one material at a time.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 09, 2015 at 11:27 PM

    You can develop this using SQVI or Infoset Query by using the Logical databases. Take clues from this link.Making of Boxed Reports for BOMs (using LDBs in Infoset Query)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2015 at 09:12 PM

    If this workaround helps

    SE16D

    query STPO table for COMPONENT , enter list of Materials

    it will return all BOM Numbers

    take them and query MAST table to get BoM Header Material Masters,

    Thanks and regards

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 12:28 PM

    Greetings Amine,

    Use SE16N or SE16 like suggested above, or build a small infoset query using SQ02/SQ01, like also suggested. Your infoset join might look similar to this:


    Capture.PNG (52.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 10:59 AM

    Hi Amine,

    there is also the function module "CS_WHERE_USED_MAT" available.

    It accepts only one mateial per call. But you can use it in a loop in order to get the result for all materials.

    Regards,

    Sebastian

    Add comment
    10|10000 characters needed characters exceeded