topic Re: Sorting Option in Table Control in Application Development and Automation Discussions

Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 06:21:54 GMT

Hi Guru's,

I have a requirement that to add Sorting option in my Table Control Wizard .I added code but in my table control I am unable to select any column .This is in editable mode also.I am facing this problem and i go through the websites .I didn't get solution.

Regards

Shek

Re: Sorting Option in Table Control

laurent_fournier2 — Wed, 27 Jun 2012 06:43:17 GMT

Hi,

In the table control properties there are checkboxes about column and line select-ability. Please check that the correct checkboxes are selected and reply.

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 06:50:46 GMT

Are you referring to below settings? I can see the options to hide (mark invisible) fields. But there is no option to sort them.

I doubt it can be done in table control.

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:01:34 GMT

Hi,

I didn't get you.Will you plz explain me in detail

Regards

Shek

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:03:51 GMT

Hi ,

I got it .Can you plz tell me filter option ,search option also.

Regards

Shek

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:10:50 GMT

Hi Laurent,

I was working now.Can you plz tell me filter and search option also.

Regards

Shek

Re: Sorting Option in Table Control

RaymondGiuseppi — Wed, 27 Jun 2012 07:11:20 GMT

There is no built-in sort option in table control, you have to code the SORT yourself by reacting to selectio of column headers and your own defined function code (eg. adding two icons on the dynpro for sort ascending/descending).

PBO :

In the defined Table control (CONTROLS, structure CXTAB_CONTROL) there is a subfield COL_SEL_MODE to enable column selection (0-no selection (default) 1-one column 2-any number of columns)

PAI :

Loop at columns (subfield COLS internal table, records structure CXTAB_COLUMN subfield SELECTED) to find which columns where selected and execute a dynamic SORT

Regards,

Raymond

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:13:51 GMT

Hi Raymond ,

I added code for sorting .It is working .Now I need filtering and search option.

Regards

Shek

Re: Sorting Option in Table Control

Aashish28 — Wed, 27 Jun 2012 07:19:14 GMT

Hiiii,

For selecting column :

you have to set this column property and for your sorting give 2 sort up and sort down button and write logic for function code in PAI -

READ TABLE I<table_contol_name>-cols INTO cols WITH KEY selected = 'X'.
     IF sy-subrc = 0.
       SORT <Internal_table>_name STABLE BY (cols-SCREEN-name+17) ASCENDING. " OR DESCENDING
       cols-selected = ' '.
       MODIFY <table_contol_name>-cols FROM cols INDEX sy-tabix.
     ENDIF.

Here i've used 17 for offset because my internal table name is 16character long + one character for '-'.

Re: Sorting Option in Table Control

RaymondGiuseppi — Wed, 27 Jun 2012 07:23:03 GMT

(You could consider using ALV grid, where those functions are built-in)

The filtering is a little harder.

Layout :

For filter input, add a new icon with function code (e.g.ICON_FILTER)

PAI :

You could use a FM like FREE_SELECTIONS_DIALOG to generate a "selection-screen" dialog, then FREE_SELECTIONS_RANGE_2_WHERE to convert into ranges

PBO :

You should consider filtering record between two internal tables - the total one and the filtered one using the generated ranges. (and in PAI you will have to map the update from the filtered/displayed itab to the full itab)

The search tool is comparatively easy, try to solve it yourself

Regards,

Raymond

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:26:23 GMT

Hi ,

I is working fine . Now I want searchng & filtering option

Regards

Shek

Re: Sorting Option in Table Control

laurent_fournier2 — Wed, 27 Jun 2012 07:28:31 GMT

As with sorting functionality, filtering and search requires you to program the functions manually.

Add the pushbuttons and create coding for eash function depending what you want to do.

But, since you want all this functionality, why you are not using alv instead of table control ?

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 07:42:06 GMT

Hi ,

I suggested my user for ALV but they don't want to use it .That is the problem

Regards

Shek

Re: Sorting Option in Table Control

Aashish28 — Wed, 27 Jun 2012 07:50:29 GMT

Hiiii ,

For Search option on your main screen give a search button ... on click event call modal dialog box screen - and you can make a modal dialog box screen give suitable field which you want to use as a search option and on modal dialog box screen made 2 buttons ok and cancel

on ok button write logic ,

READ TABLE <internal table> INTO <workarea> WITH KEY <as you given in modal screen>.

IF sy-subrc = 0 .

SET SCREEN 0.

<table control name>-current_line = " Write your own logic
<table control name>-top_line =. "Write your own logic

ELSE.

MESSAGE 'No record found ' TYPE 'S'.

ENDIF.

Same as for filer also use delete on internal table as per your filter criteria and show it on <table_control> . " For filter you have to use some screen concept also

Try to apply your own logic also .............i have given hints .....

Re: Sorting Option in Table Control

laurent_fournier2 — Wed, 27 Jun 2012 07:56:41 GMT

OK, so in this case , you must code all the appropriate functions.

Regards.

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 08:53:06 GMT

Hi Ashish,

Here what logic I have to write

<table control name>-current_line = " Write your own logic

<table control name>-top_line =. "Write your own logic

Regards

Shek

Re: Sorting Option in Table Control

Aashish28 — Wed, 27 Jun 2012 11:08:39 GMT

Hiiii ,

In my Case for putting my search result on top I had used serial no. in my internal table so when my read table performs and if i got successful search result than i also got one serial number which i had used for putting result to top of row in table control.

<table control name>-current_line = wa-srno . " Write your own logic

<table control name>-top_line =. wa-srno . "Write your own logic

As per you requirement you can use your one and filtering is tricky and little harder so just apply screen logic for that read my previous comments .

Re: Sorting Option in Table Control

Former Member — Wed, 27 Jun 2012 11:15:12 GMT

Hi Ashish,

Searching option was solved . Only filter option is remaining.If you have any logic plz provide.

Regards

Shek

Re: Sorting Option in Table Control

Aashish28 — Wed, 27 Jun 2012 11:47:45 GMT

Hiii shek ,

I have one new idea just try it ...... all the fields which you have in your internal table same field put on your one new modal dialog screen ok and same as search button give two more button filter and delete filter - put both buttons on main screen (but delete filter button should not be activate until filter is set ) on click event of filter button check whether the column is selected or not if yes - than get column name as i mentioned above by offset than in PBO do loop on screen and rest of all screen field make hide and show only selected field than on POV use F4IF_INT_TABLE_VALUE_REQUEST FM for getting F4 help by internal table values , once you select value from F4 List and press ok button delete all record from internal table which not come into filter criteria and show results on screen . before deleting make sure your original internal table should be copied into same new internal table because when you press delete filter button than on than buttons click event you can get the original records back

my solution was different ....Try this one .... and let me know if you found any problem ,

Regards ,

Ashish