Skip to Content
-1

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 06, 2017 at 10:00 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded