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

[john_k1]

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!

[kvbalakumar]

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

[john_k1]

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

[kothandaraman_nagarajan]

Hi,

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

Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Share your FMS here to check.

Regards,

Nagarajan

[john_k1]

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

[agustin_marcoscividanes]

Hi

check this SAP blog

Kind regards

Agustin

[john_k1]

I did read it. Thanks