topic Re: search help and user fields in Application Development and Automation Discussions

search help and user fields

Former Member — Thu, 18 May 2006 17:18:05 GMT

Hi all,

I want to display a search help for a Project Systems user field. I tried to attach a search help directly to the field (PRPS-USR03) but it didn't work. I don't think that is the correct approach. Something tells me I should include this logic in a user exit. Can anyone give me some idea as to how I can accomplish this task?

regards,

Mat

Re: search help and user fields

Former Member — Thu, 18 May 2006 17:26:05 GMT

hello Mathew,

You can create search helps in SE11. There is a radiobutton for them. Is this search help for a custom table?

You can define search helps over database tables or views. Enter the name of the db table or view in the Selection Method field, then at the bottom add the fields that you want to show in the search help.

SH creation: In SE11, give a custom name for search help and select Elementary or Cumulative. Then in Selection method select the table from which the data needs to be fetched.

Provide the fields that are to be retreived in Search help parameters.check the fields that are to be imported and exported and also the position(1.2..) of the fields to be displayed.

And in the custom table give this search help in help/check in se11 table display.

This should solve your problem

Regards,

Naveen

Re: search help and user fields

Former Member — Thu, 18 May 2006 17:35:04 GMT

Thanks much Naveen. Here is my dilemma. The search help I want to add is for the table PRPS and the field is USR03. This is NOT a custom table. Further, the help selection is dependent upon the value of another field in PRPS named SLWID. For instance, if the screen filed value of SLWID = 'DIR' then I want to display a USR03 help list consisting of three values S, N or P. I don't believe I can add this search help directly to USR03 in PRPS. I think I need to use a user exit...any thoughts?

Re: search help and user fields

LucianoBentiveg — Thu, 18 May 2006 18:16:40 GMT

Need you the search help in standard programs or just in Z?

Re: search help and user fields

Former Member — Thu, 18 May 2006 18:19:42 GMT

I need to have the search help displayed in the standard tcode CJ20N.

Re: search help and user fields

LucianoBentiveg — Thu, 18 May 2006 18:34:59 GMT

So you need to create your own search help like says NAVEENKUMAR GUDURI and get acces key to do the modification in PRPS table.

Regards.

Re: search help and user fields

Former Member — Thu, 18 May 2006 19:40:38 GMT

I tried that by creating an elementary search help including one export paramter...usr03. I used the access key to attach the search help to the field in the table. When I execute CJ20N I navigate to usr03 and click f4...nothing happens No list...no nothing!!

As a side note. I did find a BADI named WBS_USER_FIELDS_F4 that I implemented...but the interface only allows me to return a single value...is there a way to display a select list from the interface...when the user selects a value from the select list I can return it in the export paramter.

Re: search help and user fields

Former Member — Thu, 22 Feb 2007 06:21:24 GMT

Hi Matthew,

Perharps this reply might be too late. I just developed this badi and return multiple values by using function F4IF_INT_TABLE_VALUE_REQUEST.

here's the coding:

method IF_EX_WBS_USER_FIELDS_F4~AT_F4 .

To enhance field Project Category in Screen CJ02
(PRPS-USR03)

check i_PRPS-SLWID = 'ZPS0001'.

CHECK i_user_field = 'PRPS-USR03'.

CALL FUNCTION 'ZBW_GET_SEARCH_HELP'

IMPORTING

E_VALUE = E_VALUE

endmethod.

FUNCTION zbw_get_search_help.

*"----

""Local interface:

*" EXPORTING

*" REFERENCE(E_VALUE) TYPE PRPS-USR00

*"----

DATA : BEGIN OF itab OCCURS 0,

e_value(20),

END OF itab.

DATA: BEGIN OF field_tab OCCURS 0.

INCLUDE STRUCTURE dfies.

DATA END OF field_tab.

DATA : return_tab LIKE ddshretval OCCURS 0 .

REFRESH: field_tab.

CLEAR field_tab.

field_tab-fieldname = 'E_VALUE'.

field_tab-intlen = 20.

field_tab-outputlen = 20.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Project Category'.

APPEND field_tab.

CLEAR field_tab.

field_tab-fieldname = 'DESC'.

field_tab-intlen = 30.

field_tab-outputlen = 30.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Description'.

APPEND field_tab.

REFRESH: itab.

select * from zbw_proj.

CLEAR: itab.

itab-e_value = zbw_proj-PROJ_DEF.

APPEND itab.

CLEAR: itab.

itab-e_value = zbw_proj-PROJ_DEs.

APPEND itab.

endselect.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'E_VALUE'

dynprofield = 'A'

dynpprog = sy-cprog

dynpnr = sy-dynnr

TABLES

value_tab = itab

field_tab = field_tab

return_tab = return_tab

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

ENDFUNCTION.

Re: search help and user fields

Former Member — Tue, 29 May 2007 14:00:42 GMT

Hi Ester,

Could you please explain the following in detail :

1) What are all the import & export parameters for the function module ZBW_GET_SEARCH_HELP.

