Knowledge Management

Question:
What r the Different type of internal type and its different use .
if possible send with example .
thanks in advance
Answer:
Your message is somewhat confusing in that you ask what the different types are, but your subject line mentiones internal tables.
Do you want to know what data types are available, or what internal table index types are available ?
Dr Sidewalk
Answer:
internal table index type
Answer:
we are havin indexed internal tables and hash internal tables.
inside indexed internal table we have sorted internal table and standard internal table.
bye.
Answer:
STANDARD TABLE = no index apart from when sorted and can then use BINARY SEARCH in READ TABLE statement to speed up. In LOOP WHERE, a full table scan is always done.
HASHED TABLE = Uses an internal hash key based on the Unique Key for the itab. Unless this table is going to always be read using the whole of the key then it will do a full table scan for reads and loops. If readin an itab using a full key then READ TABLE..... WITH TABLE KEY instead of just WITH KEY -- Much quicker.
SORTED TABLE = good middle ground if you will sometimes be doing a full key READ but also doing partial key READs and LOOP WHEREs because the partial key index will be used. This is the only type of itab where an index will be used in a LOOP WHERE - As long as you specify the fields in the WHERE in the correct key order.
Basically - HASHED if only ever READing on FULL key. STANDARD if going to be looping all records or reading on many different keys. SORTED for everything else.
Answer:
Is your finger broken or are you just lazy? Look in the help files!