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.
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.
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |