topic Re: regarding select qurey in Application Development and Automation Discussions

regarding select qurey

Former Member — Tue, 04 Mar 2008 10:39:11 GMT

Hi All,

There is a select statements like

select * from kna1 where kunnr like '*%'.

select * from makt where matnr like '%'.

what is this meanings

Regards

krishna

Re: regarding select qurey

Former Member — Tue, 04 Mar 2008 10:44:56 GMT

in plade of like u can use CS / CP operator

CP (Contains Pattern) and CS (Contain string).

Re: regarding select qurey

dhruv_shah3 — Tue, 04 Mar 2008 10:45:01 GMT

Hi,

This select statement means that select all the data from kna1 where kunnr. Like statement is using the WIld card Characters *,%.

So that you can place any combination there.

E.g

select * from kna1 where kunnr like 'S%'.

means select all the data where kunnr is having the S as first Character.

Same as for 2nd question.

HTH,

Regards,

Dhruv Shah

Re: regarding select qurey

Former Member — Tue, 04 Mar 2008 10:46:37 GMT

hi.

% is like * of selection criteria...

means suppose u need all material start from 1 so u will enter 1* into selection field but for this u need to write select matnr from mara where matnr like '1%'.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:56 PM

Re: regarding select qurey

Former Member — Tue, 04 Mar 2008 10:57:33 GMT

hi check these coding,


tables :kna1.
data: itab like kna1 occurs 0 with header line.
select * from kna1  into table  itab where kunnr like '%'.

loop at itab.
write:/ itab-kunnr.
endloop.

data: itab1 like kna1 occurs 0 with header line.
select * from kna1  into table  itab1 where kunnr like '*'.

loop at itab.
write:/ itab-kunnr.
endloop.

<REMOVED BY MODERATOR>

venkat.

Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:57 PM