Read SAP script in HANA

[Ibrahem]

Dear experts,

We want to read data from SAP script.

In ABAB we use function module Read_Text. but how can we this data in HANA Calculation view??

Thank yo.

[jassing · Accepted solution]

Hi Ahmed,

Build ABAP Program with READ_TEXT function module to collect relevant  TEXT from STXH table and store in custom table with long text fields. Schedule this program in background to run every hour so that custom table fill regularly. Setup SLT replication on this custom table to bring data in HANA. I hope this solution will help you..

regards,

Jas

[lbreddemann]

You can't.

If you want to read text you need to include the relevant tables into your calculation view.    

[Ibrahem]

Thank you for answering.

but STXL table data is stored as RAW data.

for example

"Delivery to Our Warehouse"

is stored as "FF06020102028000343130330000000063010000121F9D0219331F030303230F90606065C00242187C183C19FC185C19D64254AE020BB38029468E7510C17D50"

so I cann't directly select it. any recommendations?

[lbreddemann]

Ok, please do your diligence first and search for your topic here on SCN.

There had been discussions and blog posts on this a couple of years back.

[Ibrahem]

I've already done my search, but the solution was not found in any of them. So I thought there is something new someone can add specially for HANA