SELECT “hs”.“vk_beleg”.[belegart], “hs”.“vk_beleg”.[belegnr], “hs”.“vk_beleg”.[belegdatum], “hs”.“vk_beleg”.[lieferdatum], “hs”.“vk_beleg”.[arf_1_summe], “hs”.“vk_beleg”.[arf_2_summe]
FROM “hs”.“vk_beleg” // WHERE ((“hs”.“vk_beleg”.[belegart]=“AB”) Or (“hs”.“vk_beleg”.[belegart])=“RE”);
=> Execute failed: [SAP][JDBC Driver][SQL Anywhere]Spalte ‘AB’ nicht gefunden
The Column “AB” didn´t found!
For example my DB QUERY READER SQL Statement from a ACCESS db worked:
WHERE (([belegart]=“Ab” Or (hs_vk_beleg.[belegart])=“RE”) AND ([belegdatum]>=#1/14/2021#));
Just a guess: the where statement seems not to be active and just be a comment. KNIME does check for columns and consistency also within comments and from the kind of syntax in the examples with the quotation marks I think “AB” could sometimes represent a column name.
I would delete the comment or put it somewhere else and see if this could help.
For KNIME it might be an idea not to check the comments of SQL code.
Another option could be to deactivate retrieve in configuration for the SAP? driver. Although not sure if this is possible or might have other unintended consequences.
SELECT “hs”.“vk_beleg”.[belegart], “hs”.“vk_beleg”.[belegnr], “hs”.“vk_beleg”.[belegdatum], “hs”.“vk_beleg”.[lieferdatum], “hs”.“vk_beleg”.[arf_1_summe], “hs”.“vk_beleg”.[arf_2_summe]
FROM “hs”.“vk_beleg”
WHERE ((“hs”.“vk_beleg”.[belegart]=‘AB’) Or (“hs”.“vk_beleg”.[belegart])=‘RE’);