cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic filter using apply_filter throws an error?

11-09-2024 9:49 AM
JGT Discoverer
862 views 1 comments Go to solution
0 Likes
SAP Managed Tags
Labels
ABAP CDS VIEWSQL ScriptTable Functions
Subscribe

Am trying to write a simple Table function that accepts 1 parameter as character with length 500 for dynamic filter using APPLY_FILTER

JGT_0-1731141160293.png

Script looks like below

JGT_1-1731141254389.png

table to be queried contains 2 lines

JGT_2-1731141342070.png

If I execute the table function with 25000 as input, I get the error below saying invalid number? The underlying data type of this column is character 10

 

JGT_4-1731141546309.png

Any ideas? thanks

 

 

 

 

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

JGT
Discoverer
0 Likes

Fixed by passing the values in single quote

Answers (0)