topic Re: Problem with search help in Application Development and Automation Discussions

Problem with search help

Former Member — Mon, 04 Jul 2011 12:40:11 GMT

Hi all,

I have made new search help and appended it to search help MAT1_A, so it is visible on material fields. One of fields in my search help is EKKO-BSART, data element ESART. When I open my search help (from transaction ME51N), there is no list on field BSART (table field EKKO-BSART has search help, but data element ESART doesn't have). But, from transaction ME23N, on some search helps, there is a list on field EKKO-BSART, and on some not. For example, on field Outline Agreement, search help Purchasing Document per Requirement Tracking Number has a list on Purchasing Document Type wich has data element ESART.

So, what should I do to get the same list on my search help?

Tnx in advance.

Re: Problem with search help

RaymondGiuseppi — Mon, 04 Jul 2011 13:24:13 GMT

How did you build your search help, on which object ?

If this is a customer Z-objet, change its definition in ddic and assign search help H_T161 to field BSART.

Regards,

Raymond

Re: Problem with search help

Former Member — Mon, 04 Jul 2011 13:43:14 GMT

Yes, my search help is built on Z-view. As I am new to SAP, I have to ask, how can I assign search help to view field?

Re: Problem with search help

RaymondGiuseppi — Mon, 04 Jul 2011 14:02:20 GMT

Call transaction SE11, Check View, Input your z-view name, click on change, display the field list tab. Select the line with BSART. Choose one of two options :

- Add a foreign key control with table T161 which should generate a "Input help implemented with check table"

- Click on the box "Mod" adjacent to the data element, change now this data element and give a data element with the required search help.(perform a where used on search help or create a Z-data element)

Regards,

Raymond

Re: Problem with search help

Former Member — Tue, 05 Jul 2011 09:23:00 GMT

Hi,

I still have a problem with this issue. How can I add a foreign key control on field BSART? When I select the line with BSART field and choose foreign key icon, I get a message "no foreign key defined for field..." and I cannot find a way to add one.

Tnx in advance.

Regards,

Nati

Re: Problem with search help

Former Member — Tue, 05 Jul 2011 10:03:18 GMT

Hi,

Select BSART field which has type ESART and click on Foreign key icon. automatically give table name T161. (which give message like "Create proposal with values table T161 as check table ?" click on yes ) now you will get foreign key.

although not create then take BSTYP field ( Purchase docu category ) because when you are going to create foreign key this field is also need.

Regards,

Kunjan

Re: Problem with search help

RaymondGiuseppi — Tue, 05 Jul 2011 10:07:57 GMT

This message is correct in display mode before you add the foreign key and on some type of views, in update mode should be a warning depending of the type of view,

- If you are not able/allowed to add a foreign key, you could add table T161 to the view.

- If you don't want to/cannot add table T161, create a z-dataelement copy from ESART and link it to search help H_T161 then substitute the data element in the view

Regards,

Raymond

Re: Problem with search help

Former Member — Tue, 05 Jul 2011 10:09:50 GMT

Well, as I said, when I select BSART field and click on foreign key icon, I only get a message that foreign key for field is not defined and I don't get any dialog window for creating foreign key.

Regards,

Nati

Re: Problem with search help

Former Member — Tue, 05 Jul 2011 11:44:45 GMT

Raymond,

I made z-data element following your instructions, now it works fine. Thanks a lot.

Just asking, what can be a reason I am not able/allowed to add a foreign key to a view field?

Regards,

Nati