topic search help values from value table in Application Development and Automation Discussions

search help values from value table

Former Member — Fri, 21 May 2010 08:07:24 GMT

hi sir,

on my report i hava a input filed where by i have to give a search help.

but to that field data element --> domain is ZZCHAR2 --> when i double click on it we see value range.

if we go to value range below we can find a a value table called --> T578Y.

can we able to display the values from the table to that filed?

field = ZMED_SRV-FIT

data element : ZZRESUL

domain : ZZCHAR2

value range ---> has value table --> T578Y

i should display values from this value table

your input is highly appriciated.

i have searched but could not find the answer thats the reason am posting.

thank you,

pasala.

Re: search help values from value table

Himayatullah — Fri, 21 May 2010 09:49:16 GMT

Hi basker,

Do this way...

AT SELECTION-SCREEN ON VALUE-REQUEST for <input field>

fetch all the values from t578y table into a internal table.

Then pass this internal table to function module 'F4IF_INT_TABLE_VALUE_REQUEST'.

Hope this will help you.

best regards

Himayat.

Re: search help values from value table

Former Member — Fri, 21 May 2010 11:16:57 GMT

Hi Basker,

Value Table purpose is to suggest the parent table when you create a FOREIGN KEY relation ship and it doesnt provide F4 Help. You can create a FK relationship then you will get F4 help from this table

or Implement your own F4 Help using F4IF_INT_TABLE_VALUE_REQUEST FM

Cheerz

Ram

Re: search help values from value table

Former Member — Fri, 21 May 2010 12:32:30 GMT

hi,

do in this way..

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'S_TSCY' " select-option field where f4 is needed

dynpprog = sy-repid

dynpnr = sy-dynnr

window_title = 'Task category'

value_org = 'S'

TABLES

value_tab = it_category[] " table contain values to be shown on f4

return_tab = it_f4.

CLEAR wa_f4.

READ TABLE it_f4 INTO wa_f4 INDEX 1.

IF sy-subrc = 0.

s_tscy-low = wa_f4-fieldval.

ENDIF.

CLEAR: wa_f4,it_f4[].

Re: search help values from value table

Former Member — Fri, 21 May 2010 12:35:31 GMT

Hi Basker,

YOu can use search help H_T578Y

IF it is selection screen use the above search help as MATCHCODE OBJECT

parameters abc type char2 MATCHCODE OBJECT H_T578Y. " With this both my posts will serve your purpose
IF it Custom Screen assign this search help at the Field level in the Screen Layout

Cheerz

Ram

Re: search help values from value table

Former Member — Mon, 24 May 2010 05:59:34 GMT

Hi Pasala ,

Just Declare the Parameter like below. It will work and display the F4 help from value table.

Say suppose your table is ZMED_SRV and filed name FIT and that has domain which is linked with value table.


tables  ZMED_SRV.

PARAMETERS p_FIT LIKE ZMED_SRV-FIT.

Re: search help values from value table

Former Member — Mon, 07 Jun 2010 08:21:56 GMT

thank you all.