Automate

 View Only
  • 1.  Extract BOM long text

    Posted 03-15-2024 10:49

    Dear all

    I'm trying to extract long texts from BOMs using the READ_TEXT function module.
    The problem I'm having is that I don't know how to extract multiline text. 
    In my extraction only the first line appears
    Do you have an idea?
    Thank you in advance for your help




    ------------------------------
    Laurent HAAS
    Data manager
    HERTAFOODS
    France
    ------------------------------

    Attachment(s)

    xlsx
    RFC_READ_TEXT.xlsx   402 KB 1 version
    Txr
    RFC_READ_TEXT.Txr   47 KB 1 version


  • 2.  RE: Extract BOM long text

    Employee
    Posted 03-15-2024 20:39

    Hi Laurent,

    You need to use line numbers - Text ID  TEXT_LINES-TDID.  Here's an example for Sales Orders.

    Hope it gives you an idea.

    Best Regards,

    Sigrid



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

    Attachment(s)



  • 3.  RE: Extract BOM long text

    Posted 03-18-2024 04:26

    Hi Sigrid

    Thank you for your reply

    Doesn't the TEXT_LINES-TDID field correspond to the TDID fields in table STXH ?

    When I enter line number in this field, I get errors

    Best regards



    ------------------------------
    Laurent HAAS
    HERTA
    ------------------------------



  • 4.  RE: Extract BOM long text

    Employee
    Posted 03-18-2024 17:04
    Edited by Sigrid Kok 03-18-2024 17:07

    Hi Laurent

    You are correct.  That was for Sales Order header text which used that numbering.  

    I have an example with Material Master that has multiple lines of text:

    You would use a loop and have to guess a max number of lines to add D rows.

    The first D gets line one, then line two, etc.  The weird part of this one, usually if you add too many "D" rows, it will show blanks, but as you see above, it repeats the first line again.   So please be aware.

    The same should work for BOM.

    Would suggest you go to the ideas portal and request we handle long text for BOM the way the FM does - where you can enable long text, select the ones you want to work with, and it will download or upload the long text as one string.  

    HTH,

    Sigrid



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



  • 5.  RE: Extract BOM long text

    Posted 03-19-2024 03:05

    Hi Sigrid

    Thank you very much for your help

    It works very well :)

    I'm attaching the files if it helps anyone else

    Best regards



    ------------------------------
    Laurent HAAS
    Data Manager
    HERTAFOODS
    France
    ------------------------------

    Attachment(s)

    xlsx
    RFC_READ_TEXT.xlsx   134 KB 1 version
    Txr
    RFC_READ_TEXT.Txr   57 KB 1 version