topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Tue, 09 Jan 2007 09:36:22 GMT

Hi,

I am facing problem in the select statement ,

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME CS VAR1.

I am facing problem in the select statement in the selection of cuname, I want to fetch cuname from the ztable if it contains the string var1 contents.

Thanks in Advance,

IFF

Re: Select Statement

Former Member — Tue, 09 Jan 2007 09:38:14 GMT

Hello,

The VAR1 should<b> XYZ* or XYZ%</b>

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

<b>AND CUNAME LIKE VAR1.</b>

If useful reward.

Vasanth

Re: Select Statement

Former Member — Tue, 09 Jan 2007 09:39:10 GMT

Check this way ...

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE PERNR = IPERNR
AND CUNAME CS %VAR1%.

Re: Select Statement

jayanthi_jayaraman — Tue, 09 Jan 2007 09:49:18 GMT

Hi,

Concatenate '%' var1 '%' into var1.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME like VAR1.

Re: Select Statement

Former Member — Tue, 09 Jan 2007 09:50:15 GMT

Hi Santosh,

I am getting as

CS is not a valid comparison operator.

Re: Select Statement

Former Member — Tue, 09 Jan 2007 09:58:59 GMT

Hi ,

Use the following statement

concatenate '%' var '%' into v_string.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME like v_string.

Regards

Arun

Re: Select Statement

Former Member — Tue, 09 Jan 2007 10:01:36 GMT

try jayanthi code... it is correct.

use like operator

add % to the first and end of the string

concatenate '%' var1 '%' into var2.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME like VAR2.

Re: Select Statement

Former Member — Tue, 09 Jan 2007 10:05:12 GMT

Do this way ...

concatenate '%' var1 '%' into var2.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB
WHERE PERNR = IPERNR
AND CUNAME like var2.

Regards,

Santosh

Re: Select Statement

Former Member — Tue, 09 Jan 2007 10:07:24 GMT

use this demo code -

tables zgill_main.

data: begin of itab occurs 0.

include structure zgill_main.

data end of itab.

select * from zgill_main into table itab where name like '%AM%'.

loop at itab.

write:/ itab.

endloop.