Implementing the usability package on HANA Answered

• 

  Thomas

  • March 24, 2017 08:20
  • Official comment

  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

   

  0
• 

  Thomas

  • March 31, 2017 11:23

  Hi Lior,

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

  Thanks,

  Thomas

  0

Please sign in to leave a comment.