topic Difference between transparent table & Internal table in Application Development and Automation Discussions

Difference between transparent table & Internal table

Former Member — Sat, 17 Nov 2007 16:58:26 GMT

Hi,

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

Thanks

Re: Difference between transparent table & Internal table

naimesh_patel — Sat, 17 Nov 2007 17:06:23 GMT

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

Re: Difference between transparent table & Internal table

former_member195698 — Sat, 17 Nov 2007 17:06:55 GMT

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.

Re: Difference between transparent table & Internal table

Former Member — Sun, 18 Nov 2007 08:42:20 GMT

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

Re: Difference between transparent table & Internal table

Former Member — Mon, 19 Nov 2007 04:50:38 GMT

Hi Sneha ,

Transparent tables :

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.

Internal tables :

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 RAM on the Application Server, It's contains two part one is Header Line(Work area) and Body, It's create in SE38, There are three types of internal tables available,

1.Sorted (Binary Search)

2.Standard (Linear Search)

3.Hashed (Hashing Algorithm's).

Regards,

Vijay

Re: Difference between transparent table & Internal table

Former Member — Thu, 22 Nov 2007 11:10:43 GMT

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