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

select-options

Former Member — Thu, 16 Oct 2008 07:03:50 GMT

hi all,

in selection when i press on f4 .

field is assiging as jan , feb....

but it should take 01, 02...

below code will refer to that....

please tell me how to get only numbers

DATA:BEGIN OF itab OCCURS 0,

mnr like t247-mnr,

KTX like t247-KTX,

END OF itab.

select-options : mnr for t247-mnr obligatory.

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

SELECT ktx mnr 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 mnr ktx 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 07:08:42 GMT

after the function module

F4IF_INT_TABLE_VALUE_REQUEST

create a workarea and change the values of

jan feb ....... to 01 02 ......

this will work after the selection screen event

Re: select-options

Former Member — Thu, 16 Oct 2008 07:09:51 GMT

Hi Suprith,

After selecting data from table t247, assign 1 to 12 to the respective months and pass into another internal table.

Pass new internal table to F4 FM.

Regards

Kiran

Note : While selecting data using this Select-option use shoud use Jan to Dec for 1 to 12

Re: select-options

Former Member — Thu, 16 Oct 2008 07:10:59 GMT

suppose if i give

JAN -

FEB in selection screen

its giving error as lower limit is greater then upper limit

so i thought of giving numbers

Re: select-options

Former Member — Thu, 16 Oct 2008 07:16:24 GMT

Hi,

Do the changes that is in bold:

Tables: T247.

DATA:BEGIN OF itab OCCURS 0,

mnr like t247-mnr,

KTX like t247-KTX,

END OF itab.

select-options : mnr for t247-mnr obligatory.

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

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

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'MNR' "change here

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 mnr ktx FROM t247 INTO CORRESPONDING FIELDS OF TABLE itab WHERE spras = 'EN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'MNR' "change here

dynpprog = sy-cprog

dynpnr = sy-dynnr

dynprofield = 's_MONTH-high'

value_org = 'S'

display = 'F'

TABLES

value_tab = itab.

Regards,

Saba

Re: select-options

Former Member — Thu, 16 Oct 2008 07:17:08 GMT

Hi,

change retfield value to 'MNR' .

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'MNR' " try with this value

dynpprog = sy-cprog

dynpnr = sy-dynnr

dynprofield = 's_MONTH-low'

value_org = 'S'

display = 'F'

TABLES

value_tab = itab.

Regards,

Suresh.

Re: select-options

Former Member — Thu, 16 Oct 2008 07:20:45 GMT

Hi Suprith,

Just make the following changes.

In your select-options, declare the screen field name as s_month.

in your FM call, make the retfield as 'MNR'. This is parameter that specifies which field has to be returned from the record that you have selected.

regards,

Anoop Panackal

Edited by: Anoop Panackal on Oct 16, 2008 12:51 PM