About maxnuf

Convert DF34_RAW to Decimal in SQL · 02-18-2019

This is a poor man's implementation to read DF34_RAW datatypes in SQL. Introduction For building BI reports in native HANA for SAP's ACM module, we ran into a lot of tables that were using decimal 128-bit floating point numbers stored in DF34_RAW for...

maxnuf · 10-09-2016

Hello,I've setup HANA Express and followed all the steps in the getting Started guide.After changing the SSFS Master Keys and the Root key, I'm unable to login to XSA.In the console, I get the message:Authentication failed. UAA at https://hxehost:300...

maxnuf · 01-28-2022

You can achieve this by adding a post deploy script to your db module. Add a "poststart" line in "scripts" section in your package.json. You can point to a custom script that contains any logic you want. As Thomas mentions, granting roles should ar...

maxnuf · 01-21-2022

On top of hdblogicalschema, you additionally can add an hdblogicalschemaconfig in /cfg. This way the actual schema can be taken from a service. "sourceSchema" : { "target": { "schema.configure": "UPSWithSchema/schema" } } You will need to...

Re: Convert DF34_RAW to Decimal in SQL · 12-20-2021

With the introduction of HANA2.0 SPS06 there now is a native function to convert DF34 to decimal: ABAP_DF34RAW_TO_DECIMAL

maxnuf · 03-03-2019

You can check my solution in https://github.com/maxnuf/df34_raw_convesion/blob/master/db/src/models/sample_converted.hdbfunctionI've recently posted a blog post with some background information: https://blogs.sap.com/2019/02/18/convert-df34_raw-to-de...

maxnuf · 04-22-2018

I ran into the same issue a year ago. Basically DF34_RAW is a native ABAP data type and is stored as binary data in the database. There is no way you can directly query that data in SQL as a DECIMAL type. I worked around the issue by figuring out t...

User Statistics

User Activity

Convert DF34_RAW to Decimal in SQL

uaa-security is not up on HANA Express

Re: SAP Tech Bytes: SAP HANA / CAP Access Tables from a Different Schema

Re: Helpful Techniques For Adapting Projects to Operate in a Different Environment (e.g., Move from on Premise to SAP HANA Cloud)

Re: Convert DF34_RAW to Decimal in SQL

Re: Hana Studio, Calculation View Formula to convert DF34_RAW

Re: Hana Studio, Calculation View Formula to convert DF34_RAW