Monday, November 22, 2010

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)

image

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

image image

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

image

2nd
image

3rd
image

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

CHAR field Search Help
image


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


1st
image

2nd
image

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
image

image


2
image
image


3
image

2 comments:

mansoorahmed86 said...

I can't see any image on this blog post. Please look into this.

eternal-learner said...

no images and no links working- what a pitty!

Post a Comment