topic Re: selection-screen in Application Development and Automation Discussions

selection-screen

Former Member — Tue, 05 Jun 2007 08:36:35 GMT

hi guys,

need a bit of help.

say i have two fields on my selection screen --

dept. number

name of employee

now my requirement is such that if i give the dept. number and press F4 on the name of employee field, then all employee names corresponding to the dept. numbere ,that i have entered, should be displayed.

like for example : i enter dept. numbere as 10.

then the name of employees working in dept. Number 10 should be displayed in the F4 help.

please reply as soon as possible. and if possible please send me the exact coding.

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:40:02 GMT

Hi,

What you can do is using the select statement fetch all the desired records into an internal table i.e. Emplyee name and Deptt.

Now, using function F4IF_FIELD_VALUE_REQUEST you can assign this Internal table as a serach help to your field on the selection screen.

Regards,

Himanshu

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:40:15 GMT

use the fiollowing FM

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

DDIC_STRUCTURE = ' '

retfield = 'EBELP'/ <dept no>

PVALKEY = ' '

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'DYNPFD'

STEPL = 0
WINDOW_TITLE =
VALUE = ' '

value_org = 'S'

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

TABLES

value_tab = it_line_items/<containig dept no and name of emp>

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.

regards

ravish

plz dont forget to reward points if helpful

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:43:29 GMT

Hi,

Write select query for selecting the name of the employees corresponding to that Department.For that write select query as

SELECT NAME FROM <table> INTO TABLE <itab> WHERE DEPT = <deptno>.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

RETFIELD = 'NAME'

TABLES

VALUE_TAB = <itab>

EXCEPTIONS

PARAMETER_ERROR = 1

NO_VALUES_FOUND = 2

OTHERS = 3.

Regards,

Padmam.

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:44:12 GMT

HI,

data:

begin of t_values occurs 2,

value like kna1-begru,

end of t_values,

t_return like ddshretval occurs 0 with header line.

t_values = 'PAR*'.

append t_values.

t_values = 'UGG'.

append t_values.

call function 'F4IF_INT_TABLE_VALUE_REQUEST'

exporting

retfield = 'BEGRU'

value_org = 'S'

tables

value_tab = t_values

return_tab = t_return

exceptions

parameter_error = 1

no_values_found = 2

others = 3.

Regards

Sudheer

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:44:39 GMT

Hi,

At selectiom-screen on value request for p_name.

SELECT DISTINCT

EMP_NAME

FROM Employee INTO CORRESPONDING FIELDS OF TABLE

ITAB WHERE

DEPT = P_DEPT.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

RETFIELD = 'EMP_NAME'

DYNPPROG = SY-REPID

DYNPNR = SY-DYNNR

DYNPROFIELD = 'P_NAME'

VALUE_ORG = 'S'

TABLES

VALUE_TAB = ITAB.

Here itab is the internal table with fiel EMP_NAME.

P_NAME is the selection screen parameter for employee nbame.

Reward points if it is helpfl.

Re: selection-screen

Former Member — Tue, 05 Jun 2007 08:47:03 GMT

Hi,

Check this code sample by Rahul..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a07a330f-126c-2910-c684-d2a45f0f37dd

Regards,

Vidya.

Re: selection-screen

former_member491305 — Tue, 05 Jun 2007 08:56:59 GMT

Hi,

To get the value of Dept no ,Dont forget to use the function module 'DYNP_VALUES_READ' .

At selection-screen on value-request for pname.

DATA :it_dynpread LIKE dynpread OCCURS 1 WITH HEADER LINE.

REFRESH it_dynpread .

it_dynpread -fieldname = 'PNAME'.

append it_dynpread .

call function 'DYNP_VALUES_READ'

exporting

dyname = sy-repid

dynumb = sy-dynnr

tables

dynpfields = it_dynpread

exceptions

others.

Re: selection-screen

Former Member — Tue, 05 Jun 2007 11:01:58 GMT

hi ,

how can we read the value entered in the dept. number field i'm not getting that please help.

Re: selection-screen

former_member491305 — Tue, 05 Jun 2007 11:14:13 GMT

Hi,

You got to read it_dynpread internal table and then move it to p_dept field.

Check out hte following Eg:

PARAMETERS: p_dept(5) TYPE c,

p_ename(40) TYPE c.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_ename.

DATA :it_dynpread LIKE dynpread OCCURS 1 WITH HEADER LINE.

REFRESH it_dynpread .

it_dynpread-fieldname = 'P_DEPT'.

APPEND it_dynpread .

CALL FUNCTION 'DYNP_VALUES_READ'

EXPORTING

dyname = sy-repid

dynumb = sy-dynnr

TABLES

dynpfields = it_dynpread

EXCEPTIONS

OTHERS.

READ TABLE it_dynpread INDEX 1.

p_dept = it_dynpread-fieldvalue.

SELECT DISTINCT

emp_name

FROM employee INTO CORRESPONDING FIELDS OF TABLE

itab WHERE

dept = p_dept.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'EMP_NAME'

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'P_ENAME'

value_org = 'S'

TABLES

value_tab = itab.

Re: selection-screen

Former Member — Tue, 05 Jun 2007 11:19:36 GMT

hi,

check this

go to transaction abapdocu

abapdocu->screens->processing screens->F4 help from screens

i think this will help u better