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

diff b/w tables and structures

hi im vara

reply 4 dis bye experts

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 07:27 AM

    In general, Data / information should be stored for future use.

    Tables :

    1. The place where the data is stored so that you can retrieve at any time.

    2. There can be more than one record stored

    Structures :

    1. The data / info stays only during the runtime of the application and will not get stored at all during the run time ....

    2. Only one record can be stored at the runtime .....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 07:37 AM

    Hi,

    DDIC tables have an underlying database table connection.

    if a transparent table the same fields and order exist in database also.

    structures do not have a database connection it is only definition of data type

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 07:56 AM

    Hi

    Structure is a blueprint or skeleton it won't hold values it is aline type of table.Defining a single structure we can create multiple number of tables.These can't be created but defined since these don't have any memory pointers.

    Table is an abject it points to memory it holds values u can Define a structure with the linetype of the table.Tables are physical existing entities.

    structure forms the skeleton of the table.

    A structure comprises components i.e., fields. Types are defined for the components A component can refer to an elementary type (via a data element or by directly specifying the data type and length in the structure definition), another structure or a table type. A structure can therefore be nested to any depth

    Tables can be defined independently of the database in the ABAP Dictionary. The fields of the table are defined with their (database-independent) data types and lengths.

    When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP Dictionary. The table definition is translated from the ABAP Dictionary to a definition of the particular database.

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi Vara Prasad,

    <b>Table :</b>

    Tables is a collection of fields, and it's hold the values permanently, it's contains Primary key and Foriegn key relationship, and also technical attributes(Delivery class, Size catageory, Data class, Buffering Techniques).

    There are three types of tables are avilable :

    <b>1, Transprant table,

    2, Pooled table,

    3, Cluster table.</b>

    <b>Structure :</b>

    Structure decribes group of fields, and it's contain values only on runtime,It doen't contain Primary key and Foriegn key relationship, and also doesn't contain technical attributes(Delivery class, Size catageory, Data class, Buffering Techniques).

    Regards,

    Vijay

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vara,

      if u want learn basically study ABAP in 21 days book(Sam series),this is very important thing, after that u can study in BDC , SCRIPTS,SMARTFORMS,ENHANCEMENTS, if u know OOPS , then study ABAP OOPS , beacuse now a days ABAP OOPS very important thing.

      Regards,

      Vijay

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 09:25 AM

    Hi Vara,

    Tables are client dependent as they store the data ....(mandt) field

    Structures are client independent they dont store data as mentioned above in replies that they dont have the connection to the underlying database.

    For a report type .

    Example:

    when u declare types : -


    this forms the structure that can be utilised by the keyword 'data'. to form a table.

    Structures are resusable..

    And in Se11.

    Database table ..--->

    Data type:----> Structure a kind of data type (reusable anywhere)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2007 at 11:39 AM

    Hai vara prasad,

    Hi,

    <b>Structure</b> meant for <b>GLOBAL EXISTANCE</b>(these could be used by any other program without creating it again).

    Structures are used especially to define the data at the interface of module pools and screens and to define the types of function module parameters.

    Structures that are used more than once can be changed centrally because they were defined centrall. The active ABAP Dictionary makes this change at all relevant locations. ABAP programs or screen templates that use a

    structure are automatically adjusted when the structure changes.

    <b>tables:</b> There is a physical table on the database for each transparent table.

    The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond.

    All business data and application data are stored in transparent tables.

    <b>Reward for useful answers</b>

    Regards,

    sunil kairam.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:59 AM

    <b>The basic difference between table and structure is that table can hold the data and structure can not hold data in it.</b>

    Table Type:

    is a structure which is defined with a 'OCCURS 0' extension with the definition of the structure and can hold data.

    Structure:

    is a definition with the field details and which can not hold any data in it.

    in the case given by you:

    1) Data: lt_filetable TYPE filetable, (Table type)

    The 'filetable' is a table declaration with 'OCCURS 0' parameter.

    2) ls_file TYPE file_table. (Structure).

    the 'file_table' is a structure definition.

    Rewards if useful.

    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.