Skip to Content
avatar image
-2
Former Member

How to filter numeric field by wildcard ?

Hi all

I would like to ask you how I can use wildcard to filter data from timestamp or numeric field. When I use the input for filter data from timestamp field, for example '12.02.2016*' I get error message "Wildcard are not allowed for numerical fields". Do you have any idea how I can resolve this issue ?
Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 26, 2017 at 02:19 PM

    If you're dealing with timestamps then put a range in. 20160212000000 to 20160212235959

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 03:49 PM

    On a selection screen, and depending on the conversion exit used (for example conversion routine TSTPS used in domain LCA_TIMESTAMP), you might have to use the formatted date and time according to user settings. So that would be 12.02.2016 00:00:00 to 12.02.2016 23:59:59.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 04:02 PM

    Are you sure, you are dealing with timestamps in output format directly? Where are you filtering and what?

    I'm afraid that you are mixing up external and internal data formats.

    Before going on you should gain some understanding of how data are stored and presented and then think about how to apply filters. In ABAP this involves data types, conversion and comparison rules.

    Add comment
    10|10000 characters needed characters exceeded