FIltering SAP-Data by date

[ekcres05]

Hi everybody, 

I am having some troubles connecting my tables from SAP because they are huge. Therefore i wanted to limit the entries. I have in SAP data since 2005 but we are interested only in data from 2023 till now. Is there a way I can limit the connection without much? I am kinda new to coding so if there is a solution without coding, it would be amazing. If coding is the only way, how could i do it? 

Thank you so much. 

[dmac1971 · Accepted solution]

Yes in your load script use the Where function.  Ie :

FROM Sap_Table
where Dept = 'Sales' And SalesDate > '1-1-2021';