topic Re: Simple Select in Application Development and Automation Discussions

Simple Select

Former Member — Thu, 09 Nov 2006 17:00:12 GMT

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

Re: Simple Select

suresh_datti — Thu, 09 Nov 2006 17:02:36 GMT

use LIKE 'IN%' in the WHERE clause.

~Suresh

Re: Simple Select

RichHeilman — Thu, 09 Nov 2006 17:08:42 GMT

I don't think you need to go to the database to check this, right? You can probably just use a range.

ranges: r_bukrs for t001-bukrs.

r_bukrs-sign = 'I'.
r_bukrs-option = 'CP'.
r_bukrs-low  = 'IN*'.
append r_bukrs.

If p_bukrs in r_bukrs.

Endif.

Regards,

Rich Heilman

Re: Simple Select

Former Member — Thu, 09 Nov 2006 17:11:02 GMT

Rather than using a parameter on the select screen, use a select-option. This will allow you to write:

SELECT SINGLE * FROM ztable
  WHERE bukrs IN s_bukrs.

Rob

Re: Simple Select

Former Member — Thu, 09 Nov 2006 17:11:23 GMT

Hi,

Try this..

TABLES: T001.

SELECT-OPTIONS: P_BUKRS FOR T001-BUKRS NO INTERVALS NO-EXTENSION.

AT SELECTION-SCREEN.

IF NOT P_BUKRS[] IS INITIAL.

SELECT SINGLE * FROM T001 WHERE BUKRS IN P_BUKRS.

IF SY-SUBRC <> 0.

MESSAGE E208(00) WITH 'NOT A VALID COMPANY CODE'.

ENDIF.

Thanks,

Naren