‎2008 Jul 08 1:43 PM
Hi
I creating search help for one field. Here i call "f4if_int_table_value_request" function module.
but i didn't get the values. It displayed message as no values found.
I am send my code also. Please tell me where it is mistake.
DATA: BEGIN OF ITAB OCCURS 0,
CARRNAME TYPE SCARR-CARRNAME,
END OF ITAB.
PARAMETERS: P_CNAME LIKE SCARR-CARRNAME.
SELECT CARRNAME
FROM SCARR
INTO CORRESPONDING FIELDS OF TABLE ITAB.
SORT ITAB BY CARRNAME.
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING CARRNAME.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_CNAME.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
DDIC_STRUCTURE = ' '
RETFIELD = 'P_CNAME'
PVALKEY = ' '
DYNPPROG = 'YEXP'
DYNPNR = '1000'
DYNPROFIELD = 'P_CNAME'
STEPL = 0
WINDOW_TITLE =
VALUE = ' '
VALUE_ORG = 'S'
MULTIPLE_CHOICE = ' '
DISPLAY = ' '
CALLBACK_PROGRAM = ' '
CALLBACK_FORM = ' '
MARK_TAB =
TABLES
VALUE_TAB = ITAB
FIELD_TAB =
RETURN_TAB =
DYNPFLD_MAPPING =
EXCEPTIONS
PARAMETER_ERROR = 1
NO_VALUES_FOUND = 2
OTHERS = 3
.
IF SY-SUBRC <> 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
thanks
‎2008 Jul 08 1:45 PM
Hi Sri,
You have to put the selection either in the INITIALIZATION event or also in the AT SELECTION-SCREEN
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_CNAME.
SELECT CARRNAME
FROM SCARR
INTO CORRESPONDING FIELDS OF TABLE ITAB.
SORT ITAB BY CARRNAME.
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING CARRNAME.
....
Regards,
John.
‎2008 Jul 08 1:45 PM
Hi Sri,
You have to put the selection either in the INITIALIZATION event or also in the AT SELECTION-SCREEN
AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_CNAME.
SELECT CARRNAME
FROM SCARR
INTO CORRESPONDING FIELDS OF TABLE ITAB.
SORT ITAB BY CARRNAME.
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING CARRNAME.
....
Regards,
John.
‎2008 Jul 08 1:53 PM
Hi John,
Thanks for your answer. It solved for your answer only.
thanks allot.
‎2008 Jul 08 1:47 PM
hi,
Check out the sample code in the below link for reference
http://help.sap.com/saphelp_nw70/helpdata/en/9f/dbaac935c111d1829f0000e829fbfe/content.htm
Regards,
Santosh
‎2008 Jul 08 1:55 PM
Hi,
Try this example.
PARAMETERS :
p_carrid LIKE spfli-carrid.
DATA:
w_carrid LIKE spfli-carrid,
W_CONNID LIKE SPFLI-CONNID.
DATA:
T_RETURN TYPE STANDARD TABLE OF DDSHRETVAL WITH HEADER LINE.
DATA:
W_CONN TYPE dfies-fieldnamE,
W_CARR TYPE dfies-fieldname.
DATA:
BEGIN OF T_FLIGHT OCCURS 0,
carrid TYPE SPFLI-CARRID,
connid TYPE SPFLI-CONNID,
FLDATE TYPE SFLIGHT-FLDATE,
END OF T_FLIGHT .
DATA:
BEGIN OF itab_connid OCCURS 3,
carrid TYPE S_CARR_ID,
connid TYPE SPFLI-CONNID,
END OF itab_connid.
DATA:
BEGIN OF itab_carrid OCCURS 3,
carrid TYPE SPFLI-CARRID,
END OF itab_carrid.
START-OF-SELECTION.
SELECT CARRID
CONNID
FLDATE
INTO TABLE T_FLIGHT
FROM SFLIGHT
WHERE CARRID = W_CARRID
AND CONNID = W_CONNID.
LOOP AT T_FLIGHT.
WRITE :/ T_FLIGHT-CARRID,
T_FLIGHT-CONNID,
T_FLIGHT-FLDATE.
ENDLOOP.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_carrid.
SELECT carrid
FROM SCARR
INTO CORRESPONDING FIELDS OF TABLE itab_carrid.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = W_CARR
value_org = 'S'
TABLES
value_tab = itab_carrid
RETURN_TAB = T_RETURN
EXCEPTIONS
parameter_error = 1
no_values_found = 2
OTHERS = 3.
IF sy-subrc EQ 0.
READ TABLE ITAB_CARRID INDEX sy-tabix INTO p_carrid.
ENDIF.
w_carrid = T_RETURN-FIELDVAL.
P_CARRID = W_CARRID.Regards,
rajitha.