topic Re: select options in Application Development and Automation Discussions

select options

Former Member — Thu, 21 Sep 2006 14:00:20 GMT

i want to list all possible values for my select options for a user defined table. in standard table it gets automaticaly loaded., how abt tables created by user

Re: select options

Former Member — Thu, 21 Sep 2006 14:01:44 GMT

Hi Uma,

I have answered this question in your earlier query .

use the reference code .

cheers.

santosh.

Re: select options

Former Member — Thu, 21 Sep 2006 14:04:47 GMT

It depends on the type of variable that you assign for the select option.

You have to define the possible selection range in the definition of the Data Element or Domain of that particular variable. Award me if it is usefull.

Re: select options

Former Member — Thu, 21 Sep 2006 14:13:30 GMT

Hello,



REPORT  ztest22                                 .

DATA: BEGIN OF values1,
 matnr LIKE mara-matnr,
 maktx LIKE makt-maktx,
END OF values1.

DATA: progname TYPE sy-repid,
dynnum TYPE sy-dynnr.

DATA: dynpro_values TYPE dynpread OCCURS 1 WITH HEADER LINE,
      field_value LIKE LINE OF dynpro_values.

DATA: values LIKE TABLE OF values1 WITH HEADER LINE.

SELECTION-SCREEN BEGIN OF BLOCK b1.

select-options: s_date for sy-datum.

PARAMETERS: p_matnr LIKE mara-matnr,
            p_makt  LIKE makt-maktx.

SELECTION-SCREEN END OF BLOCK b1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_makt.

  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname               = progname
      dynumb               = dynnum
    TABLES
      dynpfields           = dynpro_values
    EXCEPTIONS
      invalid_abapworkarea = 1
      invalid_dynprofield  = 2
      invalid_dynproname   = 3
      invalid_dynpronummer = 4
      invalid_request      = 5
      no_fielddescription  = 6
      invalid_parameter    = 7
      undefind_error       = 8
      double_conversion    = 9
      stepl_not_found      = 10
      OTHERS               = 11.
  IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

  SELECT p~matnr q~maktx INTO
*CORRESPONDING FIELDS OF
  TABLE values
  FROM ( mara AS p INNER JOIN makt AS q ON p~matnr = q~matnr )
  WHERE p~matnr = dynpro_values-fieldvalue.
*
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
  EXPORTING
* DDIC_STRUCTURE = ''
  retfield = 'MAKTX'
* PVALKEY = ' '
  dynpprog = progname
  dynpnr = dynnum
  dynprofield = 'P_MAKT'
* STEPL = 0
* WINDOW_TITLE =
* VALUE = ' '
  value_org = 'S'
* MULTIPLE_CHOICE = ' '
* DISPLAY = ' '
* CALLBACK_PROGRAM = ' '
* CALLBACK_FORM = ' '
  TABLES
  value_tab = values
* FIELD_TAB =
* RETURN_TAB =
* DYNPFLD_MAPPING =
  EXCEPTIONS
  parameter_error = 1
  no_values_found = 2
  OTHERS = 3
  .
  IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

Instead of SAP tabke use ZTABLE in the query accordingly.

Regs,

Venkat

Re: select options

Former Member — Thu, 21 Sep 2006 14:19:58 GMT

hi,

the ways in which u can have POV (possible values help F4)

1. create search help and give it in dataelement.

2. in domain give check table

3. programmatically if u want u can use Function Module F4IF_INT_TABLE_VALUE_REQUEST. in this FM, what we do is list of values are put in an internal table and ttach it to screen field name i.e select-options in this case.

4. u can assign search help name in select-option declaration in ABAP program directly.

SELECT-OPTIONS LIKE ZTABLE-EMPNO MATCHCODE OBJECT <mat>.

reward if found useful....