topic Re: Get Article text without using READ_TEXT in Application Development and Automation Discussions

Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 13:54:23 GMT

Hi all,

Is there a way to get the article texts without using the READ_TEXT function module?

We have an external business intelligence application which can only query on the SAP tables, it can't execute functions like the READ_TEXT. Can I search the texts in a cluster table?

If I search through the SE16n I'll only get the binary format in STXH and STXL.

Hope someone can help.

Thanks,

Koen

Re: Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 14:02:40 GMT

hello,

See if the FM 'ECATT_CONV_XSTRING_TO_STRING' or 'FM SCMS_BIN_TO_TEXT' helps to convert RAW text to String.

DATA: lv_converter TYPE REF TO cl_abap_conv_in_ce.

DATA: lv_xstring TYPE xstring.

DATA: lv_string type string.

lv_xtring = <your xstring>

lv_converter = cl_abap_conv_in_ce=>create( input = lv_xstring

encoding = 'UTF-8'

replacement = '?'

ignore_cerr = abap_true ).

TRY.

CALL METHOD lv_converter->read( IMPORTING data = lv_string ).

CATCH cx_sy_conversion_codepage.

*-- Should ignore errors in code conversions

CATCH cx_sy_codepage_converter_init.

*-- Should ignore errors in code conversions

CATCH cx_parameter_invalid_type.

CATCH cx_parameter_invalid_range.

ENDTRY.

best regards,

swanand

Re: Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 14:07:17 GMT

I think I didn't explain it well enough. The BI application can't execute RFC's of Functions. It has to get the data straight from the database tables.

So the proposed solution will not work.

Re: Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 14:21:37 GMT

Hi Koen,

As per my knowledge, you can't get the article text directly from the standard tables. If your requirement is only to read text from tables directly then create a z table with required fields and populate article text into that table using Read_text function module and Read data from that z table directly.

One morething, Once your work is finished and try to delete data from this table in periodic manner or delete the table if possible to increase database free space.

One more option is you can create a z bapi using fm Read_text and try to call this bapi from external application if possible.

Hope this will helps you!

Shravan

Re: Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 14:27:43 GMT

Thanks Shravan,

So it seems it is not possible. I was hoping to get it done without programming work, but it seems I can't.

If someone has another solution, always welcome.

Re: Get Article text without using READ_TEXT

Former Member — Tue, 16 Oct 2012 14:29:41 GMT

hello,

the above code or suggestion was to convert the RAW text to string. After that you could use the below Z table approach.

best regards,

swanand

Re: Get Article text without using READ_TEXT

RaymondGiuseppi — Tue, 16 Oct 2012 18:35:04 GMT

There is a thread Mass reading standard texts (STXH, STXL) that as a similar subject but is your BI able to effect the import from internal table that will translate the data of the cluster file (using code from reverse engineering of READ_TEXT)

Else, you will require coding for extraction or building some transparent tables to duplicate long texts.

Regards,

Raymond