Difference between transparent table & Internal table

[Former Member]

Hi,

I want to know the Difference between transparent table & Internal table.

Thanks

[naimesh_patel]

Transpernt table is table which is being crated in the database. This table will store atcual data .. Example MARA, VBAK..

Internal tables are only crated at program level. Internal table will stores data for only that perticular program. After program finishes it will destroyed by system.

You can use the internal table to process the transpernet tables data.

Regards,

Naimesh Patel

[former_member195698]

Transparent table is database table. The data will remain permanently in the system.

Internal tables are tables used within a program to store data. The data will remain as long as the program is running.

[Former Member]

Thanks for the prompt reply.It sure did solve my doubt.

[Former Member]

Hi Sneha ,

<b>Transparent tables :</b>

Transparent tables are permanent table, and its hold the permanent data, it's the one of the data dictionary object, so it does create on SE11, it's one to one relationship with Data base tables,it's contains primary and foriegn key relationship, and also contains technical attributes and data element and Domain.

<b>Internal tables :</b>

Internal tables are temprevary and virtual table , It hold's the data on only during runtime , after that it will discarded , it create and filled the data only on run time, it's located on <b>RAM</b> on the Application Server, It's contains two part one is <b>Header Line(Work area</b>) and <b>Body</b>, It's create in SE38, There are three types of internal tables available,

<b>1.Sorted (Binary Search)

2.Standard (Linear Search)

3.Hashed (Hashing Algorithm's).</b>

Regards,

Vijay

[Former Member]

Thanks for all the replies..my doubts r clear now...