topic Re: Assign Search help in report program in Application Development and Automation Discussions

Assign Search help in report program

Former Member — Tue, 09 Dec 2008 05:07:17 GMT

Dear All,

I facing problem to assign search help in report program.

I crated one elementary search help in which three fields i include

-carrid

-carrier name

-booking

all three fields having import and export parameter in search help.

while executing this search help in se11 it gives proper output.

but while assigning this search help in report program it only fetch one carried.

my report is also having three parameter

-carrid

-carrier name

-booking

i assign search help like

PARAMETER : p_carrid TYPE scarr-carrid

MATCHCODE OBJECT z01_carrid,

with all three field but it fetch only carrid ...

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 05:24:05 GMT

check weather ur search help has been activated properly r not....

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 05:28:10 GMT

search help is activated but it fetch only one field and remaining fields are as blank

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 06:02:23 GMT

my report is also having three parameter

-carrid

-carrier name

-booking

i assign search help like

PARAMETER : p_carrid TYPE scarr-carrid

MATCHCODE OBJECT z01_carrid,

for the above code u will get search help only one parameters-->p_carrid

u should create sepe search help for other two parameters...

PARAMETER : p_carrid TYPE scarr-carrid MATCHCODE OBJECT z01_carrid,

PARAMETER : p_carrname TYPE scarr-carrname MATCHCODE OBJECT z01_carrname, --->(create new search help and attach.)

PARAMETER : p_booking TYPE scarr-carrid MATCHCODE OBJECT z01_booking, --->(create new search help and attach.)

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 06:18:57 GMT

Hi Chintan,

For such types of requirements you can use this Function Module:

F4IF_INT_TABLE_VALUE_REQUEST.

Use this functiom modue under AT SELECTION-SCREEN ON HELP-REQUEST FOR P_CARRID.

With this function module, you can fill your remainng parameters : P_carriername and booking also.

Sample Code:

DATA : TMP_RETURN_TAB LIKE TABLE OF DDSHRETVAL, TMP_RETURN LIKE DDSHRETVAL,

TMP_FIELD TYPE DFIES-FIELDNAME.

CASE AKIND.

WHEN '1'.

TMP_FIELD = 'AENNR'.

WHEN '2'.

TMP_FIELD = 'VBELN'.

WHEN '3'.

TMP_FIELD = 'ZZTEHAI'.

ENDCASE.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

RETFIELD = TMP_FIELD

WINDOW_TITLE = ATITEL

VALUE_ORG = 'S'

TABLES

VALUE_TAB = ATABLES

RETURN_TAB = TMP_RETURN_TAB

EXCEPTIONS

PARAMETER_ERROR = 1

NO_VALUES_FOUND = 2

OTHERS = 3.

IF SY-SUBRC = 0.

READ TABLE TMP_RETURN_TAB INDEX 1 INTO TMP_RETUN.

AVALUE = TMP_RETURN-FIELDVAL.

ENDIF.

Jus analyze this code, you can get ur requirement done.

Regards

Sandeep Reddy

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 07:04:48 GMT

u should create separate search help for other two parameters...

PARAMETER : p_carrid TYPE scarr-carrid MATCHCODE OBJECT z01_carrid,

PARAMETER : p_carrname TYPE scarr-carrname MATCHCODE OBJECT z01_carrname, --->(create new search help and attach.)

PARAMETER : p_booking TYPE scarr-carrid MATCHCODE OBJECT z01_booking, --->(create new search help and attach.)

Try it out i hope it wotld work then

Thanks and regards reeha

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 07:33:38 GMT

Dear shan palani,

I tried this, but my expected output is

in first field i select carrid 'AA'

so in second search help only shows the 'AA' related carrier name like this.,

so for this condition please help.

Thanks & Regards

Chintan

Re: Assign Search help in report program

Former Member — Tue, 09 Dec 2008 10:27:25 GMT

F4IF_INT_TABLE_VALUE_REQUEST in the FM take the help of FIELD_MAPPING or use the FM DNYP_VALUES_UPDATE

Best Regards

Ramchander Rao.K

Re: Assign Search help in report program

Former Member — Wed, 10 Dec 2008 04:11:44 GMT

Hi,

2 Ways are there

1. Match code ID

2. FM

1.Match Code Id

SELECT-OPTIONS s_reqnam FOR tablename-bname

MATCHCODE OBJECT user_comp.

create search help and attc to match code.

TYPES:

BEGIN OF l_t_values,

status_text TYPE tj30t-txt30,

estat TYPE tj30t-estat, "User Status

END OF l_t_values.

DATA: l_i_values TYPE STANDARD TABLE OF l_t_values,

l_wa_values LIKE LINE OF l_i_values.

REFRESH i_values[].

IF NOT i_itmstat IS INITIAL.

CLEAR wa_values.

LOOP AT i_itmstat INTO wa_itmstat.

MOVE: wa_itmstat-txt30

TO l_wa_values-status_text.

MOVE wa_itmstat-estat TO l_wa_values-estat.

APPEND l_wa_values TO l_i_values.

ENDLOOP. " LOOP AT i_hdrstat

*Transport values to table dynpro/screen table control

DATA: lf_repid TYPE sy-repid,

lf_dynnr TYPE sy-dynnr,

lf_dynprofield TYPE help_info-dynprofld,

lf_retfield TYPE dfies-fieldname.

MOVE: sy-repid TO lf_repid,

sy-dynnr TO lf_dynnr,

'TJ30T-ESTAT' TO lf_dynprofield,

'TJ30T-ESTAT' TO lf_retfield.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = lf_retfield

dynpprog = lf_repid

dynpnr = lf_dynnr

dynprofield = lf_dynprofield

value_org = 'S'

TABLES

value_tab = l_i_values

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

IF sy-subrc EQ 0.

CLEAR wa_values.

ENDIF.