3320662 - Date calculation in filter in SAP Datasphere

Calculated date is not working in Data Flow.

For example, CURRENT_DATE() is not working in Data Flow filter.

SAP Datasphere

1. Input filter "IDATE" = '20230101'
2. Run Data Flow
3. Check in source system side, it is with selection IDATE = '20230101'
4. Then try with filter "IDATE"= TO_NVARCHAR(CURRENT_DATE(),'YYYYMMDD') no filter in source system side.
5. Then try with filter "IDATE"= TO_VARCHAR(CURRENT_DATE(),'YYYYMMDD') no filter in source system side.

Dynamic filters are not pushed down for connections using ABAP SDI Adapter.

This is a known limitation.

If possible you should create a SAP HANA connection in parallel for extracting tables directly on DB-Level.

For the limitations, you can reference this Best practice guide from this page: Best Practices and Troubleshooting | SAP Datasphere | SAP Community 

First Guidance Document: SAP Data Warehouse Cloud - First Guidance: Data Integration for ABAP Source Systems

date, datasphere, IDATE , KBA , DS-PM , Product Management , Problem