How to extract data form SAP in HEX format and convert to CHAR

[abraham_paradac]

Hi everyone, I require assistance to convert a field in HEX format from a SAP source whose base is Oracle. We need to convert to CHAR.

We currently use the SAP connector ver 7.1

We had look with these articles from the community:

https://community.qlik.com/t5/QlikView-App-Dev/Reading-HEX-values-from-a-database/td-p/172288

How to convert to decimal:

https://community.qlik.com/t5/QlikView-App-Dev/Hexadecimal-to-Decimal-how/td-p/147295

However the conversion wasn't successful. Is there any particular change that needs to be made in the SAP connector to convert this data type?

At the SAP's Database , the log header is saved in the BALHDR table, which can be accessed with the same filters as the SLG1 transaction:

 With the Log Number, The BALDAT table can be access, to obtain the Log Items:

Checking with the owners, they said this data is saved in compressed format (Hex) and can't be read directly like other data, but it is necessary to extract/decompress, through other SAP functions.

Best Regards,

Abraham