topic Re: Regarding Serch help in Application Development and Automation Discussions

Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:22:44 GMT

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?

Re: Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:32:56 GMT

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

Re: Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:36:32 GMT

Hi shefali,

1. T001W

2. This is the table which stores distinct werks.

3. Search help name is H_T001W_C

regards,

amit m.

Re: Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:43:20 GMT

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?

Re: Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:47:50 GMT

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.

Re: Regarding Serch help

Former Member — Tue, 22 Aug 2006 05:54:03 GMT

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