Regarding Serch help

[Former Member]

i have the table with following fields as key:-

werks and matnr.

as these 2 fields combination will act key so in my table there are entriess with the same werks.

when i am bulding a serch help on werks it is giving duplicate entries in serch help.

To get the distinct values for plant in search help what is frequired to do?

[Former Member]

HI

   For WERKS you can add T001W as reference table. But 
if you want to display basing on the entries in the 
customized table then you can create search help exit 
and then restrict the entries for duplicates.

Kind Regards
Eswar

[Former Member]

Hi shefali,

1. T001W

2. This is the table which stores distinct werks.

3. Search help name is H_T001W_C

regards,

amit m.

[Former Member]

if i am using the H_T001W_C serch help, it is giving me all the plants maintained in T001W table.

I want to by pass those values.

I want to give only those values maintained in my custom table.

How to do that?

[Former Member]

Hi again,

1. I want to give only those values maintained in my custom table

U can give,

BUT DISTINCT values won't come automatically

from your table

of WERKS + MATNR (primary key combination)

2. One way is to have

another Z table, which contains

ONLY WERKS (distinct WERKS only)

3. and on that, make search help.

regards,

amit m.

[Former Member]

HI 

   I guess maintaining a search help exit is much 
convinient rather than maintaining a customized table 
again specially for that. Moreover when an new werks 
entry comes in this tables it has to update the later 
one one which is a troublesome task.

  So better create an exit, so you can manipulate the 
way you want.

Kind Regards
Eswar