Search maintenance item long text

[Former Member]

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.

[NTeunckens]

Hi Maximilian

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

• Mass Reading Standard Texts
• Alternative to READ_TEXT Function Module

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.

[Former Member]

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

[Former Member]

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.

[former_member248176]

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.

[MTerence]

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

[peter_atkin]

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

[patrick_g1]

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