topic Re: Internal table in Application Development and Automation Discussions

Internal table

Former Member — Mon, 11 Dec 2006 04:24:57 GMT

hi,

tell me effective way of using an internal table

sarath

Re: Internal table

Former Member — Mon, 11 Dec 2006 04:27:35 GMT

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

Re: Internal table

Former Member — Mon, 11 Dec 2006 04:30:48 GMT

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.

Re: Internal table

Former Member — Mon, 11 Dec 2006 04:33:45 GMT

refer..

Re: Internal table

Former Member — Mon, 11 Dec 2006 04:37:57 GMT

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

Re: Internal table

Former Member — Mon, 11 Dec 2006 04:59:20 GMT

thanx for ur rewards.

Re: Internal table

Former Member — Mon, 11 Dec 2006 05:20:01 GMT

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