Automate

 View Only
  • 1.  Component Allocation CA02 Support

    Posted 02-21-2019 17:49
      |   view attached
    I am trying to write a query on creating look up of a BOM and lower levels from a group connected to a Group, then a group counter.
    Showing materials assigned or not assigned to an Activity. 

    I am getting the BOM pulled in several time showing the same data.
    As well wanting to see actives not filled in.

    Tables I am pulling off of in this order.
    1) PLMZ (Routing) 
    2) PLPO (Routing)
    3) MAST (BOM)
    4) STPO (BOM)

    If anyone has created this any help would be appreciated.

    ------------------------------
    Benjamin Kielas | SAP Master Data Team Lead
    Generac Power Systems, Inc. | (262) 544-4811
    ------------------------------


  • 2.  RE: Component Allocation CA02 Support

    Posted 03-21-2019 14:09
    Hi Benjamin,

    If you're still experiencing an issue with this script, please put in a Support request and we'll be happy to look at the issue with you.

    https://mysupport.winshuttle.com/hc/en-us/requests/new

    Thanks!

    Winshuttle Support

    ------------------------------
    Winshuttle Support |
    Winshuttle North America |
    ------------------------------



  • 3.  RE: Component Allocation CA02 Support

    Posted 03-21-2019 15:48

    Thank you

    I have already put a request in for support and was told start with a few tables working my way down the data needed.

    I have been doing that and getting to ends I cannot figure out.