Entry doesnt exist in table check entry

[Former Member]

Hi ,

I have a problem

I am using an F4 help, for a field - the moment i click on the F4 the F4 pops up and i select a value from the list populated.

The moment i select enter, an error pops up which says - entry does not exist in ZTTT003 table - check entry.

I have also debugged and checked all possible but i am not succesful in solving the issue.

I have attached the code, please check if there is an error in the code.

DATA : L_REPID TYPE SY-REPID.

DATA : L_DYNNR TYPE SY-DYNNR.

L_REPID = SY-REPID.

L_DYNNR = SY-DYNNR.

CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST'

EXPORTING

TABNAME = 'ZTTT001'

FIELDNAME = 'ZROUTEID'

• SEARCHHELP = 'ZROUTEID'

• SHLPPARAM = 'ZROUTEID'

DYNPPROG = SY-CPROG

DYNPNR = SY-DYNNR

DYNPROFIELD = 'ZROUTEID'

TABLES

RETURN_TAB = RETURN

EXCEPTIONS

FIELD_NOT_FOUND = 1

NO_HELP_FOR_FIELD = 2

INCONSISTENT_HELP = 3

NO_VALUES_FOUND = 4

OTHERS = 5

.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

REFRESH DYNPFIELDS.

READ TABLE RETURN WITH KEY FIELDNAME = 'ZROUTEID'.

DYNPFIELDS-FIELDNAME = RETURN-RETFIELD.

DYNPFIELDS-FIELDVALUE = RETURN-FIELDVAL.

APPEND DYNPFIELDS.

CLEAR LV_ROUTEID.

LV_ROUTEID = RETURN-FIELDVAL.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING

INPUT = LV_ROUTEID

IMPORTING

OUTPUT = LV_ROUTEID.

SELECT SINGLE ZSITE1 ZSITE2 ZSITE3 ZSITE4 ZSITE5

INTO (LV_SITE1,LV_SITE2,LV_SITE3,LV_SITE4,LV_SITE5)

FROM ZTTT003

WHERE ZROUTEID = LV_ROUTEID.

TBOX1 = LV_SITE1.

TBOX2 = LV_SITE2.

TBOX3 = LV_SITE3.

TBOX4 = LV_SITE4.

TBOX5 = LV_SITE5.

DYNPFIELDS-FIELDNAME = 'TBOX1'.

DYNPFIELDS-FIELDVALUE = LV_SITE1.

APPEND DYNPFIELDS.

DYNPFIELDS-FIELDNAME = 'TBOX2'.

DYNPFIELDS-FIELDVALUE = LV_SITE2.

APPEND DYNPFIELDS.

DYNPFIELDS-FIELDNAME = 'TBOX3'.

DYNPFIELDS-FIELDVALUE = LV_SITE3.

APPEND DYNPFIELDS.

DYNPFIELDS-FIELDNAME = 'TBOX4'.

DYNPFIELDS-FIELDVALUE = LV_SITE4.

APPEND DYNPFIELDS.

DYNPFIELDS-FIELDNAME = 'TBOX5'.

DYNPFIELDS-FIELDVALUE = LV_SITE5.

APPEND DYNPFIELDS.

CALL FUNCTION 'DYNP_VALUES_UPDATE'

EXPORTING

DYNAME = SY-CPROG

DYNUMB = SY-DYNNR

TABLES

DYNPFIELDS = DYNPFIELDS

EXCEPTIONS

INVALID_ABAPWORKAREA = 1

INVALID_DYNPROFIELD = 2

INVALID_DYNPRONAME = 3

INVALID_DYNPRONUMMER = 4

INVALID_REQUEST = 5

NO_FIELDDESCRIPTION = 6

UNDEFIND_ERROR = 7

OTHERS = 8.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

REFRESH DYNPFIELDS.

Please help me in this regards to solve the problem.

thanks,

Sree

[surajarafath]

This might be the problem with creating foreign key in the table ZTTT003

you go to se11 or se16 and check the table ZTTT003

select->Entry help/Check -> then see the check tables, if it has then select the foreign key for that element

the problem with that particular field in the table, i dont think problem in ur program