F4 help for table

[Former Member]

Hi All,

i have a table say za1 for a fiel say status i have declared it as

table za2 which has field status and descripton description is not a primary key . in za1 table when doing f4 on status i am only able to see value not description how shall i able to do that.

Regards

Arun.

[Former Member]

hi,

where actually u r watching the f4 request..

if u r doin it in Module pool then provide a search help and give it...thtz it...it will work....

rewards,

Vamshi

[Former Member]

Hi vamsi,

Thanks for the answer But please specify how will i create search help. i am not using module pool .

Regards

Arun.

[P561888]

Hi ,

try to create the Search Helps for that...

[Former Member]

Hi,

u follow like that in ur program

FORM f4_division .

SELECT division zdescr FROM zdivnbabu INTO TABLE lt_division .

SORT lt_division BY division.

DELETE ADJACENT DUPLICATES FROM lt_division COMPARING division.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = text-006

dynpprog = 'ZFIGL_REP_CUSTOMERDETAILS01'

dynpnr = '1000'

dynprofield = 'ZDIVNBABU-DIVISION'

value_org = 'S'

TABLES

value_tab = lt_division

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.

ENDIF.

[Former Member]

Hi

Are you doing the coding as showb below:

*FOR F4 HELP

DATA: BEGIN OF I_VALUES OCCURS 0,

STATUS LIKE ........,

DESC LIKE ........,

END OF I_VALUES.

DATA: T_RETURN LIKE DDSHRETVAL OCCURS 0 WITH HEADER LINE.

*For F4 help at Current Idoc number

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_STATUS.

*-- Fill values

LOOP AT I_STATUS INTO WA_STATUS.

I_VALUES-STATUS = WA_STATUS-STATUS.

I_VALUES-DESC = WA_STATUS-DESC.

APPEND I_VALUES.

ENDLOOP.

SORT I_VALUES ASCENDING BY DOCNUM .

CLEAR T_RETURN.

REFRESH T_RETURN.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

• DDIC_STRUCTURE = 'EDIDC'

RETFIELD = 'STATUS'

• PVALKEY = ' '

• DYNPPROG = ' '

• DYNPNR = ' '

• DYNPROFIELD = ' '

• STEPL = 0

• WINDOW_TITLE =

• VALUE = ' '

VALUE_ORG = 'S'

• MULTIPLE_CHOICE = ' '

• DISPLAY = ' '

• CALLBACK_PROGRAM = ' '

• CALLBACK_FORM = ' '

• MARK_TAB =

• IMPORTING

• USER_RESET =

TABLES

VALUE_TAB = I_VALUES

• FIELD_TAB =

RETURN_TAB = T_RETURN

• 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.

ENDIF.

IF SY-SUBRC = 0.

READ TABLE T_RETURN INDEX 1.

P_STATUS = T_RETURN-FIELDVAL.

ENDIF.

CLEAR I_VALUES.

REFRESH I_VALUES.

CLEAR T_RETURN.

REFRESH T_RETURN.

Do reply if it does not solve your problem or if you have different problem.

Regards

Vijai

[Former Member]

Hi All,

i am not doing any codeing for that . just created two tables .

my requirement is to have status on f4 on one of the table.

Regards

Arun.

[Former Member]

Hi All,

i am not supposed to create search help is there any other way we can handle the same .

Regards

Arun.

[Former Member]

hi arun,

you need 2 create a check table with table za2.

for this you need 2 have same data element(data type) field in both tables.

regards,

gupta.

[Former Member]

Hi,

Create a search help for the status field ,

importing parameter as the status code and the exporting as status code and Description.

Once done , assign the search help to the database table fields wherever applicable.

regards,

Advait.