Diff btwn STANDARD and SORTED tbls??

[Former Member]

Hi Experts,

Just curious to know that, In Wht scenarios/requiremets, we need to create a internal table, like fillowing(or How they differ from TYPE STANDARD TABLE OF)??

<i><b>it_a504 TYPE SORTED TABLE OF a504 WITH UNIQUE KEY kunnr prodh.

wa_a504 TYPE a504,</b></i>.

thanq

Message was edited by:

Srikhar

[Former Member · Accepted solution]

mainly performance reason ,if you use sorted internal table then it will have good performance than standard intentable

The internal tables could be catogrised into two.

indexed : standard and sorted tables.

nonindexed: hash tables.

standard table: it is the one we use generally.In this the data is not sorted and the only thing we can do is just process the data with out any restriction on it.

sorted tables: it works in two different manner.

Frist one: is similar to standard table but the only difference is the data will be filled in a particular manner either ascending or descending.

Second one: u can also fill the table keeping any field as primary key.now the data will be filled based on that particular key.

Hash tables: u can use this when u want to fill your internal table avoiding the duplication of data.it never permits the duplicate record to be stored in a internal table

Thanks

seshu

[ferry_lianto]

Hi,

Using TYPE SORTED TABLE, system will sort automatically based on specify key fields whereas TYPE STANDARD TABLE OF, you can sort to any orders with SORT statement.

However, you can not sort a sorted table using the SORT statement.

Regards,

Ferry Lianto