Skip to Content
avatar image
Former Member

Search maintenance item long text

Hi

In our company we have many (2500ish) maintenance items, across several plants. In the long text of the maintenance item we have added a standard text when the maintenance item was created. Is there a way of searching in the long text of maintenance item?

The reason for asking is that I want to find all maintenance items where a specific standard text is used.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Oct 25, 2016 at 10:08 AM

    Hi Maximilian

    As a reference to you or others, there is a Custom Report mentioned in the SAP Community :


    SAP itself has responded to this requirement by providing a NEW FUNCTIONMODULE "READ_TEXT_MULTIPLE" (KBA 2261311) ... After adding the FunctionModule to your landscape, you can use it in your Custom Reports, so this would be preferrable I guess ...

    Kind regards

    Nic T.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 11:12 AM

    Hello Maximilian,

    regrettable this is not given in SAP standard. I assume you have for example maintenance order 610002230 (IW33).

    In this order you have operation 0010 with control key PM01 (just as an example).

    For this operation following long text is entered:

    "Within this operation pumps must be controlled by Mr. X"

    You want to have the possibility to search for string: Mr.X

    Am I right? If yes this is not given within SAP standard. I would assume due to performance issues.

    Please keep in mind that the system would need to open every operation of the maintenance order and need to read the complete text of the item.

    After the text has been read from DB the text has to read line by line.

    I would avoid such a search.

    Would it be possible to structure your search over sarch field in maintenance oder header in Tab location?

    Best regards

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 11:17 AM

    Maximilian,

    By complete coincidence I've just been looking at a similar issue (looking at operation long texts).

    In my searches I found program RSTXSCRP which might help you with your issue..

    PeteA

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 11:23 AM

    Hi,

    I dont think this can be achieved directly through tables or transactions.

    Your abaper can do this and include a new field to display long text in IP17

    Regards

    Terence

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2016 at 06:29 PM

    Hi,

    Check with developer to have a simple report using READ_TEXT function module with object = MPOS, id = LTXT, name = Maintenance item(16 digit). When you get alv/excel, you can see the long text lines prefix with INCLUDE word followed by standard text name. Those are considered to be standard text.

    Sri.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 08:50 AM

    Hi, thanks for all of the answers. I'm sorry for a late reply, was sure I would get an email when someone replied.

    It turned out that we have a custom transaction which searches based on planning plant and maintenance item input. The result of this search is line by line from Maintenance Item Longtext. Which means that I can extract this data into an external database and use that database onward. Unfortunately I do not know how the search is built.

    Thanks again.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09 at 05:29 PM

    Hi, does anyone know the name of the table where the long text is stored?

    Add comment
    10|10000 characters needed characters exceeded