Substring in SELECT statement

[sergio_cifuentes]

hi, i need to do a substring of a field in the where condition of a select statement, something like this:

SELECT *

FROM bseg

INTO CORRESPONDING FIELDS OF TABLE ti_bseg

FOR ALL ENTRIES IN ti_bkpf

WHERE bukrs EQ ti_bkpf-bukrs

AND belnr EQ ti_bkpf-belnr

AND gjahr EQ ti_bkpf-gjahr

AND hkont(4) EQ '1111'. <------ THIS IS WHAT I WANT TO DO

[Former Member]

Hi Sergio,

To my knowledge

AND hkont(4) EQ '1111'.

or

AND hkont(4) = '1111'.

should work fine. Are you getting any error??

Regards

Aneesh.

[sergio_cifuentes]

yes the error is this:

Field "HKONT(4)" unknown.

[Former Member]

Try:

AND hkont LIKE '1111%'

There is a conversion exit at work here, so I'm not entirely sure.

Yes - when I tested it, I had to pad with leading zeros.

Rob

Message was edited by:

Rob Burbank

[sergio_cifuentes]

this works fine, thanks!!

[Former Member]

Glad to help.

Rob