Filter and Search in Table Control

From last few weeks I am observing two or three threads about searching in Table Control on SDN, those threads gave me idea to develop some Filtering and Searching option in Table Control I just completed this and going to share with you Friends.

I used SELECT-OPTIONs on Screen using SUB Screen, Macros, Dynamic Search Help and Dynamic Dropdown list Filling. I think these things will help specially for beginners those who didn’t play these things before.

Download .nugg file of that Program using link below and install this to your system using SAPLink.

SAPLink Package of Application

After installing active

1. ZFSL_FS_IN_TABLE_CONTROL Main Program
2. 9001 Screen
3. MAIN_PF_STATUS PF-STATUS
4. MAIN_TITLE TITLEBAR

Main Screen (Filter)



From Dropdown Listbox select the Value you want to filter by, which has already field as shown in below screenshots.



Select different Values from the Dropdown Listbox and Press the Filter Button it will filter the records according to the Selected value as in bellow screens.

1st



2nd


3rd


Main Screen (Search)
In the case of Filter you can only select the values from the Dropdown Listbox you can't do the search like all strings starting from A. and also want to search string starting with A or B we will see this in next steps. The Main Search Screen will look like below one.

Search Help for Both Fields will fill dynamically according to the Table Control Values, for above Table Control Values Search Help will look like below.

INT field Search Help


CHAR field Search Help



We have the following Option in the Cash of Search, Select the Search Button after every entered value.


1st


2nd


You can also use the Extension button for Multiple Values in single field like i want to show records where INT having values 1 or 2 and CHAR having value starting with A or B.

3rd
1





2




3