topic Re: Regarding Search Help in Application Development and Automation Discussions

Regarding Search Help

Former Member — Fri, 20 Jun 2008 05:45:53 GMT

Hi,

I am able to create an elimentary search help using a view which actually joins two table s like EMP and DEPT. In this search help all the DEPT_NO are appearing in case if those are duplicate then also it is coming in the list. But what I want to do is that I want to give a DEPT_NO and want to see all the employees details for that department. If multiple employee exist in that department then I want to see all the employees.

How I can achive this?

I am very new to SAP, so I don't have much idea about ABAP programming. If I have to write any ABAP code for the above requirement then please also specify how do I compile and execute that one.

Regards,

Koushik

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 05:57:00 GMT

Hi,

I think DEP_NO is foreign key in the emp table. Then pass the DEP_NO to the EMP table and get all the EMP details.

select emp_no emp_name pay join_ date

from emp

into table itab

where dep_no = emp-dep_no.

For the dep_no selected in the dep table you get all the employee details.

Reward.

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 06:03:14 GMT

But where I should write the SQL? How the sql will be executed? and how will I find the result?

Can you please provide the exact steps I have to perform over here.

Regards,

Koushik

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 06:07:20 GMT

Hi Koushik,

Please check this link for select queriey

SELECT ...INTO TABLE

http://www.sapbrainsonline.com/ARTICLES/TECHNICAL/optimization/optimization.html#Select%20u2026%20Into%20table

Best regards,

raam

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 06:12:28 GMT

Sorry... My question is not on the select query. Rather my question is that how do I incorporate the select query and come up with the search screen.

Regards,

Koushik

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 07:31:51 GMT

Hi Koushik,

I think you can do 2 things here.

1. Either you can use Search help Exits to perform this. There you can write the query and the search help will be populated with the data. Generally Search help exits are used for filtering the data.

2. You can create a View and then create a search help on this view.

Regards,

Saurabh

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 09:05:36 GMT

Hi,

As I have already specified that I am very new to SAP, sa can you please explain "Search help Exits" in slightly more detail.

In the other option I have already created a view joining EMP and DEPT table on DEPT_NO column and using this view in elimentary search help feature. What else are you suggesting over here?

I am aware of Elimentary serch help & Collective search help. So anything else you want to specify please explain those a little bit more or provide some reference URL from where I can learn that.

Regards,

Koushik

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 09:26:46 GMT

Hi,

I hope the following links helps you.

http://aiokeh.wdf.sap.corp:50000/SAPIKS2/contentShow.sap?_CLASS=IWB_EXTHLP&_LOIO=FCFDF4D8346711D3A6720060086FAF1D&&TMP_IWB_TASK=DISPLAY&RELEASE=700&LANGUAGE=EN

Regards,

Saurabh

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 09:33:39 GMT

Sorry ... The link is not working ... ERROR IS - "Unable to determine IP address from host name for aiokeh.wdf.sap.corp"

Can you please recheck or send an alternative link.

Regards,

Koushik

Re: Regarding Search Help

Former Member — Fri, 20 Jun 2008 09:41:16 GMT

Hi,

Sorry...

http://help.sap.com/saphelp_nw04/helpdata/EN/cf/21ee52446011d189700000e8322d00/frameset.htm

This link should work..

Regards,

Saurabh