Searching longtext

[Former Member]

Is there a FM that can be used to find text within a text object?

For example:

I want to find a list of material numbers where within one of the text objects associated to materials (which you would name) contain a search string containing wild cards.

I have looked at FM SEARCH_TEXT but I don't think it does this.

I am looking for something that will return a list of objects that the long text for that object contain my search criteria.

Does such a FM exist?

This seems to me like something many folks could use.

[Former Member]

Is there a FM that can be used to find text within a text object?

For example:

I want to find a list of material numbers where within one of the text objects associated to materials (which you would name) contain a search string containing wild cards.

I have looked at FM SEARCH_TEXT but I don't think it does this.

I am looking for something that will return a list of objects that the long text for that object contain my search criteria.

Does such a FM exist?

This seems to me like something many folks could use.

[arjun_thakur]

hi larry,

you can use READ_TEXT . It is used read long text of an object into an internal table. after that you can filter the result accordingly.

i hope it helps

regards

arjun

[Former Member]

So, what you are saying is that I need to read all the text for all the materials and then search thru all of that to find a list a materials that have my search criteria in the long text. WOW! there seems like there must be a better way! I realize that long text search could be pretty i/o intense. This is why I figured there must be some FM or something in SAP to help with long text search.

My actual project has to do with creating a set of "standard" notes that have note ID numbers. There will be thousands of these. Each note could be several pages long containing all kinds of information. We want to be able to search through these notes looking for just about anything. This search woud produce a list of note numbers where the longtext contained the search criteria. They could then assign one or more of these standard notes to a material number or BOM to be displayed on the shop floor as assembly instructions and the like.

One thought is to create a ztable with note ID number and a long character field that would contain keywords from the text. The person creating the note would then have to not only create the note, but would also have to create the keyword list as well. Which doesn't work too well in practice. Unless there could be a way to automatically generate the keywork list, which doesn't seem very dooable either.

Any thoughts on this?

[Former Member]

Hi Larry,

did you manage to solve this issue? I have the same problem right now, so I would appreciate any help.

Thank you

André

[Former Member]

Andre,

The only answer I have is the one listed here. This is really not a very elegant solution, but I guess it works. My situation is that I will have many thousands of note objects that will have to be searched every time a search is performed. The only way I can think of to do this is to somehow catagorize the notes and only search through that catagory. Maybe add some inteligence to the note ID number. Like MInnnnnn is manufacturing instructions and QAnnnnnn is quality alert, etc... Then do as others have suggested, use FM READ_TEXT to to read all the MI* notes and search through the text one note at a time. Seems pretty lame to me, but this is all I have come up with so far..... Still thinking about it. Let me know if you find something better.

[former_member203501]

hi see the reports ..

RSRSCAN1

RSTXSCAN

RPR_ABAP_SOURCE_SCAN