Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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.

    Regards,

    Anup

    Add comment
    10|10000 characters needed characters exceeded