Automate

 View Only
  • 1.  Mass change Vendor Phone numbers

    Posted 03-29-2023 09:37

    I have a simple script using tcode BP which seems to run ok for the first record if I run as stop on errors. When I apply Renew session after = 1 then the script goes to the next record again only when "run and stop on errors" mode is used. If I use straight run mode, I get runtime error RAISE_EXCEPTION has occurred for each row.

    With each row a tax Jurisdiction popup appears which requires me to hit enter before it goes to the next line in the excel file. I have more than 1000 rows.  Even though the recording includes the popup for tax jurisdiction, it wasn't captured in the script. Is there a way to force a BDC_OKCODE before saving so I don't have to manually click enter for each row?

    Thanks for your help



    ------------------------------
    Barb Cardenuto
    Lamb Weston
    ------------------------------

    Attachment(s)

    Txr
    BP_20230327_105310.Txr   722 KB 1 version
    xlsx
    BP_20230327_105310.xlsx   6 KB 1 version


  • 2.  RE: Mass change Vendor Phone numbers

    Posted 03-30-2023 01:52

    hi Barb, you need to check this box



    ------------------------------
    Radoslav Magal
    PPG Industries International, Inc. – Hong Kong Branch
    ------------------------------



  • 3.  RE: Mass change Vendor Phone numbers

    Posted 03-30-2023 16:57

    Thank you Radoslav.  That worked!!  I'm so happy. 



    ------------------------------
    Barb Cardenuto
    Lamb Weston
    ------------------------------



  • 4.  RE: Mass change Vendor Phone numbers

    Employee
    Posted 03-31-2023 10:12

    HI Barb
    One other tip is to use IF first transaction around the swap to EDIT step, like this:
    SAP will remember that you swapped to edit for the first row, so the rest will be in EDIT mode.
    If you leave it without the IF, it will swap to edit for the first, then display for the second, etc.

    FYI
    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------



  • 5.  RE: Mass change Vendor Phone numbers

    Posted 03-31-2023 14:15

    Thanks Sigrid.
    In this case, the if statement only functions on the first and gives errors for all the others. Debug shows it goes back to display for subsequent rows giving this error:  "Field (SZA1_D0100-TEL_NUMBER Telephone) . SAPLBUS_LOCATOR 3000 is not an input field."
    When I remove the If condition and just use renew session after "1", it works fine.  
    I appreciate your help. 
    Barb



    ------------------------------
    Barb Cardenuto
    Lamb Weston
    ------------------------------



  • 6.  RE: Mass change Vendor Phone numbers

    Employee
    Posted 03-31-2023 14:21

    Hi Barb
    If you still have the Renew session enabled, it will behave like that.  This is meant for scripts that don't have that setting.
    Feel free to disregard if it's working the way you want! :)
    Best Regards,
    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------