‎2009 Feb 17 9:47 AM
Hi All,
I have created a table where i want to maintain temperatures in required order. I want to retain the order
of the data in which it is been created but by default the values are getting sorted in ascending order.
Is there any provision to avoid the sorting by default.
Thanks in Advance,
‎2009 Feb 17 9:51 AM
‎2009 Feb 17 9:51 AM
‎2009 Feb 17 9:54 AM
Hi Max,
Its a transparant table where i want to maintain the data. data is automatically saved in sorted order in Data Dictionary. Please help.
‎2009 Feb 17 10:13 AM
hi,
if all the fields of the table are numeric data types (i.e, i,p,f) then the table won't be sorted
regards
sarves
‎2009 Feb 17 10:23 AM
Hi
So you're speaking about transaction like SE16 and or SM30, if it's so the data are sorted by key fields and u can do nothing there, but u can use a different criteria for sorting in your custom transactions.
If you need to avoid the sorting in std trx u should use a counter (managed by a custom range number) as unique key field.
In this way u can sure the value of counter respects the order in which the records are inserted.
Max
‎2009 Feb 17 9:52 AM
Hi Premraj
Try using CHAR instead of NUMC for defining temperature variables
Hope it helps
Regards
Vikas C
‎2009 Feb 17 10:54 AM
Hi,
Remove the field from the key and see the difference.
Regards
Bikas