topic Arithmetic Expressions in SAP Connector SQL SELECT in QlikView

Arithmetic Expressions in SAP Connector SQL SELECT

r3iuk — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

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 SELECT
MATNR, LFGJA*100 +LFMON
FROM MBEWH
WHERE BWKEY = 'XYZ'
AND LFGJA >= 2000
;

I get an "OpenStream failed. Key = SQL_ERROR ( Number:000) " error message.

Any suggestions would be most appreciated.

Re. :Arithmetic Expressions in SAP Connector SQL SELECT

martin59 — Fri, 14 May 2010 10:30:03 GMT

Hi,

Have you got a role in the system ?

Did you try loading another table from the SAP Connector.

Regards,

Martin

Re. :Arithmetic Expressions in SAP Connector SQL SELECT

r3iuk — Fri, 14 May 2010 10:42:17 GMT

Hi Martin,

I can do basic table extracts no problem for example:

[tempdata]:
Load
*
;
SQL SELECT
MATNR, LFGJA, LFMON
FROM MBEWH
WHERE 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.

Re. :Re: Re. :Arithmetic Expressions in SAP Connector SQL SELECT

martin59 — Fri, 14 May 2010 10:57:17 GMT

So, you can try :

[tempdata]:
Load
MATNR,
LFGJA*100 +LFMON
;
SQL SELECT
MATNR, LFGJA, LFMON
FROM MBEWH
WHERE BWKEY = 'XYZ'
AND LFGJA >= 2000
;

Martin

Re. :Re: Re. :Arithmetic Expressions in SAP Connector SQL SELECT

r3iuk — Fri, 14 May 2010 11:04:05 GMT

I must be having a bad day - why didn't I think of that!

Many thanks.