Automate

In MD62 the request is to look up and use more then one column (2 or more). The script is currently built to look up the date column and make changes. The ask is now to look up by W (Week) or M (Month) and then the date column. There would be times where Week 7 /2022 and month 7/2022. Dates being the same but the W or M make the deference of when in the year. 
Thank you in advance.

------------------------------
Benjamin Kielas | Supervisor SAP Material Master Data
Generac Power Systems, Inc. | 2625106580
------------------------------

Hi Benjamin -

I am assuming that you are using If on Index functionality to find the appropriate row. Unfortunately, there is not an option to have nested If on Indexes, which is what you would need to be able to use both the Period indicator and the Date as two indexes.  The ability to have nested If on Index statements has been requested as a new feature many years ago, but there is no insight as to if and when this would become available. 

You have two options to explore: 1) use an old school 2-step process where you would download (read script) each set of rows as unique sets of columns first and then have a second script (update script) that would have updates of every row and each set of rows would have if statements referencing the columns that were first downloaded to know which one to update, or 2) explore if there is a BAPI option that may be available. 

Thanks!

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------