Select Statement

[Former Member]

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

[Former Member]

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

[Former Member]

Check this way ...

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

[Former Member]

Hi Santosh,

I am getting as

CS is not a valid comparison operator.

[Former Member]

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

[jayanthi_jayaraman]

Hi,

Concatenate '%' var1 '%' into var1.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME like VAR1.

[Former Member]

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

[Former Member]

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.

[Former Member]

try jayanthi code... it is correct.

use like operator

add % to the first and end of the string

as

concatenate '%' var1 '%' into var2.

SELECT * FROM ZTABLE INTO CORRESPONDING FIELDS OF TABLE ITAB

WHERE PERNR = IPERNR

AND CUNAME like VAR2.