Casting a RAW field type in CDS views

[VijayCR]

Hello Experts,

I am trying to read a RAW field from a table in the CDS view and trying to read the offset based on the SUBSTRING function.

How ever i need to do a CAST operation in order to do substring operation.

I get an error message saying that CAST operation is not supported for the RAW data type.Can you please suggest how to achieve in SAP HANA ?

Thanks,

Vijay.

[VijayCR · Accepted solution]

Its not possible alternatively used an AMDP class to do the conversion in ABAP

[073520]

Use the function Bintohex to cast from Raw to Char:

https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-us/abencds_f1_sql_functions_byte.htm

After that you can use the substring function.

[Thomas_Welzel]

And with NW 7.4?

[former_member817817]

Thomas, found out how to cast in NW 7.4? I had the same problem but I don't know how to fix it