Skip to Content

Where are the Material Master’s long texts stored and how to access them ?

The long texts of a material master are stored in an encrypted format in the STXH and STXL tables, where STXH stores the header information of the
long text like MATERIAL, which indicates which Text Object the long text belongs to, TDID which indicates the various types of texts related to a text object,  and TDNAME which is the actual name of the long text (in the case of MATERIAL should be the material number).

image

As these texts are stored in an encrypted format, the text cannot be read using a SELECT statement. You will have to use the function READ_TEXT. The easiest way of getting to know the parameter values is to go to a Material Master with transaction MM03, goes  i.e. into the Purchase Order text view and open the long text in a full screen mode. (of course you can do the same for the others long text available into the Material Master, Inspection text, Basic data text, Sales text etc..

image

Click the “Goto” menu option and then  “Header” :

 image

Now, You have all the values necessary for the parameters we discussed above :

 image

All the info you need to update into the parameters for the function module  READ_TEXT are now available to you, you have just to go to transaction SE37 function builder, enter READ_TEXT and do a test/execute (F8) :

 image

 

Iinsert the values you have found in the Material Master into the function module parameters and execute :

 image

In the table results you will found an entry, click on the button detail/view edit to see the long text :

 

  image

image

At this point you know how to take the long text information and how to read it.

Here below you can see a simple source code example  : “how to use the READ_TEXT function module” :

 image

 image

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply