List of Contributions

Sigrid Kok

Contact Details

My Content

1 to 20 of 50+ total

RE: Query to retrieve any non matching data from two tables

Posted By Sigrid Kok 06-19-2025 14:30
Found In Egroup: Automate \ view thread
Hi Andrew The same query I suggested with a left outer join will work for your purposes. Just remove the conditions on sales org is null and product hierarchy is not null. The key is the left outer join on MVKE - so it will include all materials, and if sales data exists, it will be pulled in. If ...

RE: New Educational Webinar - Updates for Fiori automation in version 25.1 on July 17th, 2025

Posted By Sigrid Kok 06-19-2025 13:56
Found In Egroup: Automate \ view thread
Sorry, Anita. Does this one work: https://event.on24.com/wcc/r/4998870/D0EA2A6C4468EE99EF4E5D710348D665?partnerref=Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------------------

RE: Query to Pull When the last time a Material has been ordered by Plants and material types

Posted By Sigrid Kok 06-18-2025 16:32
Found In Egroup: Automate \ view thread
HI Carlos One place to check is for delivery complete - it's at the line item level X means complete and space means not. Will that work? Best Regards, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------------------

RE: Does Looping works with CK74N?

Posted By Sigrid Kok 06-18-2025 14:08
Found In Egroup: Automate \ view thread
Hi Nart This isn't an area that I know very well, so I can answer in general terms. In a loop, you want a repeatable step or set of steps. if you're adding rows, you want to have the same row empty each time. Do that with an insert row button - or use the navigation on top to page to the bottom ...

RE: Recording a Web Dynpro application using Gui for HTML

Posted By Sigrid Kok 06-18-2025 13:58
Found In Egroup: Automate \ view thread
Hi Anita Unfortunately Webdynpro is the one interface we do not support - not in the Web GUI or Fiori. Is there an alternative tcode or app we can automate to accomplish the same thing? Best Regards, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ---------------- ...

RE: BP Partner Functions - Adding a new line to a variable length list with Automate Studio in SAP

Posted By Sigrid Kok 06-18-2025 13:57
Found In Egroup: Automate \ view thread
Glad it might work for you, Samuel! ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------------------

RE: Execute query with output still in excel via Evolve form.

Posted By Sigrid Kok 06-17-2025 17:56
Found In Egroup: Automate \ view thread
Hi Renette While that may be possible, I think it would be tricky. You may be able to find a way to write search criteria from the form to the Excel workbook, and then use the IN operator to read the search criteria from the workbook. Then you would want to execute the script. That may be possible ...

RE: VA01 SAP GUI Script changing text language

Posted By Sigrid Kok 06-17-2025 17:51
Found In Egroup: Automate \ view thread
Hi Jody If you have the function module installed, you can use the Add Long text option, which allows you to select one or multiple text types and input a language. Having said that, the sales order must exist to add the long text this way. It allows you to upload and download long text as one long ...

RE: BP Partner Functions - Adding a new line to a variable length list with Automate Studio in SAP

Posted By Sigrid Kok 06-17-2025 17:35
Found In Egroup: Automate \ view thread
Hi Samuel Business Partner can be a beast to automate, and partner functions make it even "funner" :) Here is my "trick", but you may have to adjust based on your partner types. Here is the full screen for partners I click in Partner type and click sort descending. For me that puts SP on the ...

RE: ME21N - Stock Transfer PO (UB) - Supplying Plant issue

Posted By Sigrid Kok 06-17-2025 15:53
Found In Library: Automate

RE: ME21N - Stock Transfer PO (UB) - Supplying Plant issue

Posted By Sigrid Kok 06-17-2025 15:53
Found In Egroup: Automate \ view thread
Hi Lisa Thanks for jumping in @Vanessa Kutasi! I have a script I created in version 10 that still works :) , but I just did a save as new release. I'm attaching it. The doc type has to be swapped, which I'm sure you're aware of. And we recommend BATCH mode recordings for ME21N, which is my ...

New Educational Webinar - Updates for Fiori automation in version 25.1 on July 17th, 2025

Posted By Sigrid Kok 06-17-2025 15:31
Found In Egroup: Automate \ view thread
Hi Automate Community For any of you interested in Fiori automation, I'll be doing a follow-up educational webinar on July 17th introducing the exciting new features in 25.1 and also speak to what is coming on the roadmap. Last month, my colleague Hunter showed you Fiori and GUI for HTML automation. ...

RE: Report in Evolve - User history in Evolve

Posted By Sigrid Kok 06-17-2025 11:40
Found In Egroup: Automate \ view thread
Hi Kitrine There are two views with this information RPT_LicenseDetailsView for licenses, including who assigned it RPT_UserView with user information Here's an example query, which may have way too much info, but you can pare it back: SELECT /* license view */ [ProductName] ,[LicenseTypeName] ...

RE: Tip of the week - Adaptive Query Throttling (AQT)

Posted By Sigrid Kok 06-17-2025 11:21
Found In Egroup: Automate \ view thread
Great tips, Tammy. I'd like to add that for long running queries, that including a lot of data, you may experience a timeout. Use chunking to return the data in "chunks", as Tammy suggested, but it also keeps the connection to SAP alive, which lowers the chance of a timeout. Best Regards, Sigrid ...

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

Posted By Sigrid Kok 06-11-2025 20:34
Found In Egroup: Automate \ view thread
Hi Knavis, Sorry if I missed that. There isn't the same ability to add Ands and Ors to scripts mapped to XML. You might be able to accomplish the same with (1) IN operator (2) Nested IF's with Else's. Maybe something similar to: (3_ I was able to map to Excel and add it and then change mapping ...

RE: Script fails after the first row - IR02

Posted By Sigrid Kok 06-11-2025 14:28
Found In Egroup: Automate \ view thread
Hi Mark This was a bit of a puzzle. It seems to stop with the message on the first one and then the rest don't run, because it's expecting the initial screen where you enter plant and work center, but it's stuck here: I tried to add an EXIT step at the end - no good. I tried to back out of the ...

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

Posted By Sigrid Kok 06-10-2025 17:56
Found In Egroup: Automate \ view thread
Hi Knavis It looks like you did it already :) You would basically do the same type of IF statement - and you can use AND's and OR's. You can also use the IN operator for something like above. When you create that IF statement, it is going to ask for a fieldname, which will then be mapped to a field ...

RE: Update Classifications

Posted By Sigrid Kok 06-06-2025 10:12
Found In Egroup: Automate \ view thread
Hi Nart, You're mixing technologies and thus approaches again. :) BAPIs might populate the commodity code - I haven't tried the ones Ed mentioned. But Fiori can do the same another way. Fiori uses unpublished APIs under the covers to interact with SAP. They may end up running ABAP and thus a ...

RE: Update Classifications

Posted By Sigrid Kok 06-05-2025 10:17
Found In Egroup: Automate \ view thread
Hi Nart, That would be the Fiori automation. You would use the screen you have to search for a material to classify or reclassify, open it and assign/reassign a classification that relates to import/export. I haven't tried Tariffs, but I imagine it would be similar. It's a super simple recording ...

RE: Update Classifications

Posted By Sigrid Kok 06-05-2025 10:13
Found In Egroup: Automate \ view thread
That's super helpful to know, @Ed Meiners, thanks! :) Yes, the automating the Fiori apps are easier. But I'm a big fan of BAPIs/rFMs, as many people know, and options are a good thing! Best Regards, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------- ...