2008 Dec 09 5:07 AM
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 ...
2008 Dec 10 4:11 AM
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.
2.
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.
ENDIF.
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 ...
2008 Dec 09 5:24 AM
check weather ur search help has been activated properly r not....
2008 Dec 09 5:28 AM
search help is activated but it fetch only one field and remaining fields are as blank
2008 Dec 09 6:02 AM
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.)
2008 Dec 09 7:33 AM
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
2008 Dec 09 10:27 AM
HI
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
2008 Dec 09 6:18 AM
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
2008 Dec 09 7:04 AM
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
2008 Dec 10 4:11 AM
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.
2.
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.
ENDIF.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |