Skip to Content

Usage of long text from table STXL in HANA View (ECC on HANA)?

Feb 15, 2017 at 08:44 AM


avatar image

Hello Gurus,

one requirement of my current customer is to show long text in HANA view (ECC on HANA). As I know, the function module READ_TEXT from ABAP stack can get long text from the table STXL. Is it possible to decompress the table using any HANA function?

I checked the following posts and did not find a solution...

Any ideas are welcome! Thanks a lot!



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

ANUP KULKARNI Feb 16, 2017 at 09:53 AM

Hi Jianping

If you have a BW system in landscape (or even better if you have embedded BW), just dump the tables STXH and STXL into a DSO and derive the texts in the transformation.

Then expose the DSO to hana environment.

The idea behind this approach is that any functionality defined at application level can be consumed only at application level (not at database level).

I know this leads to lot of redundancy of data but unless SAP comes up with some solution to consume ABAP workbench features in report level (or level where HANA views can be consumed), this is the only easy solution I can think of.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Anup,

we have ECC on HANA and BW is not in our landscape. Thanks anyway for your reply.