2) What are the fields that are stored in the Ztable : zbw_proj

3) What is the significance of Internal table : field_tab

4)'F4IF_INT_TABLE_VALUE_REQUEST' is used to populate all possible values. After selecting one value out of all the possible values, do we need to export/import them? not very clear on this... could you please explain the program flow.

Regards,

Syam

Re: search help and user fields

Former Member — Tue, 29 May 2007 14:01:53 GMT

Hi Ester,

Could you please explain the following in detail :

1) What are all the import & export parameters for the function module ZBW_GET_SEARCH_HELP.

2) What are the fields that are stored in the Ztable : zbw_proj

3) What is the significance of Internal table : field_tab

Regards,

Syam

Re: search help and user fields

Former Member — Mon, 04 Jun 2007 13:54:24 GMT

Take a look at OSS note [Removed by the moderator.]

Re: search help and user fields

Former Member — Wed, 18 Jul 2007 06:06:11 GMT

hi all, sorry for the late reply,

FUNCTION zbw_get_search_help.

*"----

""Local interface:

*" IMPORTING

*" REFERENCE(FIELD) TYPE ZFIELD

*" EXPORTING

*" REFERENCE(E_VALUE) TYPE PRPS-USR00

*"----

DATA : BEGIN OF itab OCCURS 0,

e_value(20),

END OF itab.

DATA: BEGIN OF field_tab OCCURS 0.

INCLUDE STRUCTURE dfies.

DATA END OF field_tab.

DATA : return_tab LIKE ddshretval OCCURS 0 with header line.

REFRESH: field_tab.

*start of UCR6379

tables: Zinvest, ZREGIONSTATE.

*end of UCR6379

*start of UCR6379: PS enhancement

CASE field.

WHEN 'PRPS-USR03'. "project category

end of UCR6379

CLEAR field_tab.

field_tab-fieldname = 'E_VALUE'.

field_tab-intlen = 20.

field_tab-outputlen = 20.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Project Category'.

APPEND field_tab.

CLEAR field_tab.

field_tab-fieldname = 'DESC'.

field_tab-intlen = 30.

field_tab-outputlen = 30.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Description'.

APPEND field_tab.

REFRESH: itab.

SELECT * FROM zbw_proj.

CLEAR: itab.

itab-e_value = zbw_proj-proj_def.

APPEND itab.

CLEAR: itab.

itab-e_value = zbw_proj-proj_des.

APPEND itab.

ENDSELECT.

WHEN 'PRPS-USR07'. "investment no

CLEAR field_tab.

field_tab-fieldname = 'E_VALUE'.

field_tab-intlen = 20.

field_tab-outputlen = 20.

field_tab-decimals = 2.

field_tab-inttype = 'C'.

field_tab-REFTABLE = 'ZINVEST'.

field_tab-REFFIELD = 'ZNO'.

field_tab-scrtext_m = 'Investment No'.

APPEND field_tab.

CLEAR field_tab.

field_tab-fieldname = 'DESC'.

field_tab-intlen = 30.

field_tab-outputlen = 30.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Description'.

APPEND field_tab.

REFRESH: itab.

SELECT * FROM ZINVEST.

CLEAR: itab.

itab-e_value = ZINVEST-ZNO.

APPEND itab.

CLEAR: itab.

itab-e_value = ZINVEST-ZDESC.

APPEND itab.

ENDSELECT.

WHEN 'PRPS-USR02' or 'PRPS-USR01'. "region & state

CLEAR field_tab.

field_tab-fieldname = 'Region'.

field_tab-intlen = 20.

field_tab-outputlen = 20.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'Region'.

APPEND field_tab.

CLEAR field_tab.

field_tab-fieldname = 'E_VALUE'.

field_tab-intlen = 20.

field_tab-outputlen = 20.

field_tab-inttype = 'C'.

field_tab-scrtext_m = 'State No'.

APPEND field_tab.

REFRESH: itab.

SELECT * FROM ZREGIONSTATE.

CLEAR: itab.

itab-e_value = ZREGIONSTATE-STATE_NO.

APPEND itab.

CLEAR: itab.

itab-e_value = ZREGIONSTATE-REGION.

APPEND itab.

ENDSELECT.

*start of UCR6379: PS enhancement

ENDCASE.

*end of UCR6379

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'E_VALUE'

dynprofield = 'A'

dynpprog = sy-cprog

dynpnr = sy-dynnr

TABLES

value_tab = itab

field_tab = field_tab

return_tab = return_tab

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

if field = 'PRPS-USR02' or field = 'PRPS-USR01'..

read table return_tab index 1.

endif.

ENDFUNCTION.

in badi WBS_USER_FIELDS_F4, field E_VALUE is the return value, therefore in fm 'F4IF_INT_TABLE_VALUE_REQUEST' , retfield is 'E_VALUE'

Re: search help and user fields

Former Member — Mon, 23 Jul 2007 17:26:45 GMT

Hi, can you explain me the procedure of use the badi, please it's urgent.

I don´t understand yor code in some parts

I´´m beginner in abap

Thanks