Skip to Content
-1

How to take specific range of digits from internal table field in where clause ?

Aug 06, 2017 at 08:41 AM

65

avatar image

is there a way to restrict where clause in select statement so it take only first 10 digit of internal table field ?

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

1 Answer

Best Answer
Sandra Rossi Aug 06, 2017 at 10:00 AM
3

You say "Internal table", so are you talking about FOR ALL ENTRIES ?

SELECT ... WHERE column LIKE '1234567890%'

or in ABAP >= 7.40 SP 5 :

SELECT ... WHERE left( column, 10 ) = '1234567890'

or if you're talking about FAE :

SELECT ... FOR ALL ENTRIES IN fae_itab WHERE column = fae_itab-column(10)

Share
10 |10000 characters needed characters left characters exceeded