Application Development and Automation 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: 
Read only

internal tables

Former Member
0 Likes
494

Difference between internal table and a dictionary table?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
473

hi,

internal table is aruntime entity created for storing data.

internal tables are resided on presentation server memory itself.

internal tables are of different types like

1. internal tables with header line.

2. internal tables with out header lines...

dictionary tables are global and can be used by anyone.

dictionary tables resides on databse server.

we can data from dictionary tables using native-sql and also open sql statements also.

dictionary tables are of different types as

1. cluster tables

2. pool tables..

3. transparent tables.

if useful reward some points.

with regards,

suresh.

5 REPLIES 5
Read only

Former Member
0 Likes
473

hi

internal tabel having tempary storage .this are created at program level.. this are not global use.. (means we can not use in another program like referance)

ddic table is having memory perminent storage. this are global use...

<b>reward points if helpful,

Regards

Raghunath.S</b>

Read only

Former Member
0 Likes
474

hi,

internal table is aruntime entity created for storing data.

internal tables are resided on presentation server memory itself.

internal tables are of different types like

1. internal tables with header line.

2. internal tables with out header lines...

dictionary tables are global and can be used by anyone.

dictionary tables resides on databse server.

we can data from dictionary tables using native-sql and also open sql statements also.

dictionary tables are of different types as

1. cluster tables

2. pool tables..

3. transparent tables.

if useful reward some points.

with regards,

suresh.

Read only

Former Member
0 Likes
473

in internal table u can have the data for the given condition and it can be diff thru out the program ...

u can modify as per the requirement.

dictionary Table is the reusable data...it will be used in many programs...

Read only

Former Member
0 Likes
473

data base table are stored in the d/d serever.itabs are stored in tempmomory locations for the processing purpose.

database tables are stored in db server

and the internal tables are virtual tables these r created run time only

internal tables are created dynamically,the memory of internal tables is not

permant memory ,for internal tables the memory will be created in the application server and it is external memory and terminates after the program termination.

iternal table is a temparory table for using data calculation after program end it destroed.we can find the internal table using occurs clause.

Internal table:when ever we declared in Program and executed in the RUN TIME only control cna allocate internal table ,when ever the Program closed the memory of internal table will be released by control. it means table will be created at RUNTIME only.these are not declared at Underlaying database.Database Tables:tables which are declared in Under laying database level,and it's memory is permanent.

reward points if it is usefull ...

Girish

Read only

Former Member
0 Likes
473

Hi

To all gurus helping me out. As iam new to this field.

Thanks&Regards

Suri