topic Re: Select - Options in Application Development and Automation Discussions

Select - Options

Former Member — Wed, 18 Jun 2008 12:27:11 GMT

Hi experts,

I have doubt in select-options. Please see the below code.

TABLES: ekko.

SELECT-OPTIONS: s_bukrs FOR ekko-bukrs.

DATA: flag TYPE i.

flag = 0.

AT SELECTION-SCREEN.

IF NOT s_bukrs IS INITIAL.

LOOP AT s_bukrs.

IF s_bukrs EQ '1000' OR s_bukrs EQ '0009'.

IF sy-subrc EQ 0.

flag = 1.

ENDIF.

ENDLOOP.

ENDIF.

During execution in the selection screen I am entering 1000,

0009, CRAB, TRN1 for s_bukrs.

But the If condition IF s_bukrs EQ '1000' OR s_bukrs EQ '0009'. is getting failed. Please let me know the correct syntax. i.e if s_bukrs is either 1000 or 0009 the variable flag should be set to 1. But its not happening.

Thanks & Regards,

Neethu.

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:29:06 GMT

write as :

LOOP AT s_bukrs.

IF s_bukrs-low EQ '1000' OR s_bukrs-low EQ '0009'.IF sy-subrc EQ 0.

flag = 1.

ENDIF.

ENDLOOP.

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:29:32 GMT

Hi,

you forgot to specify the field for the value in select-option header line:


LOOP AT s_bukrs.
  IF s_bukrs-low EQ '1000' OR s_bukrs-low EQ '0009'.
*     IF sy-subrc EQ 0.
    flag = 1.
*     ENDIF.
  ENDIF.
ENDLOOP.

By the way: A usual select option has got two value fields (LOW and HIGH). If you want to use the code above it could be better to restrict the select option e.g. with NO INTERVALS.

[Restricting Entry to Single Fields|http://help.sap.com/saphelp_nw70/helpdata/EN/9f/dba76d35c111d1829f0000e829fbfe/frameset.htm|]

Regards Rudi

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:29:48 GMT

do this to ur code

TABLES: ekko.

SELECT-OPTIONS: s_bukrs FOR ekko-bukrs.

DATA: flag TYPE i.

flag = 0.

AT SELECTION-SCREEN.

IF NOT s_bukrs IS INITIAL.

LOOP AT s_bukrs.

IF s_bukrs-low EQ '1000' OR s_bukrs-high EQ '0009'.IF sy-subrc EQ 0.

flag = 1.

ENDIF.

ENDLOOP.

ENDIF.

cheers

snehi

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:30:27 GMT

Hi,

Try this -

at selection-screen on s_bukrs.

if '1000' in s_bukrs or '0009' in s_bukrs.

flag = 1.

endif.

Cheers.

...Reward if useful

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:31:10 GMT

Hi,

Try this -

at selection-screen on s_bukrs.

if '1000' in s_bukrs or '0009' in s_bukrs.

flag = 1.

endif.

Cheers.

...Reward if useful

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:31:20 GMT

Hi ,

Use the following code.

U need to use s_bukrs-low instead of s_bukrs

TABLES: ekko.

SELECT-OPTIONS: s_bukrs FOR ekko-bukrs.

DATA: flag TYPE i.

flag = 0.

AT SELECTION-SCREEN.

IF NOT s_bukrs IS INITIAL.

LOOP AT s_bukrs.

IF s_bukrs-low EQ '1000' OR s_bukrs-low EQ '0009'.

IF sy-subrc EQ 0.

flag = 1.

ENDIF.

ENDLOOP.

ENDIF.

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:38:24 GMT

Hi,

TABLES: ekko.

SELECT-OPTIONS: s_bukrs FOR ekko-bukrs.

DATA: flag TYPE i.

flag = 0.

AT SELECTION-SCREEN.

IF NOT s_bukrs IS INITIAL.

LOOP AT s_bukrs where s_bukrs-low = '1000'

or s_bukrs-low = '0009'.

flag = 1.

ENDLOOP.

ENDIF.

Hope it helps u.

regards.

Manjari.

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:38:26 GMT

Hi,

TABLES: ekko.

SELECT-OPTIONS: s_bukrs FOR ekko-bukrs.

DATA: flag TYPE i.

flag = 0.

AT SELECTION-SCREEN.

IF NOT s_bukrs IS INITIAL.

LOOP AT s_bukrs where s_bukrs-low = '1000'

or s_bukrs-low = '0009'.

flag = 1.

ENDLOOP.

ENDIF.

Hope it helps u.

regards.

Manjari.

Re: Select - Options

Former Member — Wed, 18 Jun 2008 12:47:44 GMT

Hi neethu

U r working with select options and many of our people has given replyes. But u need to consider the S_BUKRS-SIGN also while searching for the bukrs. There can be I -> INCLUDE E->EXCLUDE.

So instead of doing all these validations take an internal table with field bukrs and hit the table t001 and get the company codes which can be considered. Then loop through that table and check for your company code and set the flag.

This would be best solution.

Reward points if useful.

Venkat.