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).
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..
Click the “Goto” menu option and then “Header” :
Now, You have all the values necessary for the parameters we discussed above :
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) :
Iinsert the values you have found in the Material Master into the function module parameters and execute :
In the table results you will found an entry, click on the button detail/view edit to see the long text :
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” :