topic Problme in Insert in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742763#M1301879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am Sorting an Internal Table and after that I am inserting that data into database.</P><P></P><P>But, when I look at Database table, the data is not in Sorted Order....</P><P></P><P>Can you please let me know, why like thi?</P><P></P><P>Ex: Sort itab by f1 f2.</P><P> Insert DB from Table Itab.</P><P></P><P></P><P>Thanks,</P><P>Sandip</P></BODY></HTML> Mon, 15 Jun 2009 07:48:59 GMT Former Member 2009-06-15T07:48:59Z Problme in Insert https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742763#M1301879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am Sorting an Internal Table and after that I am inserting that data into database.</P><P></P><P>But, when I look at Database table, the data is not in Sorted Order....</P><P></P><P>Can you please let me know, why like thi?</P><P></P><P>Ex: Sort itab by f1 f2.</P><P> Insert DB from Table Itab.</P><P></P><P></P><P>Thanks,</P><P>Sandip</P></BODY></HTML> Mon, 15 Jun 2009 07:48:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742763#M1301879 Former Member 2009-06-15T07:48:59Z Re: Problme in Insert https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742764#M1301880 <HTML><HEAD></HEAD><BODY><P>why do you need to sort it? is it for easier viewing only? if yes, then you can sort it via SE16N... with the pyramid like icon...</P></BODY></HTML> Mon, 15 Jun 2009 07:50:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742764#M1301880 Former Member 2009-06-15T07:50:23Z Re: Problme in Insert https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742765#M1301881 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please check if you have specified all the key fields during sorting...</P></BODY></HTML> Mon, 15 Jun 2009 07:51:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742765#M1301881 Former Member 2009-06-15T07:51:33Z Re: Problme in Insert https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742766#M1301882 <HTML><HEAD></HEAD><BODY><P>Database table is always having a sorted copy on the basis of primary index. </P><P>Hence, we need not to worry for the same .</P></BODY></HTML> Mon, 15 Jun 2009 08:22:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742766#M1301882 Former Member 2009-06-15T08:22:01Z Re: Problme in Insert https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742767#M1301883 <HTML><HEAD></HEAD><BODY><P>check ur primary key sorting values in the internal table.</P></BODY></HTML> Mon, 15 Jun 2009 09:06:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problme-in-insert/m-p/5742767#M1301883 Former Member 2009-06-15T09:06:07Z