List of Contributions

Sigrid Kok

Contact Details

My Content

1 to 20 of 50+ total

RE: Capture Errors and Validation from display message dialog box in SAP to Logfield

Posted By Sigrid Kok 03-27-2025 11:37
Found In Egroup: Automate \ view thread
Hi Veena Have you tried enabling "Extended Log". You can see it near the top in Expert Mode in the mapper. It should capture more messages - warning and errors, but sometimes it depends on the tcode, as messages in a pop-up may not be captured, but it's worth a try. Please note it is available only ...

RE: Query Is Timing Out

Posted By Sigrid Kok 03-25-2025 21:13
Found In Egroup: Automate \ view thread
Hi Michelle Don't have time to look at this in depth as I did with your other questions, but here are some things to look for in general join on key fields whenever possible use criteria on key fields when possible if you have a lot of data to return or in your SAP system to go through, consider ...

RE: Disable the ability to delete a row in a repeating table

Posted By Sigrid Kok 03-25-2025 21:07
Found In Egroup: Automate \ view thread
Hi James, Based on a bit of poking around, it was in the product at least by 20.2, so you should have something similar. https://docs.precisely.com/docs/sftw/automate-evolve/20.2/en-us/webhelp/OnlineHelp/Content/Online_Help/solution-developer-help/rules.html search for 'delete row options' FYI ...

RE: Disable the ability to delete a row in a repeating table

Posted By Sigrid Kok 03-25-2025 13:00
Found In Egroup: Automate \ view thread
Hi James Am on v24.1, and there is a rule that allows you to turn this option on and off. I'm not 100% sure when it was added, though, but a good reason to stay up to date. :) With it disabled, I can only insert rows HTH Sigrid ------------------------------ Sigrid Kok *Precisely Software ...

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Sigrid Kok 03-25-2025 12:53
Found In Library: Automate

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Sigrid Kok 03-25-2025 12:53
Found In Egroup: Automate \ view thread
Hi Michelle You can do it in two pieces - as I've done this a number of times for different use cases. The first query does everything but the remark and includes a vlookup for the remark value, creating a key with customer, address # and sequence # of the email address. The second query leverages ...

RE: Editing A Query Created By Another Developer

Posted By Sigrid Kok 03-25-2025 09:29
Found In Egroup: Automate \ view thread
Hi Michelle If you are desktop, open it from wherever it's stored. If on a server-based product, you can open it from the server and then save a local copy to workout your changes and then re-submit it once done. Or you can go to the server site - like in Studio manager, view the solutions, and ...

RE: Editing A Query Created By Another Developer

Posted By Sigrid Kok 03-24-2025 14:16
Found In Egroup: Automate \ view thread
Yes, Michelle. It's only limited by (1) your license type - Developer is needed (2) and if you have server-based products like Studio Manager or Evolve, by your access to the App they are stored in. Best Regards, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------- ...

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Sigrid Kok 03-24-2025 14:14
Found In Egroup: Automate \ view thread
Thanks, Michelle. I believe the left outer join should be between ADRC and ADR6 - with ADR6 having the email address. So customers have an address, thus an inner join, but as you are stating, they may not have an email address. That works until you try to join ADR6 to ADRCT. Now those two tables ...

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Sigrid Kok 03-24-2025 12:27
Found In Egroup: Automate \ view thread
Hi Michelle Can you share your query & also if you are on ECC or S4? Thanks, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------------------

RE: Struggling with Table Joins to Return All Records in Studio Queries

Posted By Sigrid Kok 03-24-2025 11:08
Found In Egroup: Automate \ view thread
Hi Michelle This is a safe space to ask questions. :) In general, it sounds like a left outer join would work, which means it would join with the table holding the email address if there was an entry or not an entry. You can right click on the join link and switch it to a left outer join. Please ...

RE: Lock down Studio Queries

Posted By Sigrid Kok 03-21-2025 14:48
Found In Egroup: Automate \ view thread
Hi Joseph The roles you are likely pointing to in Evolve pertain more to form solutions than scripts. A few things come to mind: (1) we use SAP security to access the underlying data, so anyone who runs them will need permissions for the underlying tables. And if you use security objects like ...

RE: Important Reminder for Automate Studio with Connect customers

Posted By Sigrid Kok 03-18-2025 10:07
Found In Egroup: Automate \ view thread
Thanks, Tim. I'd like to reiterate the importance of this announcement if you're using Studio without User Governance/Studio Manager or Foundation/Evolve. Standalone Studio versions prior to v24.0 use Connect, our cloud-based license management system. That will stop working September 1st, 2025. ...

Tip of the Week – Search for BAPI in Direct - check in SE37 for remote-enabled

Posted By Sigrid Kok 03-12-2025 19:46
Found In Egroup: Automate \ view thread
Automate Studio provides the ability to leverage BAPIs or remote-enabled Function Modules (rFM) in Direct. Those who know me know I'm a fan of using Direct, especially for complex transactions where it's not simple to automate, it's also great for efficiency and resiliency as they keep working – even ...

RE: Script database search by technical field name

Posted By Sigrid Kok 03-11-2025 09:22
Found In Egroup: Automate \ view thread
Sorry, Andrew. I don't know of a way to do this. Maybe some of our creative customers have ideas? :) Best Regards, Sigrid ------------------------------ Sigrid Kok *Precisely Software Inc. ------------------------------

RE: Add Window that is not recorded.

Posted By Sigrid Kok 03-11-2025 09:15
Found In Egroup: Automate \ view thread
Hi Ben In general, you position on a field and hit F1 and then selected technical details. You will see the screen name and # and technical field info. But your example is an informational message, there are no fields. If this is stopping your script from running, you may need to look for a BAPI ...

RE: Script database search by technical field name

Posted By Sigrid Kok 03-06-2025 22:31
Found In Egroup: Automate \ view thread
Hi Andrew Not that I know of. I believe scripts are "blobs" in the backend server database. Query scripts may have an attribute of list of tables, but I don't believe we expose fields for any script type. What is the use case for this? Are you trying to determine which scripts to update if you make ...

RE: Required fields on specific views

Posted By Sigrid Kok 03-06-2025 22:28
Found In Egroup: Automate \ view thread
Hi Scott Am juggling a bunch of things & don't have time to test a theory, but here goes. Can you use a form view rule which runs on load to require a field, and when you submit/approve/complete the task, use a rule to un-require it? Just a quick thought. :) Sigrid ------------------------------ ...

RE: Address field 2,3, and 4

Posted By Sigrid Kok 02-28-2025 20:22
Found In Egroup: Automate \ view thread
Hi Susan For this use case, I would use IF statements in my script and only upload if the line is not blank. For scripts that are mapped to use in forms, you would enter a variable name, and that variable can be mapped to the same field in the form as the address line manually. If formstreet4 is ...

RE: GUI Scripts with position to a relative row

Posted By Sigrid Kok 02-18-2025 14:38
Found In Egroup: Automate \ view thread
Hi Jane In general I would recommend a few different approaches GUI scripting with an Indexed IF - documentation linke: https://help.precisely.com/r/t/1016755804/2023-12-31/Automate-Studio/Connect/Latest/en-US/Automate-Studio-with-Studio-Administrator-User-Guide/Add-If-conditions or a BAPI or ...