WHERE Condition not work with SAP BW

Nin_04 — Tue, 29 Aug 2023 13:23:09 GMT

Hello Everyone,

I have a SAP BW and i need to use a where condition in my ETL01, to load only the last Date for an incremental load , but when i try to write in my query the WHERE condition, it don't work. How can I do to solve this problem? Someone could help me?

Thanks in advance !

[Table]:

Load

Field A

Field B

....

;

SELECT

FROM [MySAPtable]
WHERE LastDate = '20230828';

Re: WHERE Condition not work with SAP BW

BrunPierre — Wed, 30 Aug 2023 06:29:21 GMT

Hi, verify that the date format in your WHERE condition matches the format of the 'LastDate' column in the SAP BW source.

topic Re: WHERE Condition not work with SAP BW in App Development

WHERE Condition not work with SAP BW

Re: WHERE Condition not work with SAP BW