topic Re: select-options in Application Development and Automation Discussions

select-options

Former Member — Thu, 16 Oct 2008 03:52:00 GMT

Hi all,

the following code is for Parameters on selection screen i need to make it for

select options...

DATA:BEGIN OF itab OCCURS 0,

ltx LIKE t247-ltx,

END OF itab.

SELECTION-SCREEN:BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETERS : p_month TYPE d obligatory."char10 OBLIGATORY.

PARAMETERS:p_year TYPE char4 OBLIGATORY.

SELECTION-SCREEN:END OF BLOCK b1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_month.

SELECT * FROM t247 INTO CORRESPONDING FIELDS OF TABLE itab WHERE spras = 'EN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'P_MONTH'

dynpprog = sy-cprog

dynpnr = sy-dynnr

dynprofield = 'P_MONTH'

value_org = 'S'

display = 'F'

TABLES

value_tab = itab

Regards

Suprith

Re: select-options

Former Member — Thu, 16 Oct 2008 04:04:16 GMT

DATA:BEGIN OF itab OCCURS 0,

ltx LIKE t247-ltx,

END OF itab.

SELECTION-SCREEN:BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

select-options : s_month TYPE d obligatory."char10 OBLIGATORY.

PARAMETERS:p_year TYPE char4 OBLIGATORY.

SELECTION-SCREEN:END OF BLOCK b1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR s_month-low.

SELECT * FROM t247 INTO CORRESPONDING FIELDS OF TABLE itab WHERE spras = 'EN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 's_MONTH-low'

dynpprog = sy-cprog

dynpnr = sy-dynnr

dynprofield = 's_MONTH-low'

value_org = 'S'

display = 'F'

TABLES

value_tab = itab

AT SELECTION-SCREEN ON VALUE-REQUEST FOR s_month-high.

SELECT * FROM t247 INTO CORRESPONDING FIELDS OF TABLE itab WHERE spras = 'EN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 's_MONTH-high'

dynpprog = sy-cprog

dynpnr = sy-dynnr

dynprofield = 's_MONTH-high'

value_org = 'S'

display = 'F'

TABLES

value_tab = itab

Re: select-options

Former Member — Thu, 16 Oct 2008 04:09:59 GMT

Hi shan,

select-option will not take TYPE.

i'm getting error

Re: select-options

Former Member — Thu, 16 Oct 2008 04:14:33 GMT

Hi,

Try like this:

DATA : name TYPE d.

SELECT-OPTIONS: p_month FOR (name).

Regards,

Bhaskar

Re: select-options

Former Member — Thu, 16 Oct 2008 04:15:20 GMT

Hi Suprith,

You need to use "FOR " instead of TYPE"..

try dis ...

SELECTION-SCREEN:BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

PARAMETERS : p_month FOR d obligatory."char10 OBLIGATORY.

PARAMETERS:p_year FOR char4 OBLIGATORY.

SELECTION-SCREEN:END OF BLOCK b1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_month.

hope it will help you,

Regards

Nikita

Re: select-options

Former Member — Thu, 16 Oct 2008 04:17:25 GMT

hi.. try this..

DATA p_year TYPE char4.

SELECT-OPTIONS s_year FOR (p_year).

regards,

Padma

Edited by: Padmashree RamMaghenthar on Oct 16, 2008 9:47 AM

Re: select-options

Former Member — Thu, 16 Oct 2008 04:45:09 GMT

Check the below code, its working fine.


TABLES : T247.
DATA:BEGIN OF ITAB OCCURS 0,
LTX LIKE T247-LTX,
END OF ITAB.

SELECTION-SCREEN:BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : S_MONTH FOR  T247-LTX OBLIGATORY."char10 OBLIGATORY.
PARAMETERS:P_YEAR TYPE CHAR4 OBLIGATORY.
SELECTION-SCREEN:END OF BLOCK B1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_MONTH-LOW.

SELECT * FROM T247 INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE SPRAS =
 'EN'.

  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      RETFIELD    = 'S_MONTH'
      DYNPPROG    = SY-CPROG
      DYNPNR      = SY-DYNNR
      DYNPROFIELD = 'S_MONTH_low'
      VALUE_ORG   = 'S'
      DISPLAY     = 'F'
    TABLES
      VALUE_TAB   = ITAB.


AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_MONTH-HIGH.

SELECT * FROM T247 INTO CORRESPONDING FIELDS OF TABLE ITAB WHERE SPRAS =
 'EN'.

  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      RETFIELD    = 'S_MONTH'
      DYNPPROG    = SY-CPROG
      DYNPNR      = SY-DYNNR
      DYNPROFIELD = 'S_MONTH_low'
      VALUE_ORG   = 'S'
      DISPLAY     = 'F'
    TABLES
      VALUE_TAB   = ITAB.

regards

Kumar M