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

Here is the list of important tables used in SAP MM (Material management) component. Tables are categorized as Material Master Tables, Vendor Master tables,. SAP MM Tcodes and Tables (Material Management Module). You will find in this article the main list of the most important Transaction Codes in SAP MM. Also, we tried to add the list of SAP MM Tables to be consider in SAP Material Management Module. The main SAP MM Tables for Material Management in SAP are: Regarding to Purchasing in SAP Material.

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.

Toshiba gesture controller software. TOSHIBA Gesture Controller is used by 24 users of Software Informer. The most popular versions of this product among our users are: 1.2, 3.0, 4.0 and 5.0. The names of program executable files are GestureController.exe, TOSHIBA Gesture Controller.exe. The product will soon be reviewed by our informers.

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” :