Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Diff btwn STANDARD and SORTED tbls??

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

Tags:
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question