topic Re: pattern search in select query in Application Development and Automation Discussions

pattern search in select query

Former Member — Wed, 18 Oct 2006 09:58:30 GMT

Hi All,

I want to select those entries from JCDS table whose objnr field has 'OR' as the first two characters.

Thanks in advance.

Former Member — Wed, 18 Oct 2006 10:02:19 GMT

Hi,

Try this code:

SELECT * FROM jcds INTO i_jcds
WHERE objnr LIKE '%OR%'.

best regards,

Thangesh

Former Member — Wed, 18 Oct 2006 10:03:47 GMT

HI Pankaj,

Refer the code below. This should solve your issue.

Example to select all customers whose name begins with 'M':

DATA SCUSTOM_WA TYPE SCUSTOM.

SELECT ID NAME FROM SCUSTOM

INTO CORRESPONDING FIELDS OF SCUSTOM_WA

WHERE NAME LIKE 'M%'.

WRITE: / SCUSTOM_WA-ID, SCUSTOM_WA-NAME.

ENDSELECT.

Reward points if this helps.

Manish

Former Member — Wed, 18 Oct 2006 10:10:36 GMT

Hi Pankai,

try this:

REPORT ZGRO_TEST.

tables: jcds.

select-options: s_objnr for jcds-objnr no-display.

s_objnr-SIGN = 'I'.

S_OBJNR-OPTION = 'CP'.

s_objnr-low = 'OR*'.

append s_objnr.

select * from jcds where objnr in s_objnr.

endselect.

write: / SY-DBCNT.

Regards, Dieter

Former Member — Wed, 18 Oct 2006 10:36:11 GMT

Hi,

select objnr from jcds into table itab

<b>where objnr like 'OR%'.</b>

Regards

amole