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:
[tempdata]:Load*;SQL SELECTMATNR, LFGJA*100 +LFMONFROM MBEWHWHERE BWKEY = 'XYZ'AND LFGJA >= 2000;
I get an "OpenStream failed. Key = SQL_ERROR ( Number:000) " error message.
Any suggestions would be most appreciated.
Go to Solution.
So, you can try :
[tempdata]:LoadMATNR,LFGJA*100 +LFMON;SQL SELECTMATNR, LFGJA, LFMONFROM MBEWHWHERE BWKEY = 'XYZ'AND LFGJA >= 2000;
Have you got a role in the system ?
Did you try loading another table from the SAP Connector.
I can do basic table extracts no problem for example:
[tempdata]:Load*;SQL SELECTMATNR, LFGJA, LFMONFROM MBEWHWHERE BWKEY = 'XYZ'AND LFGJA >= 2000;
This works fine. It is when I try to add an expression into the SELECT clause that I get the error.
I must be having a bad day - why didn't I think of that!