topic Re: find record in Application Development and Automation Discussions

find record

Former Member — Tue, 23 Dec 2008 03:49:33 GMT

hi expert

how i can select record which the user keyin the key as *8C01 , and i want to find all record which end with xxxxxxxxx8C01?

select * into table ta_upd_ywch

from ywch

where txbtch in so_btch

how can i change the coding?

Re: find record

Former Member — Tue, 23 Dec 2008 03:52:32 GMT

Hi,

Use like in select statement:

SELECT name FROM trdir INTO TABLE trdir_tab

WHERE ( name LIKE 'SAPLZ%' OR name LIKE 'SAPLY%' ).

Thanks,

Krishna...

Re: find record

Former Member — Tue, 23 Dec 2008 03:58:49 GMT

hmm how can i select any user input? user can keyin anything ... maybe *123 , *1234 .

Re: find record

Former Member — Tue, 23 Dec 2008 04:05:51 GMT

select * into table ta_upd_ywch
from ywch
where txbtch like p_btch.

Best regards,

Prashant

Re: find record

Former Member — Tue, 23 Dec 2008 04:11:51 GMT

no need to change the code. it will work as you have


select * into table ta_upd_ywch
from ywch
where txbtch in so_btch

Re: find record

Former Member — Tue, 23 Dec 2008 04:48:16 GMT

Hi,

Hope the following code solves your problem:

TABLES: mara.

SELECT-OPTIONS s_matnr FOR mara-matnr OBLIGATORY.

DATA: it_mara TYPE TABLE OF mara.

SELECT * INTO TABLE it_mara
FROM mara
WHERE ( matnr IN s_matnr
OR matnr LIKE 'MAT%' ).

IF sy-subrc EQ 0.
  WRITE:/ sy-dbcnt.
ENDIF.

In your case you can write the query as

select * into table ta_upd_ywch
from ywch
where ( txbtch in so_btch
or txbtch like '%8C01' ).

Regards,

Lavanya.