Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abraham_paradac
Contributor III
Contributor III

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

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:

abraham_paradac_0-1660138215387.png

 

abraham_paradac_1-1660138215406.png

 

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

 

 

abraham_paradac_2-1660138215425.png

 

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.

abraham_paradac_3-1660138238158.png

 

Best Regards,

Abraham

Labels (2)
0 Replies