topic Re: Sorting the Columns in Table Maintainence in Application Development and Automation Discussions

Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 07:12:20 GMT

I have created a table maintainence for Z table.

I want to add the column sorting functionality.

By default, I cannot see the Sort button on the tool bar.

Any idea?

Pranu

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 07:21:12 GMT

Hi Pranu,

I think in SAP the tables automatically have sort property.

It will sort the data as per the first primary key then second and so on....

So if you need your data to get sorted, just make the field on which you want to sort the table as First Primary key of table.

Hope it helps.

Thanks,

Daya.

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 07:24:48 GMT

That is the standard functionality.

I have 6 columns and 1 is primary keys.

User want to sort on any column.

Same like we sort in SE16 output.

Thanks

Edited by: Pranu Pranu on May 6, 2010 9:25 AM

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 07:28:48 GMT

Hi Pranu,

Got your point.

You can sort your table contents via any field. Use Menuoptions->Settings->Format Lists->Sort

Hope it helps.

Thanks,

Daya

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 07:38:52 GMT

You can write your own code in the PBO and PAI of your screen and you can add additional buttons to default tool bar.

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 08:06:30 GMT

Input some entries in ztable selection screen and execute.

Go to Edit--~~>>Sort in ascending order~~--

>>Sort in descending order.

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 11:35:33 GMT

Hello Daya / Manas,

The option that both of you suggested are available in SE16 but not in SM30.

Thanks

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 11:36:16 GMT

Meera, I want to keep that as the last option.

Was wondering if there is anything I can use.

Pranu

Edited by: Pranu Pranu on May 6, 2010 1:36 PM

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 11:47:22 GMT

Pranu,

Yes we don't get the functionality of sorting in SM30. If you need to fulfill your requirement go as Meera suggested.

Re: Sorting the Columns in Table Maintainence

Former Member — Thu, 06 May 2010 11:50:13 GMT

Hi Pranu,

I didn't get your issue previously.

So as of now I think the option Meera gave is good and quite feasible.

Not sure if they will be helpful, but do check the EVENTS option provided under Menu options of TMG.

Best Wishes,

Daya