Automate

 View Only
  • 1.  ME01 - change fixed indicator

    Posted 11-18-2020 15:41
    Hello!

    I am working on a script to modify a specific line of a Source List:
    • Select Valid To Date
    • Remove Fixed Source Flag
    • Change MRP Flag to <blank>
    In most transactions I would use a position/find function to select the key field, but the only position function available in this transaction is tied to the 'Valid From Date' which does me no good. Does anyone have any tips to select a key field? I've been unsuccessful using Transaction or finding a BAPI or RFM to accomplish this so far.

    ------------------------------
    Kevin
    ------------------------------


  • 2.  RE: ME01 - change fixed indicator

    Posted 11-19-2020 02:19
    Hi Kevin,
    I used GUI scripting to get it working. You can use Vendor Number field as well.

    ------------------------------
    Robert Dudziak | Senior Procurement Operations Analyst
    Kimberly-Clark Corporation | +48 12 291 84 50
    ------------------------------



  • 3.  RE: ME01 - change fixed indicator

    Posted 11-19-2020 10:17
    Thanks, Robert. I think I may have found another way.

    In ME01...Edit>Selections>Flag Selection

    This allows me to enter the combination of Agreement Number and Agreement Item to Select the correct line, delete it, and then re-enter the line minus the two fields I need to remove. 



    ------------------------------
    KevinMaster Data
    ------------------------------



  • 4.  RE: ME01 - change fixed indicator

    Posted 11-20-2020 01:51
    Hi Kevin,
    It sounds like very interesting solution. I need to think about it and test it :)! 
    My current script is rather slow.

    ------------------------------
    Robert Dudziak | Senior Procurement Operations Analyst
    Kimberly-Clark Corporation | +48 12 291 84 50
    ------------------------------



  • 5.  RE: ME01 - change fixed indicator

    Posted 11-20-2020 06:01
    Hi Kevin and Robert,
    We have many instances when we have to add a new fixed vendor to a source list that already has a vendor that is fixed.  In our case it is a two step process.  We run a GUI script with a IF on INDEX condition to locate the existing vendor with the fixed flag to remove the indicator.  Then we run another ME01 transaction script to add the new vendor with the fixed flag.  I agree, it is a very slow process, especially because of the GUI script which runs in the foreground.  So far I have not figured out a better way to do this.  I have also searched for a BAPI and have come up empty.  Kevin's solution, which is quite clever, wouldn't work for us because we generally don't have scheduling agreements.  It would be great if one of the brilliant Solution Engineers at Winshuttle could come up with another solution.  James Lofgren? Sigrid Kok?  Jennifer Hwang?   Not putting any pressure on you or anything 😊




    ------------------------------
    Monica Anicito | Global Master Data Project Lead
    Ortho-Clinical Diagnostics, Inc., Raritan, NJ
    ------------------------------



  • 6.  RE: ME01 - change fixed indicator

    Posted 11-20-2020 07:03
    Hi Monica,
    I am lucky as I don't have to deal with Outline Agreements yet. So for those I did a script which first go with IF and Index and marks all vendors with Block, and then goes once again with IF and Index and marks selected vendor as fixed :).

    ------------------------------
    Robert Dudziak | Senior Procurement Operations Analyst
    Kimberly-Clark Corporation | +48 12 291 84 50
    ------------------------------



  • 7.  RE: ME01 - change fixed indicator

    Posted 11-20-2020 09:10
    Hi Monica, Robert,
    My solution is pretty specific to this one situation and it requires some pre-work by the user to filter the correct data from the EORD table. Luckily the Agreements are there to give me something to key off of, but it is a lot faster to run than a GUI scripted solution.

    ------------------------------
    Kevin
    ------------------------------