Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

michaelvporat
New Contributor II

SAP Connector not able to use "WHERE" in sql statement

Hello,

We have just recently started evaluate SAP Connector and are making some simple tests.

I've managed to write some simple scripts and downloading data from SAP but as soon as I include a "WHERE" statement I get an error. Can anybody help me?

Error: OpenStream failed. Key = SQL_ERROR (Number:000) for statement;

CUSTOMCONNECT TO "Provider=QvSAPConnector;ASHOST=XXXXXXXXXX;SYSNR=;CLIENT=040;UserId=YYYYYYY;Password=XXXXXX;";

EKKO:

LOAD MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ;

SQL SELECT MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ

FROM EKKO

WHERE BUKRS='Z001';

Regards,

Mikael



1 Reply
Highlighted
Not applicable

AW:SAP Connector not able to use "WHERE" in sql statement

you MUST seperate the statement and the =

WHERE

BUKRS = 'Z001';

so it works fine!

Regards

Martin





Community Browser