topic Re: Search help returning multiple parameters in Application Development and Automation Discussions

Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:31:19 GMT

Hi Experts,

I am facing this issue.

I have two fields - Catgory ID and Category Description.

I have created a search help whihc returns both the parameters.

Now how do i access the two parameters inside my report in SE38.

I need to show the Description to the User and use the ID for Programming.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:34:30 GMT

Can you be bit more clear about your problem.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:38:46 GMT

Hi,

Let me be more clear.

I have a field on my screen - CAT Description.

Now there is a field CAT GUID which is the unique key in a DB table.

I have a F4 help on CAT Description which exports back two parameters - GUID and Description.

Now i need to access both these parameters in my report.

I have to show Description in the input field on the selectionscreen.

and i need to use the ID field to process furthut data.

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 09:46:15 GMT

Hi Gaurav,

After getting the description value from selection screen you can use SELECT SINGLE statement to get GUID from DB table into one variable, as description is the only key it will get the associated GUID only.

You can use this value further to your processing.

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:49:12 GMT

Hi Vikas,

I have the GUID as the key field and not the description.

I need the GUID for the description.

If i do select single, the GUID selected may not be correct as i can have multiple GUID with same description.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:49:37 GMT

You must be using F4_IF_INT_TABLE...fm to generate the F4.

After user selects the value, you can read the table (which you are passing to F4) and get the description

Re: Search help returning multiple parameters

former_member404244 — Tue, 04 Nov 2008 09:50:02 GMT

Hi ,

Instead of using serch help try using fm 'F4IF_INT_TABLE_VALUE_REQUEST'

and pass only the deciption field value..

as u r getting both id and description in the above fm pass only description and then in ur program already u have id...

now u can read what is the description that the user has selected in the selection screen,get the corresponding id and then process ur program...

the same thingu can do for ur search help,though it shows both on the screen, the description field will be filled by description only and then u can read it in ur program..

Regards,

Nagaraj

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 09:52:14 GMT

Hi Swastik,

Can u tell me how to pass the data into the FM F4_IF_INT_TABLE and retrieve the data in my report program.

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 09:58:53 GMT

Ok, so in this case you need to use FM 'F4IF_INT_TABLE_VALUE_REQUEST'.

Fill up the dynpfld_mapping table by passing field name and dyn field name for both the fields. Pass this table to above FM. You will get the selected values into table return_tab for both the fields.

Take a look into debug how the values are populated into the return table.

Here is one sample code for you.

******************************************************

REFRESH: i_dyn, i_ret.

MOVE:

'FIELD1' TO wa_dyn-fldname,

pv_dynfld_1 TO wa_dyn-dyfldname.

APPEND wa_dyn TO i_dyn.

CLEAR: wa_dyn.

MOVE:

'FIELD2' TO wa_dyn-fldname,

pv_dynfld_2 TO wa_dyn-dyfldname.

APPEND wa_dyn TO i_dyn.

CLEAR: wa_dyn.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'CODEGRUPPE'

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = pv_dynfld_1

value_org = c_s

TABLES

value_tab = i_qpgrk

field_tab = i_field

return_tab = i_ret

dynpfld_mapping = i_dyn

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

IF sy-subrc NE 0.

No Values Found

MESSAGE text-s01 TYPE c_s.

ENDIF. " IF sy-subrc NE 0

****************************************************

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 10:03:32 GMT

Hi Vikas,

So do i need to update the description field on teh selection screen manually or the field will be filled automaticallly???

Regards

Gaurav Raghav

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 10:05:03 GMT

As you select the values from F4 popup these values will be filled automatic into the return table.

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 10:08:25 GMT

yes vikas.

what i mean is that since i am going to provide F4 help for field Description and use this Fm to get the data.

When the user selects an entry, i will get both entries in th ret_tab.

but will the selection-screen field 'description' will be filled or i need to do that m,yself.

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 10:10:01 GMT

ya..the selection screen field value will be filled automatic..no need to enter again manually..

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 10:28:38 GMT

Hi Vikas,

Where do i specify the Search Help i am using to get the values in the F4.

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 10:44:44 GMT

You need not to specify the search help in this case. Just write one perform as below.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_field.

PERFORM provide_f4 USING 'P_FIELD'.

and write the code to call the FM into this form.

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 10:48:39 GMT

Hi Vikas,

I need to show the user a F4 Help for the Screen field 'Description' and then the search help will return both Description and GUID.

Now i need to fill the Description field in the selection screen and somehow be able to access the GUID for furthur processing.

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 10:53:13 GMT

Gaurav, try to debug the code. After the user selects any value from F4 popup both the GUID and description will be filled into return table. After you function call you just need to READ this internal table to get the GUID.

For more information about this you can go through the documentation avilable for that function module.

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Tue, 04 Nov 2008 10:57:33 GMT

Hi Vikas,

Then i need to write the code to get the values in the F4 help in the program itself and also how do i know which entry the user has selected????

Re: Search help returning multiple parameters

VikasB — Tue, 04 Nov 2008 11:08:17 GMT

Yes, you need to write the explicit code to get F4 values in your report and as I said the selected values will be populated into RETURN table. You have to just need to READ this table to get those values.

Go to your Report. Write the perform as I already sent. Get the F4 help value table. Put your code to call that function module. Read the table after this FM call and finaly put a BREAK-POINT on this read statement and see what all values are there.

Regards,

Vikas.

Re: Search help returning multiple parameters

Former Member — Wed, 05 Nov 2008 12:27:06 GMT

Hi Vikas,

I am able to see only one value in the return table i.e the description.

I have added the code to get the F4 value table in lt_cat_label.

but the lt_return is onlt getting one value.

here is the code.

IF sy-subrc EQ 0.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'P_RES1'

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'P_RES1'

value_org = 'S'

TABLES

value_tab = lt_cat_label

return_tab = lt_ret_tab

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

IF sy-subrc EQ 0.

READ TABLE lt_ret_tab INTO ls_ret_tab INDEX 1.

ENDIF.

Please let me know what is the mistake i am doing??

Regards

Gaurav