Strange filter problem in SE16N (wrong data domain?)

[former_member504446]

Dear gurus,

I wrote a report to import data from a txt file into a Z-db-table. It works well, but I found a strange thing when viewing teh data using SE16N:

Alle entries are displayed no problem. But when I try to set a filter on any Char-field in the table, no rows are shown. But when I use a * at the end of the filter term, it works properly.

E.g. there is a field with domain CHAR020. There are several rows with value "test" in that field. Now, when I set a filter for test, no row is shown. But when I use test* instead, the filter result is correct.

Is it possibly that somehow the domain I used messes with the filter? Or any other ideas?

Cheers
Alicia

[yogananda]

alicia.moore

Fields of CHAR data type do not support space or special characters in value help filtering. Whenever you try filtering for values that contain space, the results will not be displayed if you i...¹.

You can also refer to the SAP Community post² for more information.

I hope this helps. Let me know if you have any other questions.

[RaymondGiuseppi]

Check for domain with conversion-exit (or routine)

If you do not convert the data correctly when uploading, you will encounter problems because the standard tools expect correct data format. (If you put external data in the field, the display will appear correct but many other functions such as filtering and sorting will not work properly).

• The upload program must use the available Function Module to convert from external format to internal format.
• If data already input in production, consider building a small report to correct data (select/CONVERSION_EXIT_*_INPUT/update) but be ready to handle problem during update for duplicate keys and the like.