topic Re: Substring in Select in Application Development and Automation Discussions

Substring in Select

Former Member — Wed, 18 Mar 2009 14:17:58 GMT

Hallo

I have problem with following code. Can some body tell me how can I do it better.

SELECT pspnr FROM prps INTO TABLE lt_prps

WHERE fakkz = 'X'

AND pspnr+0(3) = 'C-55'.

I want to check for first four position of prps

Thank

Re: Substring in Select

Former Member — Wed, 18 Mar 2009 14:23:55 GMT

Hi,

Try the below:

SELECT pspnr FROM prps INTO TABLE lt_prps

WHERE fakkz = 'X'

AND pspnr LIKE 'C-55%'.

% for a sequence of any characters (including spaces).

_ for a single character.

Hope this helps you

Regards

Shiva

Re: Substring in Select

awin_prabhu — Wed, 18 Mar 2009 14:28:31 GMT

Hi,

SELECT pspnr FROM prps INTO TABLE lt_prps

WHERE fakkz = 'X'

AND pspnr like 'C-55%'.

Thanks.

Re: Substring in Select

Former Member — Wed, 18 Mar 2009 14:31:44 GMT

Hi Ahmad,

As also told by other's do it this way:

SELECT pspnr FROM prps INTO TABLE lt_prps
WHERE fakkz = 'X'
 and pspnr like 'C-55%'.

With luck,

Pritam.

Re: Substring in Select

former_member156446 — Wed, 18 Mar 2009 14:35:16 GMT

Try this way:

DATA: des TYPE STANDARD TABLE OF selopt,
      w_des TYPE selopt.

  CONCATENATE  p_text '*' INTO p_text.

  w_des-sign = 'I'.
  w_des-option = 'CP'.
  w_des-low = p_text.
  APPEND w_des TO des. CLEAR w_des.

select...
     where FIELD IN des.

Re: Substring in Select

former_member585060 — Wed, 18 Mar 2009 14:37:56 GMT

Hi,

Declare a field for flag,

Fetch all the prps fields into internal table,

Then compare the prps, and delete all other records which do not match.

SELECT pspnr 
             FROM prps INTO TABLE lt_prps
             WHERE fakkz = 'X'.

LOOP AT it_prps INTO wa_prps.

IF wa_prps-pspnr+0(4) = 'C-55'.
wa_prps-flag = 'X'.
MODIFY it_prps FROM wa_prps INDEX sy-tabix TRANSPORTING flag.
ENDIF.

ENDLOOP.

DELETE it_prps WHERE flag = ' '.

Regards

Bala Krishna

Re: Substring in Select

Former Member — Wed, 18 Mar 2009 15:31:03 GMT

Thanks a lot it was very helpful.