topic Re: SELECT-OPTIONS : Query in Application Development and Automation Discussions

SELECT-OPTIONS : Query

Former Member — Tue, 13 Nov 2007 10:58:49 GMT

hi,

I need to put a select options with no intervals and defalut mutliple values to the field.

ie,

in my selection screen , there must be a field (text box) and that must be defaulted by 3 values.

how can i do this.

sample code will be really helpful

regards

Balaji

Re: SELECT-OPTIONS : Query

former_member386202 — Tue, 13 Nov 2007 11:01:12 GMT

Hi,

In initialization event append all that values to ur selection table.

Ex.

select-options : s_matnr for mara-matnr.

INITIALIZATION.

s_matnr-low = '100'.

append s_matnr.

s_matnr-low = '200'.

append s_matnr.

s_matnr-low = '300'.

append s_matnr.

Regards,

Prashant

Message was edited by:

Prashant Patil

Re: SELECT-OPTIONS : Query

Former Member — Tue, 13 Nov 2007 11:01:31 GMT

SELECT-OPTIONS s_number FOR number NO-DISPLAY.

s_number-sign = 'I'.

s_number-option = 'EQ'.

s_number-low = 9.

APPEND s_number TO s_number.

s_number-sign = 'I'.

s_number-option = 'BT'.

s_number-low = 3.

s_number-high = 7.

APPEND s_number TO s_number.

s_number-sign = 'E'.

s_number-option = 'EQ'.

s_number-low = 6.

APPEND s_number TO s_number.

s_number-sign = 'E'.

s_number-option = 'BT'.

s_number-low = 1.

s_number-high = 4.

APPEND s_number TO s_number.

DO 10 TIMES.

number = sy-index.

IF s_number.

WRITE / sy-index.

ENDIF.

ENDDO.

Re: SELECT-OPTIONS : Query

Former Member — Tue, 13 Nov 2007 11:03:05 GMT

REPORT ZNNR_REPORT NO STANDARD PAGE HEADING MESSAGE-ID ZNNR LINE-SIZE 100 LINE-COUNT 65(4).

******DATA DECLARATIONS**********

DATA : BEGIN OF IT_PLANT OCCURS 0,

MATNR LIKE MARA-MATNR,

WERKS LIKE MARC-WERKS,

PSTAT LIKE MARC-PSTAT,

EKGRP LIKE MARC-EKGRP,

END OF IT_PLANT.

DATA : BEGIN OF IT_PONO OCCURS 0,

EBELN LIKE EKKO-EBELN,Collect

EBELP LIKE EKPO-EBELP,

MATNR LIKE EKPO-MATNR,

WERKS LIKE EKPO-WERKS,

LGORT LIKE EKPO-LGORT,

END OF IT_PONO.

move

TABLES EKKO.

********END OF DATA DECLARATIONS*********

********SELECTION SCREEN DESIGN ***********

SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

PARAMETER : P_WERKS LIKE MARC-WERKS MODIF ID S1.

SELECT-OPTIONS : S_EBELN FOR EKKO-EBELN NO INTERVALS MODIF ID S2.

SELECTION-SCREEN END OF BLOCK B1.

SELECTION-SCREEN BEGIN OF BLOCK B2 WITH FRAME TITLE TEXT-004.

SELECTION-SCREEN BEGIN OF LINE.

PARAMETERS : R1 RADIOBUTTON GROUP G1 DEFAULT 'X'.

SELECTION-SCREEN COMMENT 5(20) TEXT-002 FOR FIELD R1.

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN BEGIN OF LINE.

PARAMETERS : R2 RADIOBUTTON GROUP G1.

SELECTION-SCREEN COMMENT 5(20) TEXT-003 FOR FIELD R2.

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK B2.

******END OF SELECTION SCREEN DESIGN****************

*********INITIALIZATION OF SELECTION SCREEN ELEMENTS.*****

INITIALIZATION.

P_WERKS = '1000'.

S_EBELN-LOW = '4500016926'.

S_EBELN-OPTION = 'EQ'.

S_EBELN-SIGN = 'I'.

APPEND S_EBELN.

CLEAR S_EBELN.

S_EBELN-LOW = '4500016927'.

S_EBELN-OPTION = 'EQ'.

S_EBELN-SIGN = 'I'.

APPEND S_EBELN.

CLEAR S_EBELN.

S_EBELN-LOW = '4500016928'.

S_EBELN-OPTION = 'EQ'.

S_EBELN-SIGN = 'I'.

APPEND S_EBELN.

CLEAR S_EBELN.

Re: SELECT-OPTIONS : Query

Former Member — Tue, 13 Nov 2007 11:03:51 GMT

Hi Balaji,

Check this,


TABLES : mara.
SELECT-OPTIONS : s_matnr FOR mara-matnr NO INTERVALS.

AT SELECTION-SCREEN OUTPUT.
  s_matnr-low = 'ABACD'. "Default value
  APPEND s_matnr.
  s_matnr-low = 'BCAD'.  "Default value
  APPEND s_matnr.
  s_matnr-low = 'CDEF'.  "Default value
  APPEND s_matnr.

Message was edited by:

Sudhakar G

Re: SELECT-OPTIONS : Query

Former Member — Tue, 13 Nov 2007 11:15:59 GMT

thx !!!!!!