Skip to Content

SAP B1 Using $ sign in any Formatted search throws a syntax error at $ on HANA server

Hello all,

When I use $ sign on my formatted search in any context throws error on my HANA server. Any $ syntax works on my SQL server but not on my HANA server.

Please Help!

Add a comment
10|10000 characters needed characters exceeded

  • Could you please post your sample query and screenshot of the error?

  • My FMS looks like this

    SAP HANA Query:

    SELECT T1."U_Cert_row" FROM OWOR T0 , RDR1 T1 INNER JOIN ORDR T2 ON T1."DocEntry" = T2."DocEntry" WHERE T2."DocEntry" = $[$32.0.64] AND T0."DocNum" = $[$18.0.64] AND T1."U_Cert_row" IS NOT NULL

    The error is as follows: Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 121

    SAP SQL Query:

    SELECT T2.[U_Cert_num_s] FROM OWOR T0 , ORDR T1 INNER JOIN RDR1 T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T2.[DocEntry] = $[$32.0.64] AND T0.[DocNum] = $[$18.0.64] AND T2.[U_Cert_num_s] IS NOT NULL

    This works fine on my SQL server

Assigned Tags

Related questions

3 Answers

  • Posted on Mar 19 at 12:04 PM

    Hi

    check this SAP blog

    Kind regards

    Agustin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 19 at 12:15 PM

    Hi,

    Share your FMS here to check.

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

    • My FMS looks like this

      SAP HANA Query:

      SELECT T1."U_Cert_row" FROM OWOR T0 , RDR1 T1 INNER JOIN ORDR T2 ON T1."DocEntry" = T2."DocEntry" WHERE T2."DocEntry" = $[$32.0.64] AND T0."DocNum" = $[$18.0.64] AND T1."U_Cert_row" IS NOT NULL

      The error is as follows: Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 121

      SAP SQL Query:

      SELECT T2.[U_Cert_num_s] FROM OWOR T0 , ORDR T1 INNER JOIN RDR1 T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T2.[DocEntry] = $[$32.0.64] AND T0.[DocNum] = $[$18.0.64] AND T2.[U_Cert_num_s] IS NOT NULL

      This works fine on my SQL server

  • Posted on Mar 20 at 02:13 PM

    Hi,

    The IS NOT NULL function is not same for HANA version. Change the function to HANA and then try.

    Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.