‎2007 Jun 12 5:36 AM
Hi Guys,
need a bit of help. I have writen a dialog programming where i get data from a table zinput and when the user clicks on a save button the data will be saved in another table zoutput.
everything is working fine and the data is also being saved but when the data is saved in zoutput the data is getting sorted automatically. I have not used anyu short statement in the program. And in the program the data goes unsorted into the table. I think the data is sorted somewhere in the table.
Is there any option the table where the data gets sorted?????? Please help me out . Its urgent.
Points will be awarded generously.
‎2007 Jun 12 5:39 AM
Hi,
The data will not be sorted when you insert records to the table zoutput...
If you are seeing the data in SE16...I believe it shows the data in sorted manner..
SE16t sorts the records by the primary key..
Thanks,
Naren
‎2007 Jun 12 5:40 AM
Hi,
in table what ever data we enter
thedata will be stored in ascending order
depending on the key fields
so no need of sorting the data when you transfer the data..
it is given by sap...
reward points if helpful
regards,
venkatesh
‎2007 Jun 12 5:41 AM
If the table has any primary key it gets sorted based on the primary key
make sure your Zoutput table has a primary key, if it has a primary key it gets sorted based on the primary key only and not based on any other filed... if u wnt to sort based on another field u need to do it manually..
Regards
Gopi
‎2007 Jun 12 5:42 AM
hi
in the dictionary tables the content gets sorted automaticaly in ascending order....
‎2007 Jun 12 5:42 AM
Actually there is no setting so that the table sorts.
when u insert the record in the database table it automatically inserts at right positon in the database table.
when u view the entires in se11 or se16 . the data is sorted and displayed
‎2007 Jun 12 5:46 AM
hi,
in construction of your table u may have used primary keys. and when u see that data in se16 it is shown in ascending order for the given data as because of primary keys. therefore goto SE11 and check data whether it is in sorted order or not.
if helpful reward some points.
with regards,
suresh.
‎2007 Jun 13 5:15 AM
Hi Suresh,
the table entries in SE11 are also sorted.please help me out
‎2007 Jun 13 5:37 AM
hai
Accoding to my knwladge when ur save the data in the output screen data wil go to the table. normaly that data sort automaticaly in ther primary key... ur problem also same ... when ur save the data it should be save but sort by ur primary key. so if u want to change it u hav to chane ur primary key as a time or any othe intiger number...
or u hav to another method when u save the data u if u can gv the intiger value for each record u any finaly u can sort by that intiger
ex:-
index feil1 fel2
1 xx yy
2 xx2 yy2
3 xx3 yy3
i think it wil be help ful
regard
nawa