Skip to Content
author's profile photo Former Member
Former Member

Difference between transparent table & Internal table

Hi,

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

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Nov 17, 2007 at 05:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 04:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 17, 2007 at 05:06 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2007 at 08:42 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 11:10 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.