Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
uladzislau_pralat
Contributor
If you worked on complex S/4HANA ABAP CDS views, you probably run into "User-defined functions are not supported in the SEARCHED CASE WHEN clause" error message. You can workaround this problem either splitting complex view into 2 more simple nested views or implementing AMDP table function. But what if you are too lazy to do that, then smart solution described in this blog is for you.


According to documentation, indeed user-defined functions are not supported in the SEARCHED CASE WHEN clause. Like in my example, LEFT and SUBSTRING functions are not supported. But the same documentation  provides you a solution as well - LIKE pattern comparisons.

All it takes in my case, is to think out the box and replace string functions with LIKE pattern comparisons


 

 
1 Comment