Automate

Let me try to explain. 

I have a situation where Material Master Sales Status in MVKE is updated using an MM02 Script in our "Master" Sales Org and then we have a batch SAP process which then updates that Material Status to all other Sales Orgs. So if I change it from Status "A" to "B" in "Master" sales Org... 

The Batch process will then update the Material Status in all Sales Orgs in MVKE to "B".

And that works for all transitions of Material Status...However there is ONE transition in Status that the Batch Process does NOT work for. Lets say it is the transition from Status "C" to Status "A". 

In that particular scenario the batch process does not work. And so for these transitions to happen to all 4 Sales Orgs, they must to be updated by the MM02 Script. The script then requires the template to either contain ALL Sales Orgs not just the one Sales Org (the Master) and so it needs to look something like this ....

Material	Sales Org	Old Status	New Status
1234	1000	A	B	Example 1
1234	1000	C	A	Example 2
1234	2000	C	A	Example 2
1234	3000	C	A	Example 2
1234	4000	C	A	Example 2

My challenge is how can i construct my MM02 script to possibly use a LOOP or a similar mechanism,  that is triggered "if OLD Status = C and New Status = A then repeat loop for all 4 Sales Orgs" 

For the sake of the example we have 4 Sales Orgs 1000,2000,3000,4000. 

Or is there a way to have the 4 Sales Orgs in another sheet and somehow link to those.?

Thanks for any help 

------------------------------
Russel Hunter
mr
TTI EMEA Ltd
Buckinghamshire
------------------------------

Why don't you just create a layout in SE16(n) to download the Material and Sales orgs to fit your template and just update the Sls Status for all? Or you could create a query that just submits the Material and have the query pull in all of the Sales orgs, make the update in the template and then load with transaction? Is there a reason you aren't updating all of the sale orgs in this manner? Is it an authorization issue?

Yes, you could create a loop, but I don't think I'd even bother at that point. Just as quick to call the material and sale org and do the change. It sounds like you've over complicated things, but maybe I'm missing something?

------------------------------
Lora Myroup
IT Director, Supply Chain
Pactiv Evergreen
Lake Forest IL
------------------------------