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.  CS02 - BOM Download.Qsq

    Employee
    Posted 04-15-2020 10:48
      |   view attached

    Uploaded CS02 - BOM Download query and have made some changes because I needed more fields then just the basic. I want to only find active BOM components with a "Valid To" of today or later.

    Do you know how I can bring in RC29P-DATUB and make it > (todays date) so I only see valid data?



    ------------------------------
    Randy Springer | Sr MDM Analyst
    Timken | 2342622624
    ------------------------------


  • 2.  RE: CS02 - BOM Download.Qsq

    Employee
    Posted 04-16-2020 10:40
    Hi Randy

    Hope you're well. 

    There isn't an end date in the tables.  You might check for views, infosets or logical databases that may have it.  You could also use a BAPI, which works pretty well, especially if you have revisions/change numbers:  BAPI_CSAP_MAT_BOM_READ

    Am attaching a query that seems to work without end date.  I can't tell if you've already tried something similar, because I can't see all of the tables you're using, so I hope it helps.

    Best Regards,
    Sigrid

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

    Attachment(s)

    xlsx
    QueryBOMItems.xlsx   6 KB 1 version
    Qsq
    QueryBOMItems.Qsq   266 KB 1 version