List of Contributions

Benjamin Kielas

Contact Details

My Content

1 to 20 of 50+ total

IE02 Proactive Data tab use If on Index condition

Posted By Benjamin Kielas 01-27-2024 11:00
Found In Egroup: Automate \ view thread
Hi everyone, I have been tasked with updating a field on a proactive data tab in our IE02 t-code. I would like to confirm if it is possible to update. The layout looks to be a custom table not allowing GUI scripting to work. I have attached the recording in GUI scripting for reference. Thank ...

IE02 Proactive Data tab use If on Index condition

Posted By Benjamin Kielas 01-27-2024 10:59
Found In Library: Automate

This data file is in read-only mode to preserve any formatting, charts, and other elements. Error message

Posted By Benjamin Kielas 04-28-2023 17:41
Found In Egroup: Automate \ view thread
Looking for help to resolve the error I am having with my current way I am trying to process though the steps. Currently I am running 5 data extracts to get my order numbers I need. I then need to sort them by beginning date. Trying the sort along with using the in function to set my range of orders ...

This data file is in read-only mode to preserve any formatting, charts, and other elements. Error message

Posted By Benjamin Kielas 04-28-2023 17:40
Found In Library: Automate

RE: AFKO Extract table by date vs order number

Posted By Benjamin Kielas 04-28-2023 13:13
Found In Egroup: Automate \ view thread
Thank you  Maria always nice to hear from you. This is a nice tool to have. I am looking up a list of orders from another tab of data. When doing that it will not sort by A to Z as I need it.  ------------------------------ Benjamin Kielas Generac Power Systems, Inc. WAUKESHA WI ------------- ...

RE: AFKO Extract table by date vs order number

Posted By Benjamin Kielas 04-28-2023 13:11
Found In Egroup: Automate \ view thread
Alexey, Could you go more into detail on how you use Power Query with Winshuttle? When I try build in Power Query into my working excel file I get an error message saying the file is in read only mode and will not allow me to run Winshuttle. I have also tried building a power query in its own excel work ...

RE: JEST table Criteria

Posted By Benjamin Kielas 04-20-2023 21:53
Found In Egroup: Automate \ view thread
Thanks for the extra response. What we ended up doing is run three queries. First one with the needed statuses Released and Created.  Second one of the two statuses to not include Deliverd and Deleted. With those two lists I then ran JEST file one more time looking up IN list of the first query and NOT ...

RE: JEST table Criteria

Posted By Benjamin Kielas 04-19-2023 21:08
Found In Library: Automate

RE: JEST table Criteria

Posted By Benjamin Kielas 04-19-2023 21:08
Found In Egroup: Automate \ view thread
Thanks for the quick response on some ideas to try. I tried the IN idea and come up with the same count. I have attached the two step query running AFKO file first to sort out material number and MRP group needed. Then to filter down to status using object to connect. Is my issue doing two steps can ...

JEST table Criteria

Posted By Benjamin Kielas 04-19-2023 17:49
Found In Egroup: Automate \ view thread
I am trying to match a filter being done in COOIS. I have attached a screen showing what the setting is in SAP and what I have build in Windchill but my counts do not come out the same. Any thoughts would be helpful. ------------------------------ Benjamin Kielas Generac Power Systems, Inc. WAUKESHA ...

JEST table Criteria

Posted By Benjamin Kielas 04-19-2023 17:48
Found In Library: Automate

AFKO Extract table by date vs order number

Posted By Benjamin Kielas 03-19-2023 13:28
Found In Egroup: Automate \ view thread
When extracting the AFKO table data as is extract pulls by oldest order number. Is there a way to extract by oldest date and not by lowest order number? When extracting using COOIS the report comes out with oldest date vs oldest order. ------------------------------ Benjamin Kielas Generac Power ...

RE: CR02 Work Center Updates for Capacity

Posted By Benjamin Kielas 02-22-2023 15:41
Found In Egroup: Automate \ view thread
I tested CR12 and looks to skips a few steps from going in though CR02. Thank you for that help. I will review the IF statement and how it may work in this case. ------------------------------ Benjamin Kielas | SAP Data Generac Power Systems, Inc. | 12625106580 ------------------------------ ...

CR02 Work Center Updates for Capacity

Posted By Benjamin Kielas 02-21-2023 21:17
Found In Library: Automate

CR02 Work Center Updates for Capacity

Posted By Benjamin Kielas 02-21-2023 21:17
Found In Egroup: Automate \ view thread
I have been trying to record CR02 using Winshuttle studio Standard, batch, and GUI. I the steps given to me I am unable to search for the shift number to then change the capacity and number of people. GUI script keeps going back to the first line. The best luck I think I have is Standard by looping in ...

CK13N script

Posted By Benjamin Kielas 11-30-2022 16:32
Found In Egroup: Automate \ view thread
Looking for assistance in creating a script that can replace the t-code CK13N. To retrieve numerous materials simultaneously is one of the the request. According to my investigation, there are two tables called KEKO that use the material number and plant to transfer over the cost estimate number KALNR. ...

RE: Looking for help on how to extract Service Notifications long text from IW53

Posted By Benjamin Kielas 08-24-2022 18:27
Found In Egroup: Automate \ view thread
Jayasri, Where I am stuck is knowing what boxes to check and what ones need to be upload and what ones need to be download data. I get an error with the layout I have currently. As well as question if the loop is needed. Any help is appreciated. Trying to understand how to use direct is a challenge ...

RE: Looking for help on how to extract Service Notifications long text from IW53

Posted By Benjamin Kielas 08-24-2022 18:26
Found In Library: Automate

RE: Looking for help on how to extract Service Notifications long text from IW53

Posted By Benjamin Kielas 08-23-2022 10:05
Found In Egroup: Automate \ view thread
Thank you. I will work on testing these options on how to pull the text info. ------------------------------ Benjamin Kielas | Supervisor SAP Master Data Generac Power Systems, Inc. | 12625106580 ------------------------------

Looking for help on how to extract Service Notifications long text from IW53

Posted By Benjamin Kielas 08-19-2022 12:39
Found In Egroup: Automate \ view thread
Is it possible to use Query to retrieve long text from a service notification? What resources are available to guide me through the setup process? Despite spending several hours reviewing online support resources, I can only locate STXL table, which publishes CLISTD field data (FF060201020280003431 ...