on 05-08-2021 8:25 AM
Hello,
I have SAP B1 Cloud (10.0). I have created a UDF "Customer Foreign Name" in Sales documents. I want to display it in the quotation and invoice. To do so I have created a FMS to bring back the field CardFName from OCRD table.
However, my FMS is in error. Could you help me please ?
Here is the query : SELECT T0."CardFName" FROM OCRD T0 WHERE T0."CardCode" = $[$4.0.0]
And the error message on the query : 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 58 'Job de planification de backend' (OBSJ) (at pos 58)
Thank you
Thank you Manish. I still have the same error message : 1). [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "$": line 1 col 58 'Valeurs définies par l'utilisateur' (CSHS) (at pos 58)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
9 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.