Discussion Board for collaboration on QlikView Scripting.
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;";
LOAD MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ;
SQL SELECT MANDT, EBELN, BUKRS, BSTYP, BSART, BSAKZ
you MUST seperate the statement and the =
BUKRS = 'Z001';
so it works fine!