topic select query in Application Development and Automation Discussions

select query

Former Member — Thu, 01 Nov 2007 10:52:44 GMT

hoe could i use like statement in select query?

plz reply............

Thanks in advance.

Re: select query

Former Member — Thu, 01 Nov 2007 10:54:21 GMT

yes

select * from mara where matnr like '100%'.

it will fetch the matnr which starts with 100.

if you want dynamic

data : mat(4).

concatenate '100' '%' into mat

select * from mara where matnr like mat.

regards

shiba dutta

Re: select query

former_member386202 — Thu, 01 Nov 2007 10:58:00 GMT

Hi,

Yes, you can use.

Regards,

Prashant

Re: select query

Former Member — Thu, 01 Nov 2007 11:00:07 GMT

you can use compareOperation = LIKE

<key1>

</key1>

for more have a look at:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Just go thru this thread- may take sometime to read

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Re: select query

Former Member — Thu, 01 Nov 2007 11:00:23 GMT

Hi,

Like 'Char%' in where condition.

select maktx from makt where maktx like 'MAT%'.

It will select all the records with MAT as starting letter.

Thanks,

Sriram Ponna.

Re: select query

Former Member — Thu, 01 Nov 2007 11:00:45 GMT

Hi,

In the select statement the use of LIKE is possible to get the values based on a pattern.

Code:

where matnr LIKE 'M1%' means all Matnr starts with M1

where matnr LIKE '%M1%' means all Matnr that contains M1

You have to use % for any combination of characters

and _ for single character in the LIKE operator.

Check the code.

SELECT DISTINCT MAT_SALES

FROM /BI0/PMAT_SALES

INTO TABLE i_mat_sales

WHERE /BIC/ZACCASGRP IS INITIAL

OR /BIC/ZACCASGRP LIKE '%'

OR /BIC/ZACCASGRP LIKE 'A1%' "Starts with A1

OR /BIC/ZACCASGRP LIKE 'C3%'.

LOOP AT SOURCE_PACKAGE into source_wa.

T_INDEX = SY-TABIX.

READ TABLE I_MAT_SALES WITH KEY MSALE =

source_wa-MAT_SALES TRANSPORTING NO FIELDS.

IF SY-SUBRC NE 0.

DELETE SOURCE_PACKAGE INDEX T_INDEX.

ENDIF.

Reward if Helpful.

Regards,

Harini.S