Extraction using SAP SQL Connector doesn't work with the following script.
[EBAN]:
LOAD * ;
SELECT * FROM EBAN WHERE EKGRP NOT IN ('120','130','375','430') AND EKORG IN (1100,1200,2500,2800,3100,3200,3300,4100,4500,4900,5100,5500,6100,6300,7900,8100,8500,8600,9100,9400) AND ERDAT >= '20171019' ;
It fails with error like "Unknown column name "ERDA" until runtime, you cannot specify a field list.5678".
Environment:
Qlik SAP Connectors
Resolution:
Break down the SELECT statement so that the content in IN clause is reduced to less than 60 characters, like below:
[EBAN]:
LOAD * ;
SELECT * FROM EBAN WHERE EKGRP NOT IN ('120','130','375','430') AND EKORG IN
(1100,1200,2500,2800,3100,3200,3300,4100,4500,
4900,5100,5500,6100,6300,7900,8100,8500,8600,9100,9400)
AND ERDAT >= '20171019';
