Automate

 View Only
  • 1.  How do update Vendor Email address and remark

    Posted 06-20-2022 09:35
      |   view attached

    Dear All,

    I must update Vendors' Email addresses and note (remark). However, it only works well, in a case where one E-Mail exist. An additional Email and Remark (QMEL) can be added without any issue.

     Where two E-mail addresses exist, only the email is updated, and the note (Remark) is inherited from the existing email.

     Additionally, the remark should be created in three languages. How can one go about all the challenges? Has anyone gotten an on hand experience in what we want to do?

    I will be more delighted to read from anyone willing to share knowledge.

    Kind Regards,

    Marcel



    ------------------------------
    Marcel Dohnjenkah Gwangwaa | Business Analyst
    Vitra IT Services GmbH | 491714296183
    ------------------------------

    Attachment(s)

    xlsx
    Copy of BP_Update_Email.xlsx   118 KB 1 version


  • 2.  RE: How do update Vendor Email address and remark

    Employee
    Posted 06-20-2022 13:34
    Hi Marcel

    Two options that I can think of 
    (1) GUI scripting with an indexed if on the email address
    see doc if you have never done this before: https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-connect/Add-conditions.htm?tocpath=Studio%2020.2%20Online%20Help%7CTransaction%7CMap%20Fields%7CAdvanced%20Mapping%20Commands%20and%20Features%7C_____4

    (2) BAPI_ADDRESSORG_CHANGE - but you must pass in the id to identify the email address row.  Please note I've only ever used this in ECC, but it exists in S4, as well.

    You will have to use this structure for the notes.  Notice the language code, so it will accommodate your language requirement.

    Don't forget to use the accompanying "X" version to tell SAP which fields you will upload.

    It also has the update flag - I to insert, U to update, D to delete.  You cannot mix and match - they have to all be I or U or D.

    Hope that gives you some ideas.

    Best Regards,
    Sigrid

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



  • 3.  RE: How do update Vendor Email address and remark

    Posted 06-21-2022 01:21

    Dear Sigrid,

     

    Thank you so much for the quick response.

     

    I will check the options and see if can make a good use of any.

     

    Kind Regards,

    Marcel

     


    Vitra IT Services GmbH
    Charles-Eames-Strasse 2, D-79576 Weil am Rhein
    T +49 7621 70 20, F +49 7621 702 32 42, info@vitra.com, www.vitra.com
    Geschäftsführung: Sonja Hornberger, Paula Indermühle, Christian Schneider
    Registergericht: Freiburg HRB 413546, Sitz der Gesellschaft: Weil am Rhein
    Datenschutzhinweise / Data protection notes