MATCHCODE OBJECT

[Former Member]

Hi Friends,

I have used matchcode object in type M program for a department field of ZTable. Now the F4 help shows me all the entries including duplicate. I want to restrict the duplicate entries in my f4 help. Is there any option in Search help which helps me to clear the duplicate entries. Is it possible through matchcode we can restrict duplicate entries?

Regards,

Himanshu Rangappa

[raja_narayanan2]

Hi...

You cant restrict the duplicate entires through matchcode...

but instead of fetching duplicate values... select that filed in your ztable as Primary key so that you wont have duplicate values.

Thanks & regards

Raja

[Former Member]

hi

try this code....

PROCESS ON VALUE-REQUEST.
  FIELD ytdsrate-tax_type MODULE browse1.

 SELECT DISTINCT witht
           text40
           FROM t059u
           INTO CORRESPONDING FIELDS OF TABLE it_witht1
           WHERE spras EQ 'EN'.

    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
      EXPORTING
        retfield        = 'WITHT'
        dynpprog        = sy-repid
        dynpnr          = sy-dynnr
        dynprofield     = 'YTDSRATE-TAX_TYPE'
        value_org       = 'S'
      TABLES
        value_tab       = it_witht1
      EXCEPTIONS
        parameter_error = 1
        no_values_found = 2
        OTHERS          = 3.

Arunima

[Former Member]

hi friend,

I know the f4 function, just want to ask is it possible through mathchcode?

regards,

himanshu

[Former Member]

OK....

also you can do by going in the screen layout.....

just attach the name of your search-help in screen painter...double click on the attribute...write the search help name under the "Dict" tab .....

Arunima