Skip to Content
avatar image
Former Member

SAP HANA view- Read Long Text

Hello Folks,

I am creating a SAP hana graphical calulation view for GL Line item report and for that I need to read Long text.

In ABAP- READ_TEXT FM is there to do this because i think the field"CLUSTD" is in LRAW and also compressed. My problem is I cannot find a function to do it in HANA.

1) is there any way I can do this in HANA- since the report is in the ECC DB, so no SLT ( I have read the blog how to do this using SLT), not applicable in my case.

2) Even the calculation view is not allowint to read table "STXL" and throwing error - "inconsistent data type - and in HANA view the Data type is showing as BLOB and in ECC table its LRAW.

Anybody has tried this before ?

Regards,
Vivek

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    Hello Moshe,

    Yes, it has been asked, but I dont see an answer. Thats why I posted this.

    Regards,

    Vivek

  • Get RSS Feed

1 Answer

  • May 09, 2017 at 07:53 AM

    has anyone ever done anything like this.

    can CDS be of any use here ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I'm not quite sure, what you need. But as a Database-Developer I would recommend to use the NCLOB-Datatype, because there are (sadly) issues with NVARCHAR and a TEXT-Datatype is simply missing. If you are using Javascript, be sure to decode the result (its a Buffer).