Simple Select

Hi

I have a Z table entry with the following

Compnay code

IN*

I need a select statement to check whether the given company code in screen is valid or not with this table. Like if user entered IN01 then its valid. If GB01 then invalid.

select single * from ztable where bukrs cp p_bukrs.

CP is allowed in select command..How can I use select statement here?

Hope I am clear, do let me know if in detail!

Regds