Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you MUST seperate the statement and the =
WHERE
BUKRS = 'Z001';
so it works fine!
Regards
Martin