How to search purchase order text in STXH and STXL

[Former Member]

Hi,

But the question is how can we "Know" the text ... and "FIND" the material number ... in these tables STXH and STXL ?

I know how to use read_text . but is there any possible answer for the above tables?

[Former Member]

Hi,

I'm not much sure about your requirement. But from my understanding, is it based on text you need to extract the material number? Here is a Function Module which will search the STXH Table for any text and will return you the result.

Function Module : SEARCH_TEXT

Have a look at it. Hope this will help.

Thanks,

Samantak.

[Former Member]

Hi,

Thanks for ur reply..

I got a mail from my functional analyst below. i am not understanding what he wants??please help??

Example is, the user knows that the words "... Haven end stock ..." is somewhere in the purchasing text string for a Tenneco material.

The user does not know the material number.

They wish to search all purchase text in the SAP material master, find all the matches,

and then they can pick the correct material number from one of those matches.

A text search on MAKT is easy enough ... input the text string, or some portion of the text ... and output the list of material numbers with that content.

But the question is how can we "Know" the text ... and "FIND" the material number ... in these tables STXH and STXL ?

[Former Member]

Hi,

The function module which I mentioned in the above post will return you all the matching Strings with a matching pattern like 01 or like any other strings. So, if you have the material number or search string you will get all the text and the using a pattern matching you can probably get all the material number by using a pattern matching. I guess this will meet your requirement as he is asking for a pattern match form a text repository. You need to try with the above function module whether this will meet your requirement.

Hope this will help.

Thanks,

Samantak.