Data loading from SAP ECC to Datasphere

[bohdan_kureshov]

Hello experts,

I'm currently working on DWH and the landscape is SAP ECC EHP8 and Datasphere without BW Bridge (because of transition to S/4HANA in near future).

I need to get data from some tables which is big enough to be replicated or persisted every day. Those tables  have "Creation date" and "Change date" fields, so I added them as remote table and created view to get only new values something like delta by date in datasource. But I found out that function in filter (like "Creation date" = CURRENT_DATE()) isn't pushed to the source system, so Datasphere get all the data from table and filter it inside itself.

I thought about custom datasources and replication flow, but it should have only one date field as delta, and I have 2 of them (because "Change date" can be empty). Another idea is to create in custom FM-based datasource and add it in dataflow. FM will have the next logic: if request contain Creation/Change date - use it, if they are empty - use current date.

Maybe there is more elegant way to solve this issue?

[IW2]

Could you write a CDS View which contains a custom field that applies your date logic?

This could then be reused after the switch to S/4HANA.