Solved: ALV grid filter ignores symbol

former_member705295 · ‎2022 Oct 14

Hi, I have an ALV table that can have values like IF+ or IF# in one column. When I try to filter that column and I enter IF+, it also shows the IF# entries.

Is it because the filter treats the plus as wildcard? And if that is the case, how can I tell the filter, to not accept wildcards but treat every input as literal?

Sandra_Rossi · ‎2022 Oct 14

+ is a wildcard for any character

* is a wildcard for zero or any number of (any) characters

# in front of + or * to escape

e.g.

IF#+

If you don't have enough room to type 4 characters (if the field is 3 characters long), try to find workaround in select-options like below i.e. to find IF+, find anything ending with + and exclude anything which doesn't start with IF:

Include =  *#+
Exclude <> IF*

thkolz · ‎2022 Oct 14

I'm not sure, but maybe you can escape special characters via '\'.

former_member705295 · ‎2022 Oct 14

This doesn't work, because the field for the filter criteria only allows 3 characters, since the datatype only has 3 characters.

thkolz · ‎2022 Oct 14

Just found this, but it belongs more to F4 helps:
https://me.sap.com/notes/0002488648

Sandra_Rossi · ‎2022 Oct 14

+ is a wildcard for any character

* is a wildcard for zero or any number of (any) characters

# in front of + or * to escape

e.g.

IF#+

If you don't have enough room to type 4 characters (if the field is 3 characters long), try to find workaround in select-options like below i.e. to find IF+, find anything ending with + and exclude anything which doesn't start with IF:

Include =  *#+
Exclude <> IF*