Can we retrieve data for long text directly by database sql query?

[Former Member]

Hello,

I am trying to find a way to write some SQL statement to query in database to retrieve the long text for item master data.

What I knew is that long text is stored in the table STXH and STXL, but the raw data need to be processed via the ABAP function READ_TEXT.

Is there a way to process the CLUSTD (SAPscript: STXL LONG RAW)?

i.e. looks like the following:

SELECT some_sql_server_function(CLUSTD) FROM STXL WHERE ....

thanks.

[Former Member]

Hi,

have a look at this thread and look out code given by

[ThomasZloch]

The actual decryption of the data cluster is done by ABAP statement IMPORT (used in READ_TEXT and also in my approach as mentioned by Hitesh).

I understand you want to read STXL via Native SQL statements, I have no idea at this point how to do this, to be honest. You might want to ask in the SCN space for your database system named "SAP on <dbname>."

Thomas