topic Re: SEARCH Button Option in Table Control . in Application Development and Automation Discussions

SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 06:24:51 GMT

Hi Gurus,

I'm developing a Module pool screen having Screen fields and also a table control ,

Now I need to create a SEARCH Button in screen,such that refereing to the fields in the screen the values

should appear in table control.

Let me elaborate in..

I have a screen with fields EMPLOYEE_ID, Full Name and Created _on(date) fieilds.

In Table control i have ACTIVITY, DATE,and NO.of hours fields.

when i search as according to employee_ID and CREATED_ON criteria data should be displayed in Tabel Control.

Done a lot of R&D in coding also refered old SCN posts couldn't succeed, Please HELP!!

Regards

Rohan.

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 06:28:54 GMT

Hi Rohan,

Where do you want to search? In database tables?

Where is the data which you want to search?

Regards,

Ibrahim

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 06:33:53 GMT

i have two database table one is EMPLOYEE table and another is ACTIVITY table.

Employee_ID(EMPLOYEE table) is related with ACTIVITY table.

I need a SEARCH BUtton in Screen.

now when i search for activity records which is stored in ACTIVITY Table.

Search criteria are EMPLOYEE_ID and CREATED_ON(date).

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 06:44:47 GMT

Hi Rohan,

Can you please let me know the issue which you are facing. Do u need the logic to develop this. or are you facing any issues to start this development.

I can help you onthis.

Thanks,

Lakshmi

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 06:57:12 GMT

Read following thread Former Member give perfect solution .

http://scn.sap.com/thread/719601

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 07:12:19 GMT

Hi Lakshmi,

it would be helpfull if you post the logic ,

i have done some coding too , let me check if it will right or not

Thanx & Regards

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 07:14:55 GMT

Hi Krupa,

I saw that post too before,

that doesn't satisfy my condition, by the way the scenario and the condition in that is totally different from mine.

Because in that scenario there was other fields either than the table control.

but i have both.

Thanx for the suggestion

Re: SEARCH Button Option in Table Control .

Former Member — Fri, 27 Apr 2012 07:23:39 GMT

Hi Rohan,

I guess both the tables Employee and Activity has Employee ID as a key field. If its so, then fetch data from both the tables using inner join in an internal table ITAB when you press the button Search. Once you have the data, you can loop through the table ITAB and find out how many records matches with the values given in Employee ID and Created on fields. Move these records in your final table and display in your Table control.