Internal table

[Former Member]

hi,

tell me effective way of using an internal table

sarath

[Former Member]

Sarath,

It is specific to your scenario.

Normally you can use a STANDARD internal table type.

If you have got some records and you have a loop / read statement in your internal table, it might be a good idea to use a SORTED table.

If you have got huge amount of records, then go for the HASED internal table.

It might be a good idea to use field symobls to process the internal tables, rather than the work area.

Regards,

Ravi

[Former Member]

hi...

hope u want to know wat an internal table is.. coz ur question is not very clear..

anyways i've put down few points in it_tab.

Internal table is an array which can store multiple records. These are data objects that allow u to retain several data records with the same structure in memory.

<b>The internal table can expand dynamically</b>.ie the no of data record is enormous.

Try and use the it_tab the max for data retrieval or for loading in any data,simply bcoz it_tab are very effective and fast for huge data retrieval,there by reducing the processing time.

syntax: <it_tab name> type table of <table name>.

if any more clarifications on it_tab ,do post in ur question.

all the best.

[Former Member]

refer..

[Former Member]

hi sarath,

Internal table is a temperorary table where we can store all the entries of the database in our program..the main advantage is that we can easily fetch data aslo its quick because we just interact with the database very less...

the declaration of an internal table is..

data : it_1 type mara.

it_1 internal table name

mara structure name.

the things u have to take into concern for effective processing

• Gather all the relevant data from database at a single strech so that we can have minimal data retrival time.

• It comes handy when we use joins because we can merge all our required data

into one table so that multiple table usage can be averted.

• looping of internal table must be used with care cause looping statements deprives performance.

• Use field symbols instead of work area or internal table with header line.

• Ingeneral u can use standard internal table when u have a bulk data then u can go for sorted internal table.

these are some ways by which u can use the internal table in an effective manner..

regards ,

Rajkumar.g

Message was edited by:

RAJKUMAR GAUTHAMAN

[Former Member]

thanx for ur rewards.

[Former Member]

Purpose of chain-endchain and when it is used with real time scenario?