Problem with select query !

[Former Member]

Hello All,

Can we do something like this for a select query ???

select * from ZTABLE
   into table itab
   where FIELD1 = '000000000000000000000925'
     and  FIELD(2) eq '92'.

My field2 is of type Character, and i need to check if there are any entrier that start with `92`, basically do `92*` as we do in se16.

Thanks,

Tatvagna.

[Former Member]

Hi

see following code :

*select data from EKPO

DATA : V1(3) VALUE '25%',

V2(3) VALUE '45%',

V3(3) VALUE '55%'.

SELECT EBELN EBELP MATNR WERKS PSTYP MENGE MEINS NETPR MWSKZ NAVNW

INCO1 INCO2 LGORT UNTTO UEBTO LOEKZ KNTTP WEPOS REPOS

WEUNB PEINH INFNR BANFN BNFPO ANFNR ANFPS TXZ01 WEBRE

from ekpo into table i_ekpo

where ( ebeln like v1 or

ebeln like v2 or

EBELN LIKE V3 )

AND WERKS NOT IN ('ADMM','LGHS','XO01','NGM1','ADMN')

AND LOEKZ EQ SPACE

AND ELIKZ EQ SPACE.

Reward popints if helpful

Regards.

Srikanta Gope

[former_member491305]

Hi,

select * from ZTABLE

into table itab

where FIELD1 = '000000000000000000000925'

<b> and FIELD(2) like '92%'.</b>

[Former Member]

Hi,

You can follow the same logic in the select query also.

select *

from ztable

where field2 like '92%'.

[Former Member]

declare a parameter no-display and give it the default '92*' or a range...

parameters: p_field like ztable-field2 default '92*' NO-DISPLAY.

then

select * from ZTABLE

into table itab

where FIELD1 = '000000000000000000000925'

and FIELD(2) eq p_field2.

hope this helps

[seshatalpasai_madala]

Hi,

select * from ZTABLE

into table itab

where FIELD1 = '000000000000000000000925'

and FIELD <b>LIKE '%92%'.</b>.

Regards,

Sesh

[Former Member]

Thanks to all.

My problem has been solved.

Keep Rocking...!!

Tatvagna.