Data fetching from data base STXL(TX)

[Former Member]

Hi team,

I am using the function module READ_TEXT to get the texts, in this i am getting the text data from

importing Tlines to RTlines

from database stxl(tx)

the text data is filling in RTlines, i can see that in debugging but, externally where can i check,is there any table to get the texts based on the TDID, TDOBJEC t, when the STXH table update with an entry?

[Venkat_Sesha]

I hope you can check that when you fill some text in SO10 by debugging

Also use the where used list of the field combination TDID or TDOBJECT

Also it depends on the what object text you are gonna fill.. Example SAP Script it is STXB.. Etc..

Hope this helps. thanks

[SuhaSaha]

Hello Sivaram,

Long texts are stored as [data clusters|http://help.sap.com/abapdocu_702/en/abenexport_data_cluster_indx.htm] in the table STXL.

The actual data is stored in scrambled RAW format & you [should not use Open SQL statements|http://help.sap.com/abapdocu_702/en/abenindx_type_table_and_sql.htm] to access the content.

Note that STXH contains the header data viz., Text ID, Text Object etc. Using this you cannot read the data from STXL which contains the actual texts.

BR,

Suhas

[former_member633014]

Hi Shivaram,

import tline to rt_lines

     from database stxl(tx)

          client   rt_client

          id       stxl_id

the field of structure tline cannot be seen physically in any table.

Here the id - stxl_id forms the key of table stxl.

So against this key we are exporting the data clusters in database tables and application buffers of the shared memories  using below code first

export tline from wt_lines

       to database stxl(tx)

          client   wt_client

          id       stxl_id.

Finally we are importing that data using import statement into rt_lines which we exported earlier from wt_lines.

In stxl(tx) the tx value corresponds to RELID field in STXL table

Regards,

Vamsi