This content has been marked as final. Show 4 replies
Does anyone know if you can use an arithmetic expression as part of a SQL SELECT statement using the SAP Connector and if so how do you construct the statement? When I try something like:
MATNR, LFGJA*100 +LFMON
WHERE BWKEY = 'XYZ'
AND LFGJA >= 2000
I get an "OpenStream failed. Key = SQL_ERROR ( Number:000) " error message.
Any suggestions would be most appreciated.