I've seen many posts asserting that SAP binary text can't be read in HANA. I haven't found the reference, but I suspect STXL.CUSTD is some other protocol than CESU-8, which is what HANA BINTOTEXT() requires.
I've tried many, many combinations of conversion functions (SQL in HANA Studio), and am tantalized by the idea that the exact combination will open the treasure chest.
Anybody had success in this forest?
Here are a sample of three trials
from "SAPPRD"."STXL"
WHERE"TDNAME" = '0030000462000010'
/*Result: Could not complete result operation. com.sap.db.jdbc.exceptions.Cesu8ConversionException Invalid CESU-8 sequence*/
from "SAPPRD"."STXL"
WHERE"TDNAME" = '0030000462000010'
/*Result: executes, but null*/
from "SAPPRD"."STXL"
WHERE"TDNAME" = '0030000462000010'
/*Result: executes, Integer of unknown calculation*/