List of Contributions

Andrew Lewis

Contact Details

My Content

1 to 20 of 35 total

RE: Updating MRP Area

Posted By Andrew Lewis 10-15-2025 07:18
Found In Library: Automate

RE: Updating MRP Area

Posted By Andrew Lewis 10-15-2025 07:18
Found In Egroup: Automate \ view thread
Hi Maria I've been trying to work out how to get the GUI script [Identify Fields] to pick up the correct MRP Area but not having much luck at the moment. It seems to be picking up the MRP Area at position 4 regardless if it's not the right one or not. Would you be able to point me in the right direction ...

RE: MM02 Update Alt Language Descriptions

Posted By Andrew Lewis 08-22-2025 04:05
Found In Egroup: Automate \ view thread
Hi Oddgeir Thanks for the quick response! I am unable to use this feature using T-Code MM02 and receive a pop up error telling me so. Is there another way to update a description without using a BAPI because it is company policy to use a Change Number for all master data changes. Thanks ----- ...

MM02 Update Alt Language Descriptions

Posted By Andrew Lewis 08-22-2025 03:33
Found In Egroup: Automate \ view thread
Hi, Does anyone know how to go about updating a specific language description in MM02? I tried recording a GUI script but it doesn't select the language ID and I can't see a way in MM02 to select a particular line/language. I saw a post on here explaining how to do this but the link didn't lead anywhere. ...

RE: Pop up prompt not being selected before saving

Posted By Andrew Lewis 07-29-2025 03:13
Found In Egroup: Automate \ view thread
Hi Sigrid Thanks for the prompt reply. I did run n debug mode but it just wouldn't process the final [YES] confirmation although it worked fine in DEV and QA systems. I'll wait for Kelly to respond below as she may have a solution for this. Will keep you posted! ------------------------------ ...

RE: Pop up prompt not being selected before saving

Posted By Andrew Lewis 07-29-2025 03:10
Found In Egroup: Automate \ view thread
Hi Kelly Thanks for this, can you let me know what steps you took to allow testing on the production SAP system to record the final steps please? ------------------------------ Andrew Lewis Global Master Data Analyst QuidelOrtho Wales United Kingdom www.QuidelOrtho.com -------------------------- ...

Pop up prompt not being selected before saving

Posted By Andrew Lewis 07-28-2025 13:54
Found In Egroup: Automate \ view thread
Guys I have a script that was created for our new S/4 HANA system to update the purchasing and MRP Views. It runs fine but just before saving, the pop up prompt box appears and doesn't select "Yes" as per the recording. I can't see anything wrong? and have re-recorded the steps exactly but looks ...

RE: How to pull all data including empty fields in a query script.

Posted By Andrew Lewis 06-25-2025 08:28
Found In Egroup: Automate \ view thread
Hi Vanessa I created a query script that seemed to work fine until I pulled a report from MARA to show a different number of materials than the unique number of materials in the query. What I'm trying to achieve is the query pulls ALL of the materials from MARA, populates the product hierarchy ...

RE: How to pull all data including empty fields in a query script.

Posted By Andrew Lewis 06-25-2025 08:27
Found In Library: Automate

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

Posted By Andrew Lewis 06-20-2025 04:06
Found In Library: Automate

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

Posted By Andrew Lewis 06-20-2025 04:06
Found In Egroup: Automate \ view thread
Hi Sigrid Thanks very much for the quick response. I have added the left outer join as suggested and it's working perfectly. Tanks you so much for your support. Andy ------------------------------ Andrew Lewis Global Master Data Analyst QuidelOrtho Wales United Kingdom ww ...

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

Posted By Andrew Lewis 06-19-2025 06:56
Found In Egroup: Automate \ view thread
Thanks Sigrid What I'm ideally looking to create is like what you have suggested by I need to see ALL of the Product Hierarchy's in both MARA and MVKE whether they're blank or populated and also if the Sales Views haven't been created then the value should be blank so that it leads to further investigations ...

How to pull all data including empty fields in a query script.

Posted By Andrew Lewis 06-19-2025 04:35
Found In Egroup: Automate \ view thread
Guys Does anyone know how to get a query script to pull not only data but empty fields as well to see what fields are missing data? For example, I created a query to pull the product hierarchy data but it is only returning fields that have been populated in both MARA and MVKE, it doesn't return any ...

Query to retrieve any non matching data from two tables

Posted By Andrew Lewis 04-28-2025 04:00
Found In Egroup: Automate \ view thread
Hi guys I'm looking to develop a query script which looks at both the Product Hierarchy fields in the Basic Data 1 (MARA-PRDHA) and Sales Org 2 (MVKE-PRODH) material master views to ensure they match BUT, want the query to ONLY retrieve any potential mismatches. Does anyone know of a way to do this ...

RE: Script database search by technical field name

Posted By Andrew Lewis 03-07-2025 03:03
Found In Egroup: Automate \ view thread
Hi Sigrid Thanks for the quick response! OK, so, we have over 200 scripts in Production and are currently in the process of creating new mirrored scripts that work in S4 (there's a project to replace our 3 current SAP systems into a S4 solution). When a requestor asks us that they want to mass update ...

Script database search by technical field name

Posted By Andrew Lewis 03-06-2025 09:43
Found In Egroup: Automate \ view thread
Hi everyone. I'm wondering if anyone has developed a database or similar which auto updates with any new scripts in production? We have an access database which can be very time consuming to keep updated. Does anyone know a way to search the current list of scripts in the production environment which ...

RE: Update Payment Terms with BP

Posted By Andrew Lewis 10-18-2024 02:53
Found In Egroup: Automate \ view thread
Hi Maria Thanks ever so much for your help, the script now works seamlessly. Many thanks again Andy ------------------------------ Andrew Lewis Global Master Data Analyst QuidelOrtho Wales United Kingdom www.QuidelOrtho.com ------------------------------

RE: Update Payment Terms with BP

Posted By Andrew Lewis 10-16-2024 04:13
Found In Egroup: Automate \ view thread
Hi Maria I made the changes you suggested and although the first run failed with errors, the second run worked without error? I've attached the script and template as requested so you can see what I mean. The vendors have been duplicated (highlighted in green in the second half) with the original ...

RE: Update Payment Terms with BP

Posted By Andrew Lewis 10-16-2024 04:12
Found In Library: Automate

RE: Update Payment Terms with BP

Posted By Andrew Lewis 10-15-2024 03:27
Found In Egroup: Automate \ view thread
Hi Maria, Many thanks for getting back to me and I have made the adjustments in the script as per your suggestion but I still cannot get it to work. Running row 3 in debug mode, it doesn't seem to be resetting back to the beginning. I'll keep trying and see what I can do but if could possibly take ...