Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  BOM query for CS02

    Posted 10-14-2020 15:08

    Hi everyone,

     

    Does anyone have a query for extracting BOMs in CS03 or 2? I need to create one from our ECC system so we can load it into S4. I already have the CS01 script I just need something to extract the BOM's.

     

    Thanks

    Cathy

     

    Cathy Suchecki

    EDM GOVERNANCE MANAGER, IT-SAP GLOBAL IMPLEMENTATION BTL

    Weber-Stephen Products LLC

    1415 S Rosele Road, IL 60067 USA

    Tel: 224-654-2255

    Cell: 847-915-5898

    csuchecki@weberstephen.com

     

    Description: Weber_logo_email_signature    

    www.weber.com


    DISCOVER WHAT'S POSSIBLE!

     



  • 2.  RE: BOM query for CS02

    Posted 10-15-2020 03:18

    Hi Cathy,

    I got two QUERY scripts. We're using Studio 12.1. If you'd like to have them just let know :-)

    If you wanna create your own QUERY or if that won't work for you, you could also extract the needed data in two steps using transaction SE16N. First you wanna chose table MAST to get Material and BOM number. Save that. Then you gotta load STPO to get the bom positions. Both tables contain the BOM number. You can match them in excel or QUERY :)

    Hope that helps

    Kind regards

    Iris



    ------------------------------
    Iris Müller | Specialist Data Management
    Thomas Sabo | 09123-9715328
    ------------------------------



  • 3.  RE: BOM query for CS02

    Employee
    Posted 10-15-2020 08:51
    Hi Cathy -

    There is a template in the template library that is for changing a BOM, and that also includes an extract. You can take that and make any adjustments to it that you might need. 

    https://community.winshuttle.com/sap-module-templates/viewdocument/change-material-bom?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments 

    Thank you!

    ------------------------------
    JENNIFER HWANG | SE
    Winshuttle North America
    ------------------------------



  • 4.  RE: BOM query for CS02

    Posted 10-15-2020 14:37
    if you want to go the query route there is a LDB set up - it's CMC. I have had success with this one and it's very fast.

    it's possible to have the MAST table (document table) + the STKO (BOM header table or you can have the MAST table + STPO (BOM item info) and if needed the STPU (BOM sub-items). When you select the CMC LDB it will help guide you for the selection since it cannot have parallel paths.

    ------------------------------
    Derek Sayres | SAP PLM Business Analyst
    ------------------------------

    Original Message


  • 5.  RE: BOM query for CS02

    Employee
    Posted 10-19-2020 18:06
      |   view attached
    Here's an example, Cathy. 

    Please note it uses the conversion exit to get an "English" unit of measure.  Example, PC is stored as ST but can't be loaded into SAP.  So the conversion exit looks up the English version and outputs PC.

    Best Regards,
    Sigrid


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Attachment(s)

    qsq
    BOMQueryByBOMOrComponent.qsq   453 KB 1 version


  • 6.  RE: BOM query for CS02

    Posted 10-20-2020 13:18
    I tried your script and received no results. I put in one material the plant BOM usage alternate BOM and valid from date and nothing showed up. I know the BOM exists. do you have any suggestions?

    Regards,

    Cathy ​

    ------------------------------
    Cathy Suchecki | MDM Data Governance Manager
    Weber-Stephen Products LLC | 2246542255
    ------------------------------

    Original Message


  • 7.  RE: BOM query for CS02

    Posted 10-20-2020 13:35
    I figured it out the material number was looking for the leading zeros. ​

    ------------------------------
    Cathy Suchecki | EDM Governance Manager
    Weber-Stephen Products LLC | 2246542255
    ------------------------------

    Original Message


  • 8.  RE: BOM query for CS02

    Employee
    Posted 10-20-2020 15:53
    Oh good, Cathy!  Hope it works for you!

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message