topic Re: Substring in SELECT statement in Application Development and Automation Discussions

Substring in SELECT statement

sergio_cifuentes — Wed, 04 Jul 2007 17:39:03 GMT

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 — Wed, 04 Jul 2007 17:41:14 GMT

Hi Sergio,

To my knowledge

AND hkont(4) EQ '1111'.

AND hkont(4) = '1111'.

should work fine. Are you getting any error??

Regards

Aneesh.

sergio_cifuentes — Wed, 04 Jul 2007 17:44:28 GMT

yes the error is this:

Field "HKONT(4)" unknown.

Former Member — Wed, 04 Jul 2007 17:44:31 GMT

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 — Wed, 04 Jul 2007 17:45:33 GMT

this works fine, thanks!!

Former Member — Wed, 04 Jul 2007 17:49:27 GMT

Glad to help.

Rob