topic Re: table and structure in Application Development and Automation Discussions

table and structure

Former Member — Fri, 18 Jan 2008 06:22:37 GMT

I know that , table is a collection of rows and colums and structure is a description of group of fields......I want to know the difference between table and structure?????

Re: table and structure

Former Member — Fri, 18 Jan 2008 06:24:41 GMT

Hi,

Tables stored data,

While structure has data only at runtime of the program.

regards,

Santosh Thorat

Re: table and structure

Former Member — Fri, 18 Jan 2008 06:24:47 GMT

Hi,

Structure: Holds only one record. (generally called as work area).

Internal table: Hold more than 1 record.

Re: table and structure

Former Member — Fri, 18 Jan 2008 06:27:52 GMT

Hi Sinivas,

Table:

1.It can store the record.

2.It has associated with database table.

3.It has a primary key.

4.It has a techincal attributes(size,data class,buffering)

Structure:

1.It can not store the record.

2.It has not associated with database table.

3.It doesnt contain a primary key.

4.It doesnt contain a techincal attributes(size,data class,buffering)

Reward points if helpful.

Kiran Kumar.G.A

Have a Nice Day..

Re: table and structure

Former Member — Fri, 18 Jan 2008 06:29:05 GMT

Look at structure description from SAP.

=======================================================

A structure (structured type) consists of components (fields) whose types are defined.

A component can have an elementary type, a structured type, a table type or a reference type.

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.

=======================================================

Compared to database tables, structures doesn't have any key fields. Structures represent one single line and when you define the structure in your program as

data: begin of itab occurs 0.

include structure ztest.

data: end of itab.

it creates a internal table itab with the records of ztest structure .. structure cannot hold data like database table..

hope this gives you some idea

Re: table and structure

Former Member — Fri, 18 Jan 2008 06:53:51 GMT

Stucture doesnt hold the data. the values for the structures are fetched during the runtime.

Whereas in case of table it holds the data. And you can see the data of the tables by using the transaction code : se11, se12, se16, se16n.

For instance when u create cubes dimension tables are created where u can see the values of the dimension tables.

whereas when u create multi provider instead of dimension tables, dimension structures are being created.

Regards.

Re: table and structure

Former Member — Fri, 18 Jan 2008 07:29:47 GMT

Hi,

A table has an underlying database table associated with it. A structure does not.