List of Contributions

Knavis McGowan

Contact Details

My Content

1 to 20 of 41 total

Performance Optimization for Evolve Dropdowns with large amount of values

Posted By Knavis McGowan 09-20-2025 13:37
Found In Egroup: Automate \ view thread
Hello all, We have a form solution for Updating Material data in SAP. This form has several drop-down elements that contain thousands of records and the range for these drop-downs is pulling from an SQL Data Connection. If there is a request submitted for hundreds of material updates, the form performance ...

RE: Tip of the Week - Using Transaction to DOWNLOAD long text

Posted By Knavis McGowan 07-25-2025 12:45
Found In Egroup: Automate \ view thread
Hi Anne-Claude, We currently use FM /WINSHTLQ/TRN_CREATE_TEXT to update any type of long text (Customer, Material, Vendor, etc.). There is a helpful guide for it listed here: https://help.precisely.com/r/n/Automate-Function-Module/pub/Latest/en-US/Automate-Function-Module/WINSHTLQ/TRN_CREATE_TEXT? ...

RE: Adding "AND" or "OR" to if conditions in XML for Automate Studio

Posted By Knavis McGowan 06-13-2025 12:53
Found In Egroup: Automate \ view thread
Hi Sigrid, So if you change the data set to Excel, add in the new condition group, then change it back to XML, the script will keep the if condition intact and it worked correctly in the form for me. Not sure why there isn't an option in Studio Web-Form(XML) data sets to easily add to these if conditions. ...

RE: Adding "AND" or "OR" to if conditions in XML for Automate Studio

Posted By Knavis McGowan 06-10-2025 22:10
Found In Egroup: Automate \ view thread
Hi Sigrid, Thank you for the detailed response. I found this if condition in an old script that was created by a developer who no longer works for our company so it was not me who created it. I am however tasked with fixing/adding to it! I am still confused on how to add another "OR" to the current ...

Adding "AND" or "OR" to if conditions in XML for Automate Studio

Posted By Knavis McGowan 06-10-2025 13:22
Found In Egroup: Automate \ view thread
Hi all, This may be an easy one (hopefully) but how do we add "AND" or "OR" into XML if conditions in the expert view of the Studio mapper? It seems straightforward when the data set is Excel but I cannot figure out how to accomplish this in Web-Form (XML) data sets. I know it must be possible because ...

Change Inspection Type field data

Posted By Knavis McGowan 04-17-2025 16:11
Found In Egroup: Automate \ view thread
Hi all, I am attempting to create a script that can change specific fields for a given Inspection Type listed on a material. I only saw a few posts for this and was not able to find a solution so far. I am unable to use GUI scripting for my system. In the MM02 Inspection Type screen, there is no ability ...

RE: Query syntax for Reference List data in Automate Evolve Composer

Posted By Knavis McGowan 10-15-2024 13:14
Found In Egroup: Automate \ view thread
This worked for me, thanks Sigrid! ------------------------------ Knavis McGowan Master Data Specialist ABBOTT RAPID DX INTERNATIONAL LIMITED FL ------------------------------

Query syntax for Reference List data in Automate Evolve Composer

Posted By Knavis McGowan 10-14-2024 16:12
Found In Library: Automate

Query syntax for Reference List data in Automate Evolve Composer

Posted By Knavis McGowan 10-14-2024 16:12
Found In Egroup: Automate \ view thread
Hello all, I am using the Query form element to connect to reference list data in order to populate a table within my form. My issue is that I want to filter on a column in the reference list that has multiple values that are comma separated. Does anyone know the correct syntax to use here for something ...

RE: Remove/Delete Material Characteristic Value in MM02

Posted By Knavis McGowan 05-22-2024 12:30
Found In Egroup: Automate \ view thread
Thanks for the reply, Sigrid. I do have binoculars that I am using to search using either the characteristic descriptions or values but the issue was that it was having trouble accurately finding our Country codes in characteristic values i.e. if I searched for "CN" to delete this entry, it would display ...

RE: XD01 Warning Message

Posted By Knavis McGowan 05-17-2024 13:06
Found In Egroup: Automate \ view thread
Hi Kalaivani, If the popup message you're referring to is the "Reference account group is WDC Sold-to party" warning, then it doesn't look like this pop-up is mapped in your script. I would suggest to either re-record and make sure this popup displays during recording so your script knows how to handle ...

Remove/Delete Material Characteristic Value in MM02

Posted By Knavis McGowan 05-16-2024 15:49
Found In Egroup: Automate \ view thread
Hi everyone, I am attempting to create an SAP MM02 script that has the ability to add, insert and/or delete characteristic values for different classifications. I have it working for add/insert for all values but the issue is with delete. We have characteristic values that are non-unique i.e. the same ...

Remove/Delete Material Characteristic Value in MM02

Posted By Knavis McGowan 05-16-2024 15:48
Found In Library: Automate

RE: Material BAPI - Plant Extension

Posted By Knavis McGowan 11-18-2022 11:13
Found In Egroup: Automate \ view thread
Thank you Jan/Sigrid for the replies! My custom FM ZMM_BAPI_MAT_SAVE_DATA is supposed to utilize BAPI_MATERIAL_GETINTNUMBER and complete this process for me. It does work for internal numbering during initial material creation but it errors during extending the material to the plant. I have decided to ...

Material BAPI - Plant Extension

Posted By Knavis McGowan 11-15-2022 11:15
Found In Egroup: Automate \ view thread
Hello all, I am attempting to create a script for material plant extension. I began this process using Winshuttle Direct custom FM ZMM_BAPI_MAT_SAVE_DATA (this FM is very similar to BAPI_MATERIAL_SAVEDATA) and was able to successfully extend a material type that utilized external numbering but am ...

Material BAPI - Plant Extension

Posted By Knavis McGowan 11-15-2022 11:14
Found In Library: Automate

RE: Script gives error during Run, but in Debug it works without any changes in the data file

Posted By Knavis McGowan 10-21-2022 13:01
Found In Egroup: Automate \ view thread
Hi Spyridon, I had a similar issue in a recent script I created for adding classifications in MM01. I ended up solving this by setting the solution property "Renew session after [n] transactions" to the value of "1" in an effort to "slow the script down" when it is running. Give it a try, hope ...

Query - Write Records per Line based on Input Row

Posted By Knavis McGowan 09-12-2022 13:38
Found In Library: Automate

Query - Write Records per Line based on Input Row

Posted By Knavis McGowan 09-12-2022 13:38
Found In Egroup: Automate \ view thread
Hello all, I am trying to develop a query where I can have one column of input criteria that the user provides (in my script, it is Location Code field in SAP) and then the output information is customer data based on that field. I am able to get information returned from SAP but it is never on the ...

RE: Building a Query for Multiple Rows of Customer Data

Posted By Knavis McGowan 09-09-2022 12:46
Found In Egroup: Automate \ view thread
Thank you Scott! Now my script runs all the way down the list. My next issue I am trying to figure is how to skip duplicates or blank rows. If those are included in the data set, it throws off the output data from SAP. Ideally, the user would fix this beforehand in their external spreadsheet but this ...