Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Types of internal tables - More explanation(urgent)

Former Member
0 Kudos

hi friends,

I wanted to explore diiferent types of internal table. when i went through the SAP.Help.Com for this , i wasnot able to get a clear idea of those 4 types of tables

Mainly i wanted to know

what is 1.standard table

2.Hashed Table

3.Sorted Table

4. Index tables..

what are the advantages of these table and please explain me a scenario for when under what circumstances we would use these?

please reply me soon as i need to submit my documents reagarding this.

Thanks in advance

Thanks&Regards

Prasanna.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Refer to this site -http://www.sap.info/en/go/26902

this explains in detail about all the internal tables and when should we use them.

4 REPLIES 4

Former Member
0 Kudos

Refer to this site -http://www.sap.info/en/go/26902

this explains in detail about all the internal tables and when should we use them.

Former Member
0 Kudos

Standard tables

This is the most appropriate type if you are going to address the individual table entries using the index. Index access is the quickest possible access. You should fill a standard table by appending lines (ABAP APPEND statement), and read, modify and delete entries by specifying the index (INDEX option with the relevant ABAP command). The access time for a standard table increases in a linear relationship with the number of table entries. If you need key access, standard tables are particularly useful if you can fill and process the table in separate steps. For example, you could fill the table by appending entries, and then sort it. If you use the binary search option with key access, the response time is logarithmically proportional to the number of table entries.

Sorted tables

This is the most appropriate type if you need a table which is sorted as you fill it. You fill sorted tables using the INSERT statement. Entries are inserted according to the sort sequence defined through the table key. Any illegal entries are recognized as soon as you try to add them to the table. The response time for key access is logarithmically proportional to the number of table entries, since the system always uses a binary search. Sorted tables are particularly useful for partially sequential processing in a LOOP if you specify the beginning of the table key in the WHERE condition.

Hashed tables

This is the most appropriate type for any table where the main operation is key access. You cannot access a hashed table using its index. The response time for key access remains constant, regardless of the number of table entries. Like database tables, hashed tables always have a unique key. Hashed tables are useful if you want to construct and use an internal table which resembles a database table or for processing large amounts of data.

0 Kudos

Check the F1 Help for internal tables. You will get a lot of info about each there.

Regards,

Rich Heilman

Former Member