Symptom
Calculated date is not working in Data Flow.
For example, CURRENT_DATE() is not working in Data Flow filter.
Environment
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.
Cause
Dynamic filters are not pushed down for connections using ABAP SDI Adapter.
Resolution
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
Keywords
KBA , DS-PM , Product Management , Problem