topic Re: Sorting While maintaining data through SM30 in Application Development and Automation Discussions

Sorting While maintaining data through SM30

Former Member — Tue, 13 Sep 2011 12:47:24 GMT

Hi Techies,

I have developed a z-table with key fields a,b & c. Now when I am entering data through SM30, C(Char field) field is getting sorted after saving.

My requirement is to store the data in table without any sorting. Actually this field C has some sequencing issue. So, Is there any event for table which can be used to resolve this issue.

Note: I have already tried Event 01 by creating a new include and giving my ID breakpoint. But its noty trigerring .

Any advice would be deeeply appreciated.

Thanks & Regards,

Vinit

Re: Sorting While maintaining data through SM30

former_member246859 — Tue, 13 Sep 2011 13:44:02 GMT

If fields A, B and C are character fields. When you save data to field C. It is save as a key filed. Key fields will always be shown in the sorted sequence.

Re: Sorting While maintaining data through SM30

Former Member — Tue, 13 Sep 2011 13:49:18 GMT

1. did you check the table with SE16? Are records really sorted? i sense this is just sorted for output issues in SM30 and does not reflect what is really on your DB table.

2. Why should it matter if records in a DB table are sorted or not? Cant really think of a scenario where this makes any difference. At least not this way, maybe the other way round, if you expect your entries in the DB table to be sorted. E.G. when doing an array fetch into a itab which is declared as a sorted table.

3. having your entries sorted, if thats really the case, can only help you, in terms of faster searches etc.. Sorting will not change your data in any way.

Re: Sorting While maintaining data through SM30

Former Member — Fri, 16 Sep 2011 07:27:45 GMT

Hi Naimish,

The requirement is to restrict the sorting of field.

Note: Yes, field 'C' is a Character Field.

Regards,

Vinit

Re: Sorting While maintaining data through SM30

Former Member — Fri, 16 Sep 2011 07:32:29 GMT

Hi Florian,

Actually The field 'C' mentioned above contains the name of chemical compounds. I am fetching this data from databse and displaying in printout. In printout the user wants the field 'C' should get displayed accoridng to Chemical Sequence.

Currently the data in Legacy system is stored in that manner. I just wanted to know if v can restrict the sorting of field C, Than i dont have to write extra logic for displaying data in printout.

Hope you understand the exact issue.

Any suggestions would be appreciated.

Note: yes i checked in SE16, SE16N & SE11, but same issue.

Regards,

Vinit

Edited by: vinit005 on Sep 16, 2011 9:33 AM

Re: Sorting While maintaining data through SM30

Former Member — Fri, 16 Sep 2011 07:39:59 GMT

Hi,

If you want to restrict the sorting , then field 'C' should not be declared as a key field.

Regards,

Srini.

Re: Sorting While maintaining data through SM30

Former Member — Fri, 16 Sep 2011 07:51:55 GMT

But it has to be included in key field, else data wont be fed properly...

Is anyone aware of any Table Event that can be used to achieve the reuirement.

Thanks in Advance,

Vinit

Edited by: vinit005 on Sep 21, 2011 1:16 PM