Automate

 View Only
  • 1.  Material Master Texts

    Posted 08-31-2021 10:01
    Good afternoon all, i hope my post finds you all safe and well.

    Im looking to hopefully get some information/guidance regarding the removal rather than upload of Material master data texts, in particular "Purchase order text"

    i have circa 3500 records where text exists for multiple languages that i need to remove in SAP, the difficulty is they are a select set of languages and not "all" languages that exist at material/purchase order text level.

    has anyone ever scripted such an update before? if so please can you share how?

    I considered recording as GUI directly in MM02 but as there is no selection criteria per language, and the language keys differ per material, i cant specifically pin point only the language lines i want to delete merely the position of that language key on screen, which as its variable isnt going to work (i dont think!)

    Currently using  Winshuttle V 12.0 and SAP ECC.

    any help greatly appreciated!

    Thanks


    ------------------------------
    Christian.
    ------------------------------


  • 2.  RE: Material Master Texts

    Posted 08-31-2021 10:26
      |   view attached
    Hi Christian -

    You can use the available long-text functionality within Winshuttle Studio to be able to clear the long text. It will not remove it completely (using the trash can button) but it will clear out the existing text. Basically replacing the existing long text with blank text. If that works, feel free to try the attached. 

    https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-connect/12/Record-long-text.htm#Add 

    Thank you!

    ------------------------------
    Jennifer Hwang | SE
    Winshuttle North America
    ------------------------------

    Attachment(s)



  • 3.  RE: Material Master Texts

    Posted 08-31-2021 10:30
    Hi Jennifer

    many thanks for your response, at the moment im struggling to get our function modules updated, were sadly still using a V10 i believe that i know is probably long dead, but i need some IT support internally to overcome this, as such i cant currently use the "add long text" feature, which is a real shame as this would have been ideal i feel!

    do you know of any other possible solutions?

    many thanks for your help!

    ------------------------------
    Christian.
    ------------------------------



  • 4.  RE: Material Master Texts

    Employee
    Posted 08-31-2021 11:26
    Hi Christian
    Are you game to try a BAPI using DIRECT?  It's a quite simple one:  RFC_DELETE_TEXT
    Pass in:
    • MAN is client
    • TDobject is MATERIAL (this works for lots of text types so this specifies it's a material)
    • TDNAME is your material number - if numeric you'll have to zero pad to the correct length
    • TDID is the text type - BEST is the PO text
    • TDSPRAS is the language code

    HTH
    Sigrid

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



  • 5.  RE: Material Master Texts

    Employee
    Posted 08-31-2021 11:30
    PS:  Quick and dirty example attached.  If the text doesn't exist for the language, you'll get an error, but that's what you want anyway. :)

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



  • 6.  RE: Material Master Texts

    Posted 09-01-2021 03:17
    Sigrid thank you so much! this is fantastic! really appreciate you taking the time to respond and provide the solution i needed. many thanks.

    ------------------------------
    Christian.
    ------------------------------



  • 7.  RE: Material Master Texts

    Employee
    Posted 09-01-2021 08:43
    You're welcome, Christian.  BAPIs can be a good thing when the tcode is not automation friendly. :)

    Best Regards,
    Sigrid

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