Problem with search help

[Former Member]

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.

[RaymondGiuseppi]

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

[Former Member]

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?

[RaymondGiuseppi]

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

[Former Member]

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

[Former Member]

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

[RaymondGiuseppi]

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

[Former Member]

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

[Former Member]

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