Error in using CP operator

[Former Member]

Hi all,

following statement is giving error 'CP' is not valid comparison operator...

SELECT SINGLE fkdat INTO v_fkdat FROM vbrk

WHERE vbeln = vbak-vgbel AND ( fkart CP 'Z++D' OR fkart EQ ‘ZODP’ ).

plz give the solution......

[Former Member · Accepted solution]

We cannot use CP in database operations.

try this..

SELECT SINGLE fkdat INTO v_fkdat FROM vbrk

WHERE vbeln = vbak-vgbel AND ( fkart eq 'Z%D' OR fkart EQ 'ZODP' ).