Automate

 View Only

  • 1.  Processing / Creating multiple rows from one row

    Posted 27 days ago

    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
    ------------------------------


  • 2.  RE: Processing / Creating multiple rows from one row

    Posted 26 days ago

    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
    ------------------------------

    Original Message