Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

  • 1.  VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-08-2020 16:58
    HI
    I want to crete a template to change contract line items for Plant, Shipping point and route. How do I go about doing this? Please help

    ------------------------------
    SUNIL DEV | Sr. Manager-SAP Supply Chain
    Ingredion | 6305208889
    ------------------------------


  • 2.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 08:22
    Hi Sunil -

    In the VA42, there is a button for "Item to Top", that lets you position by item number, material, description, cust. material, PO Item, and that places the line you want to update on the first row. Once you have the desired line item positioned up top, then you can select line one and then hit the "Display Item Details" button to go into the details. You can make your field changes in the detail screen, back out, and then save.

    If you wanted to add in a loop you could, starting with hitting the "Item to Top" button until you come back to the main contract screen, but looping is not necessary, as you can just update the contract line item changes one at a time. It will give you the same result.

    Thank you!

    ------------------------------
    JENNIFER HWANG | SE
    Winshuttle North America
    ------------------------------



  • 3.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 08:47

    Using the second option "but looping is not necessary, as you can just update the contract line item changes one at a time. It will give you the same result", if I have 5 line-items, the contract is saved five times. I want all line items to be updated in for one contract and save once

     

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 4.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 08:55
    Hi Sunil,

    That's what a loop is for - updating multiple line items and doing one save for the entire "document", i.e. contract, BOM, sales order, PO, etc.  Jennifer suggested how you can use a loop.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 5.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 09:03

    IF I Create a contract VA41 using existing contract and I have to update all line items with plant , shipping point and the route How do I do this?

    I am not being able to create a loop for changing a contract?

     

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 6.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 09:29
    Hi Sunil

    Jennifer suggested how.  Here's the specifics

    Open the contract and then put a loop around these steps


    Please ensure you go back to the first tab in the details, so that the next line items start in the same place.

    Then outside of the loop, click save.

    Please give it a try.

    Best Regards,
    Sigrid



    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 7.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 09:30

    Hi Jennifer

     

    I did loop as below but not being able to process line items

     

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 8.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 09:35
    Hi Sunil,

    I think you got close :)  it would help if you post your script to see what is going on.  Any also any error messages you're getting.

    Best Regards,
    Sigird

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 9.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 09:57

    See attached

    Error is which does not make sense

    Cursor field (VBAP-ZMENG Target quantity) . SAPMV45A 4003 does not exist in the screen

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 10.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 10:15
    Hi Sunil

    Like i said, you're close.  A few things:
    The screen with POSI positions the line item.  That needs to happen for each one, so please include in the loop.

    As I suggested in the prior post, SAP remembers the tab you left off on, so you need to return to the first tab.  That's why the 2nd line fails, because it thinks it's on SalesA looking for quantity, when it's really on shipping.  You can see this if you run in DEBUG mode.
    If you change your OK code from /00 (enter) to =T\01 (go to first tab), you will correct this, and the script will always start in the same place, which is a best practice.

    FYI
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 11.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 10:29

    Hi Sigrid

    As you mentioned, I changed the script as shown below

     

     

     

    When I execute it, I am getting following error

     

    Requested function T/01 is not available here

     

     

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 12.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 10:47
    Hi Sunil,

    The equal sign is required by SAP as part of the "ok code",  so   =T\01   

    You could also re-record - it should only take a few minutes.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message


  • 13.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Posted 12-09-2020 10:57

    I tried it.

    It goes through the first detailed line. For the second it gets stuck on the grid and the popup window for item number does not come up

     

    Thanks and Regards

     

    Sunil Dev

    Sr. Manager, SAP-Supply Chain

    Office: (708) 551-2761, Cell: (630) 520-8889.

    Email: sunil.dev@ingredion.com

     

    Visit ITconnect to check on or report an IT issue or make an IT request ; Anything IT!

     

     




    Original Message


  • 14.  RE: VA42 - Change Plant , Shipping point and Route On sales order with multiple line items

    Employee
    Posted 12-09-2020 11:06
    Hi Sunil -

    Per my original response, the loop needs to start with the "Item to top" button being clicked. Your script still does not include that piece in the loop. So your loop needs to start sooner, including the previous screen where it includes the action =POPO, which is the "Item to top" button. The full screen needs to be included in your loop, not just the OK Code line with the =POPO.

    Thank you.

    ------------------------------
    JENNIFER HWANG | SE
    Winshuttle North America
    ------------------------------

    Original Message