topic Help with Select Option in Application Development and Automation Discussions

Help with Select Option

Former Member — Fri, 05 Oct 2007 17:26:56 GMT

I have this select option in the user screen

SELECT-OPTIONS: ID FOR PA0094-FPNCD. " Emp Id

But when the user tries to look up the code by clicking on to the square box beside the input box it gives the user all the entries from the Field FPNCD.

My question is there anyway i could limit it to only show certain codes when they click on the box. (In this case codes for USA only).

Thanks in advance...

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 17:40:28 GMT

There is no search help associated with this, so you will have to select the records from T509F on your own by giving MOLGA = 10 to show only entries for USA. Once you get the records you need, you will display them in AT SELECTION-SCREEN ON VALUE-REQUEST FOR id-low OR (id-high) using F4IF_INT_TABLE_VALUE_REQUEST.

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 17:51:16 GMT

thanks for the reply.

I am new at this. do you have a code that i can look at or somthing..

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 17:54:10 GMT

Please check these threads which gives sample code for how to use thi sfm

thanks

ashish

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 17:59:54 GMT

Hi anwarul,

May be in this way.

First pop up the internal table by selecting the required data...

in your case you want the data of only USA.

Make select query according to ur requirement..

and then use the FM F4IF_INT_TABLE_VALUE_REQUEST

Go through the below example.

tables kna1.

data:

begin of t_values occurs 2,

value like kna1-begru,

end of t_values,

t_return like ddshretval occurs 0 with header line.

select-options s_begru for kna1-begru.

at selection-screen on value-request for s_begru-low.

clear t_values.

t_values = 'PAR*'.

append t_values.

t_values = 'UGG'.

append t_values.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

exporting

retfield = 's_begru'

value_org = 'S'

tables

value_tab = t_values

return_tab = t_return

exceptions

parameter_error = 1

no_values_found = 2

others = 3.

if sy-subrc = 0.

read table t_return index 1.

s_begru-low = t_return-FIELDVAL.

Hope it will be helpful to you.

Reward Points if it is helpful.

Thanks & Regards

ilesh 24x7

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:18:59 GMT

Ok so far I did this

TABLES: REGUH,       "Settlement data from payment program
        PA0001,      "HR Master Record: Infotype 0001 (Org. Assignment)
        PA0094,      "HR Master Record: Infotype 0094 (Residence Status
                     " - NA)
        PA0000,
        PA0002,
        T509F.

SELECT-OPTIONS: PERAREA FOR PA0001-WERKS,       " personnel area
                SUBAREA FOR PA0001-BTRTL,       " personnel subarea
                COSTCTR FOR PA0001-KOSTL,       " cost center
                EXPID FOR PA0094-EXPID,         " green card exp dt
                STAT FOR PA0000-STAT2,          " empl status
                s_ID FOR PA0094-FPNCD,            " Emp Id
                VRESIS FOR PA0094-RESIS,        " Residence Status
                VEXPID FOR PA0094-EXPID.        " Expire Date

Data: BEGIN OF t_Values occurs 0,
        ID LIKE T509F-IDCOD,
        IDTEX LIKE T509G-IDTEX,
        END OF t_values,

t_return like T509F occurs 0 with header line.

at selection-screen on value-request for s_ID-low.
Select IDCOD IDTEX INTO TABLE t_values from T509F Where MOLGA = '10'.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'
exporting
retfield = 's_ID'
value_org = 'S'
tables
value_tab = t_values
return_tab = t_return
exceptions
parameter_error = 1
no_values_found = 2
others = 3.

if sy-subrc = 0.
read table t_return index 1.
s_ID-low = t_return-FIELDVAL.
endif.

but i am getting this error

Unknown Column name IDTEX

Re: Help with Select Option

ferry_lianto — Fri, 05 Oct 2007 19:22:42 GMT

Hi,

Please try to change to read table T509G instead of T509F.


...
 
at selection-screen on value-request for s_ID-low.
Select IDCOD IDTEX INTO TABLE t_values from T509G Where MOLGA = '10'.  "Change here 

...

Regards,

Ferry Lianto

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:23:02 GMT

At Selection-Screen on Value-Request for S_BWTAR-low.

Select BWTAR from T149D into table i_BWTAR.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

DDIC_STRUCTURE = ' '

retfield = 'FPNCD'

PVALKEY = ' '

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'S_ID-LOW'

STEPL = 0
WINDOW_TITLE =
VALUE = ' '

value_org = 'S'

MULTIPLE_CHOICE = ' '
DISPLAY = ' '
CALLBACK_PROGRAM = ' '
CALLBACK_FORM = ' '
MARK_TAB =
IMPORTING
USER_RESET =

TABLES

value_tab = t_values

FIELD_TAB =
RETURN_TAB =
DYNPFLD_MAPPING =

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

Can you make changes marked in bold?

ashish

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:25:04 GMT

Try:

  SELECT idcod idtex INTO TABLE t_values FROM t509g WHERE molga = '10'.

Rob

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:28:55 GMT

Thanks guys for your help...

Gave appropriate points .

Message was edited by:

Anwarul Kabir

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:35:32 GMT

Ok changing that From F to G solved it but can any one tell me what's the difference?

Re: Help with Select Option

Former Member — Fri, 05 Oct 2007 19:37:44 GMT

G is the text table.

Rob