Regarding Search Help

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Koushik,

Please check this link for select queriey

SELECT ...INTO TABLE

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

Best regards,

raam

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

I hope the following links helps you.

http://aiokeh.wdf.sap.corp:50000/SAPIKS2/contentShow.sap?_CLASS=IWB_EXTHLP&_LOIO=FCFDF4D8346711D3A67...

Regards,

Saurabh

[Former Member]

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

[Former Member]

Hi,

Sorry...

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

This link should work..

Regards,

Saurabh