SEARCH Button Option in Table Control .

[Former Member]

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.

[Former Member]

Hi Rohan,

Where do you want to search? In database tables?

Where is the data which you want to search?

Regards,

Ibrahim

[Former Member]

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).

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[former_member182040]

Read following thread Former Member  give perfect solution   .

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

[Former Member]

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