Implementing the usability package on HANA

Answered

Lior Maymon

March 22, 2017 14:12

Hi,

Are there any HANA references that we can use to create functionality on the B1 Usability Package?

Please attach the relevant URL

Comments

3 comments

Official comment
Thomas

March 24, 2017 08:20
Hi Lior,

No there isn't, but you can use the SQL -> HANA converter tool that we provide with the b1up product. You can find the tool under the "Tools" menu:

Thanks,

Thomas
Lior Maymon

March 24, 2017 09:11
Hi Thomas,

I had imported the "UFFE" Sales Order UFFE Sample file and converted the SQL syntax properly to HANA however it looks like HANA has a problem with the parameter DocKey@ as in the example.

If I use the code in the line sources/Body Sql sources as

SELECT T0."ItemCode", T0."Dscription", T0."Quantity", T0."LineTotal" FROM RDR1 T0 WHERE T0."DocEntry" = "DocKey@"

The result of the query present in an error message as follow:

SELECT T0."DocNum", T0."DocDate", T0."CardName", T0."DocTotal", T1."Address", T1."ZipCode", T1."City", T0."Comments" FROM ORDR T0 JOIN OCRD T1 ON T0."CardCode" = T1."CardCode" WHERE T0."DocEntry" = "379"

...invalid column name: 379:...
*As if HANA try to look for this column name instead of the value.

If I try to run the code with the parameter syntax as DocKey@ I get an error message as such:

Error during activation of button: Could not compile code: 4 Errors:
Line: 4 - The type or namespace name 'SAPbobsCOM' could not be found (are you missing a using directive or an assembly reference?)
Line: 5 - The type or namespace name 'UniversalFunc

I do not see how this is related to the SQL syntax conversation tool it looks purely like a problem where the usability package code does not translate properly on HANA in this instance

Thanks,

Lior
Thomas

March 31, 2017 11:23
Hi Lior,

Please send this problem to our support e-mail so we can investigate.

Thanks,

Thomas

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?