Skip to Content
author's profile photo Former Member
Former Member

How to retrieve long text for a particular record

Hi,

I've been looking through some of the numerous posts relating to reading long texts but I can't seem to find out how to retrieve the necessary parameters for READ_TEXT for a particular record without using the GUI.

Is there a way in ABAP that one could retrieve the parameters that are required to execute READ_TEXT just from one of the fields in the base table. eg. I would like to bring back a list of all materials with their associated long texts. I can run a query on MARA for example and retrieve the necessary material information but I would like to know how I could get the necessary information, for each row in my results, to pass to READ_TEXT.

What information would I need to perform the above, if at all possible?

Thanks in advance,

Charles

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 14, 2005 at 03:32 PM

    You can check out SE75. Here is where the objects and ids are listed/maintained. There is one trick to find the object/id. That is, create the text in the specific transaction. If you are talking about header text for a sales orders, go to VA02 and enter some text and save. Now go to SE16, enter STXH as the table name. On the selection screen for STXH, enter your user name for "created by" and enter the date. Execute. The record that you see is probably the text that you just created. You can see the object, the id, and even how the name is built. In this case, it would be sales order number.

    Sometimes where you enter the text, there is a little "scroll" icon under the text editor, clicking that will tell you the object and id. In some cases, this functionality is not there.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 03:37 PM

    Hi Charles,

    READ_TEXT is for long text ( more than one lines ) and are stored in STXH / STXL. To retrieve any such text you have to give TEXT ID, TEXT NAME & OBJECT which is different for various application objetcs like PO / SO .

    The actual text is stored in STXL in raw format which cannot be directly read by select statement .

    For MARA table the OBJECT = 'MATERIAL' , Object Name = <MATERIAL_NUMBER> , text id you can find from table TTXID. Just give "MATERIAL" in object field and you will see the different type of texts.

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 04:06 PM

    Is there any place in SAP we could check what the object name would be? It may be material number for materials and po number for purchase orders but is there a more generic approach to this by perhaps finding the linking information somewhere within the data stored in SAP?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Charles,

      RM03M is not a table and just a structure so no question of having data in it . Field LTEX1 is char field of length , may be used on screens to display long texts read by READ_TEXT . Long texts are stored in tables STXH / STXL only.

      Cheers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.