Skip to Content
-2

How to filter numeric field by wildcard ?

Jan 26, 2017 at 01:45 PM

65

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Matthew Billingham
Jan 26, 2017 at 02:19 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Raghu Govindarajan Jan 26, 2017 at 03:49 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Horst Keller
Jan 26, 2017 at 04:02 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded