SAP Knowledge Base Article - Public

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

Reproducing the Issue

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


SAP Datasphere all versions