Application Development 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: 

diff b/w tables and structures

Former Member
0 Kudos

hi im vara

reply 4 dis bye experts

9 REPLIES 9

Former Member
0 Kudos

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 .....

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

0 Kudos

yhank u vijay can u give me any suggestions how to prepare the subject as well as for interview.i am in a dilloma to prepare .

bye

vara

0 Kudos

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

Former Member
0 Kudos

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)

former_member202957
Contributor
0 Kudos

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.

Former Member
0 Kudos

<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.