List of Contributions

Derek Sayres

Contact Details

My Content

1 to 20 of 27 total
Posted By Derek Sayres 02-22-2023 09:14
Found In Egroup: Automate
\ view thread
Hi Benjamin, Transaction CR12 might help you search for the capacity and then update it. It also might help to populate all possible data and then putting IF statements on it where it will update if not blank. Derek ------------------------------ Derek Sayres | SAP PLM Business ...
Posted By Derek Sayres 04-28-2022 10:19
Found In Egroup: Automate
\ view thread
Hi Marcel, If you don't consistently see the same popup you can find the popup in the recording and change it to be "skip if not found." Another option might be recording in batch mode. The input screens will look a little different but it might make the recording process easier. Regards, ...
Posted By Derek Sayres 04-27-2022 09:51
Found In Egroup: Automate
\ view thread
Hi Marcel, do you have a screen shot of the additional popup? ------------------------------ Derek Sayres | SAP PLM Business Analyst ------------------------------
Posted By Derek Sayres 10-20-2021 12:28
Found In Egroup: Automate
\ view thread
Hi Tracy, I've also used a GUI script method where I Upload the new text from a .txt file stored locally. If your text is the same you only need a single .txt file to target. You can set it up to delete all existing text first and then perform the upload function. If your text varies a lot and ...
Posted By Derek Sayres 03-16-2021 12:37
Found In Egroup: Automate
\ view thread
Hi Sigrid, thank you for the kind words. I have my fields from the tables (not the structures), but I'm lost on how to differentiate when it's the same field. https://answers.sap.com/questions/12676385/transaction-cr03-field-rc68a-kapart---where-is-it-.html Thanks, Derek -- ...
Posted By Derek Sayres 03-15-2021 17:11
Found In Egroup: Automate
\ view thread
Hello, I am creating a work center or resource query that will pull data from the capacities and scheduling tabs. Some of the data is shared between the tabs - the Capacity category and the formulas. Here is the technical info from the capacity tab: Here is the technical info from the scheduling ...
Posted By Derek Sayres 01-29-2021 07:49
Found In Egroup: Automate
\ view thread
One thing you could is load one record manually and compare that to the one second time. Maybe one second isn't so bad? Also, if you can run it on server the processing time might not seem to be as bad since it frees up resources on your computer. Thanks, Derek ------------------------------ ...
Posted By Derek Sayres 01-27-2021 15:51
Found In Egroup: Automate
\ view thread
Just a little more info - part of the reason I want to use the function module is so I can update more than just the operation short text I have in the description. It looks like this could be used for modifying existing routing steps, creating new ones and deleting old ones based off the values for ...
Posted By Derek Sayres 01-27-2021 15:43
Found In Egroup: Automate
\ view thread
Hello, I am trying to create a direct script using the ROUTING_MAINTAIN function module. Just as a test I'm passing the material number, plant, group counter and a change master number and the operation / activity number. The field I am changing is the operation short text description. It's ...
Posted By Derek Sayres 10-15-2020 14:37
Found In Egroup: Automate
\ view thread
if you want to go the query route there is a LDB set up - it's CMC. I have had success with this one and it's very fast. it's possible to have the MAST table (document table) + the STKO (BOM header table or you can have the MAST table + STPO (BOM item info) and if needed the STPU (BOM sub-items). ...
Posted By Derek Sayres 10-13-2020 08:01
Found In Egroup: Automate
\ view thread
One thing I have done for "querying" long text is to download it into a text file. We have also had our IT developers create a wrapper for a BAPI to be able to run a direct script in Winshutte. If you go the download method you can save the text file to a targeted directory. From there I use VBA to ...
Posted By Derek Sayres 09-29-2020 11:24
Found In Egroup: Automate
\ view thread
Hello Camp Winshuttle: I am a business analyst at Entegris. We use Foundation 11 and Studio 12. Winshuttle has helped us succeed with large scale projects, creating and loading litterally millions and millions of lines of data. I don't have any single big tip, but there are a few smaller ones that ...
Posted By Derek Sayres 08-27-2020 16:27
Found In Egroup: Automate
\ view thread
Thank you both very much! That really helped me get closer. I am now experiencing a different issue where I am getting too many results. for this particular reference operation set I have 38 entries, the PLPO table has 76 entries based off changes, the PLAS table has 42 entries, only two of them have ...
Posted By Derek Sayres 08-25-2020 22:07
Found In Egroup: Automate
\ view thread
Hello, I am trying to query reference operation set header data and operation numbers. I am passing in task list type S, the group number and the plant from the PLKO table. I would like to see all of the operation numbers listed (column H). When I go into SE16 to check the results I am ...
Posted By Derek Sayres 06-04-2020 09:29
Found In Egroup: Automate
\ view thread
agreed on the error messages. it would also be pretty amazing if the bapi script error handling could be more descriptive. sometimes direct scripts will show it as the orange background an say errors have occurred but the updates still took place. ------------------------------ Derek Sayres | SAP ...
Posted By Derek Sayres 05-15-2020 07:59
Found In Egroup: Automate
\ view thread
Hello, I have seen this issue before when pulling published Direct or Query from Foundation. When I open the local file that was published I am able to see the workspace and copy / modify as needed to create a new one. I am using version 11. Thanks for any insight from case 39065. Derek ...
Posted By Derek Sayres 05-13-2020 09:42
Found In Egroup: Automate
\ view thread
I would like to see a Pause / Play button in the client or in the Excel add-in. ------------------------------ Derek Sayres | SAP PLM Business Analyst ------------------------------
Posted By Derek Sayres 03-31-2020 16:15
Found In Egroup: Automate
\ view thread
Hi Sigrid and James, thanks for the replies. I am using version 12.1. The BAPI I am using is also changing several other fields in the material master. I see the 264 limit in the BAPI_MATERIAL_SAVE. However, when I had 264 characters in Excel it cut off at 131 characters. I did try the ...
Posted By Derek Sayres 03-30-2020 19:17
Found In Egroup: Automate
\ view thread
Hello, I am using the BAPI_MATERIAL_SAVE data to add basic data long text with a loop. When it starts the next line with the loop it is adding an extra space. So if a word happens to be in the middle of the 72 character limit for the row it will have a space in it. Any ideas on how to not have a space? ...
Posted By Derek Sayres 12-04-2019 11:15
Found In Egroup: Automate
\ view thread
Hello, I am querying the DRAW table, trying to find the highest version number of a document. I can query for the document, but it's returning all versions. Is there a way to find only the latest released version? Thanks, Derek ------------------------------ Derek Sayres | SAP PLM ...