Automate

 View Only

  • 1.  Updating MRP Area

    Posted 12-07-2020 07:30
    I am trying to update the Maximum Lot Size (MDMA-BSTMA) in all existing MRP Areas. Can anyone help please?​​

    ------------------------------
    Tim Sparkes | Forecasting Supervisor
    UK Power Networks | 07875 116269
    ------------------------------


  • 2.  RE: Updating MRP Area

    Posted 12-08-2020 10:46
    Hi Tim,

    Have you tried using this template?

    https://community.winshuttle.com/sap-module-templates/viewdocument/mrp-areas?CommunityKey=8a12989f-fefe-4b81-8147-4bbb11af6820&tab=librarydocuments

    You can download the script and data file from the template library. You'll need to enter all the MRP areas and it looks like max lot size is a field in the script.

    ------------------------------
    Maria Simpson | Solutions Engineer
    Winshuttle North America | 4255276647
    ------------------------------

    Original Message


  • 3.  RE: Updating MRP Area

    Posted 12-15-2020 06:28
    Unfortunately this wasn't what I was looking for. I need to be able to update the Max Lot size field in an existing MRP area rather than when adding one.
    Thanks
    Tim​

    ------------------------------
    Tim Sparkes | Forecasting Supervisor
    UK Power Networks | 07875 116269
    ------------------------------

    Original Message


  • 4.  RE: Updating MRP Area

    Posted 12-15-2020 10:03
    Hi Tim,
    You will need to create a basic mm02 script that updates max lot size. Please see attached script.

    ------------------------------
    isra azam |
    Exxon Mobil Corporation
    ------------------------------

    Original Message


  • 5.  RE: Updating MRP Area

    Posted 12-15-2020 10:25
    My script isn't getting attached here but you basically need to log on to studio, go to mm02, enter the material number and plant, select mrp1 and update max lot size to a new value.​

    ------------------------------
    isra azam |
    Exxon Mobil Corporation
    ------------------------------

    Original Message


  • 6.  RE: Updating MRP Area

    Posted 12-15-2020 11:33
    Hi Tim,

    I was able to get it to work using GUI scripting. I used an If Index Field for the MRP area and added a loop. The loop isn't necessary but it's helpful if you don't want to enter and exit the same material for each MRP area. 

    Please see attached. 

    Thanks,

    ------------------------------
    Maria Simpson | Solutions Engineer
    Winshuttle North America | 4255053830
    ------------------------------

    Attachment(s)

    xlsx
    MM02_UpdateMRPArea.xlsx   5 KB 1 version
    Txr
    MM02_UpdateMRPArea.Txr   99 KB 1 version
    Original Message


  • 7.  RE: Updating MRP Area

    Posted 12-16-2020 11:58
    This is perfect thank you. Exactly what I was after​

    ------------------------------
    Tim Sparkes | Forecasting Supervisor
    UK Power Networks | 07875 116269
    ------------------------------

    Original Message


  • 8.  RE: Updating MRP Area

    Posted 12-16-2020 07:53
    Hi Tim,

    SAP provides example program RMMDDIBE for mass maintenance of MRP area data. There is not a transaction code for this by default, so you'd have to launch/access it via transaction SE38, or get a custom transaction code created for it. Either way, you should be able to record a script around updating the exact field that you want to update, rather than doing the updates via a MM02 recording.
    Since you can enter the MRP area name as a parameter in this transaction, you won't have to do an IF on index to choose the right MRP area, so it will be much easier to record and faster to process. 


    ------------------------------
    Brandon Ronning | Business Analyst
    Entegris, Inc.
    ------------------------------

    Original Message