Skip to Content
0

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

Feb 15, 2017 at 08:44 AM

480

avatar image
Former Member

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...

https://archive.sap.com/discussions/thread/3570919

https://blogs.sap.com/2014/02/27/how-toload-sap-long-text-to-hana-using-slt/

Any ideas are welcome! Thanks a lot!

BR,

Jianping

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

1 Answer

avatar image
Former Member Feb 16, 2017 at 09:53 AM
0

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.

Regards,

Anup

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

Hi Anup,

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

BR,

Jianping

0