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: 

WHAT IS THE EXACT DIFF B/N TABLE AND STRCTURE?

Former Member
0 Kudos

HI

EXPERTS

CAN U HELP ME PZZZZZZZZZZZZZZ

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

Table is used to store data with multiple records and exists in Database.

Structure basically doesn't store data , stores a record at run time, acting as a Work area

see the doc about different types of Tables

The following are the table types used in SAP :

I. Transparent tables (BKPF, VBAK, VBAP, KNA1, COEP)

Allows secondary indexes (SE11->Display Table->Indexes)

Can be buffered (SE11->Display Table->technical settings) Heavily updated tables should not be buffered.

II. Pool Tables (match codes, look up tables)

Should be accessed via primary key or

Should be buffered (SE11->Display Table->technical settings)

No secondary indexes

Select * is Ok because all columns retrieved anyway

III. Cluster Tables (BSEG,BSEC)

Should be accessed via primary key - very fast retrieval otherwise very slow

No secondary indexes

Select * is Ok because all columns retrieved anyway. Performing an operation on multiple rows is more efficient than single row operations. Therefore you still want to select into an internal table. If many rows are being selected into the internal table, you might still like to retrieve specific columns to cut down on the memory required.

Statistical SQL functions (SUM, AVG, MIN, MAX, etc) not supported

Can not be buffered

IV. Buffered Tables (includes both Transparent & Pool Tables)

While buffering database tables in program memory (SELECT into internal table) is generally a good idea for performance, it is not always necessary. Some tables are already buffered in memory. These are mostly configuration tables. If a table is already buffered, then a select statement against it is very fast. To determine if a table is buffered, choose the 'technical settings' soft button from the data dictionary display of a table (SE12). Pool tables should all be buffered.

Reward points if useful

Regards

Ashu

7 REPLIES 7

Former Member
0 Kudos

Hi

Table is used to store data with multiple records and exists in Database.

Structure basically doesn't store data , stores a record at run time, acting as a Work area

see the doc about different types of Tables

The following are the table types used in SAP :

I. Transparent tables (BKPF, VBAK, VBAP, KNA1, COEP)

Allows secondary indexes (SE11->Display Table->Indexes)

Can be buffered (SE11->Display Table->technical settings) Heavily updated tables should not be buffered.

II. Pool Tables (match codes, look up tables)

Should be accessed via primary key or

Should be buffered (SE11->Display Table->technical settings)

No secondary indexes

Select * is Ok because all columns retrieved anyway

III. Cluster Tables (BSEG,BSEC)

Should be accessed via primary key - very fast retrieval otherwise very slow

No secondary indexes

Select * is Ok because all columns retrieved anyway. Performing an operation on multiple rows is more efficient than single row operations. Therefore you still want to select into an internal table. If many rows are being selected into the internal table, you might still like to retrieve specific columns to cut down on the memory required.

Statistical SQL functions (SUM, AVG, MIN, MAX, etc) not supported

Can not be buffered

IV. Buffered Tables (includes both Transparent & Pool Tables)

While buffering database tables in program memory (SELECT into internal table) is generally a good idea for performance, it is not always necessary. Some tables are already buffered in memory. These are mostly configuration tables. If a table is already buffered, then a select statement against it is very fast. To determine if a table is buffered, choose the 'technical settings' soft button from the data dictionary display of a table (SE12). Pool tables should all be buffered.

Reward points if useful

Regards

Ashu

Former Member
0 Kudos

1.structure only store data at run time but table store data permanently.

2.Structure can be append in tables.

3.Structure can be declared in programme not table,only internal table can be declared in program.

Former Member
0 Kudos

Hi Ravi,

Main difference between table and structure is that a Table can always hold data but a structure can hold data only at runtime..

Reward if useful....

Regards,

prem.

Former Member
0 Kudos

<b>Tables</b>: Data records can be stored in table at database level..

Multiple records can be stored in a table.

For table mapping is 1:1 between Data Dictionary and Database i.e one record in Data Dic mapped to one record to database.

<b>Structures</b> are defined in data dictionary but can not stored data at database level.

Structure can store data at runtime only.

Only single record can be stored in a structure at a time.

Reward if Useful

former_member198270
Active Contributor
0 Kudos

HI Ravi ,

tables is the place where the actual data is stored where as a structure is called at run time through which either we update values to a table or retrieve data from a table thru a structure.

Pl reward if it helps.

Regards,

Amber S

Former Member
0 Kudos

Hi,

The differences between a structure and a table are as follows:

A structure doesn't have an associated database table.

A structure doesn't have a primary key.

A structure doesn't have technical attributes.

hope this helps.

Reward if helpful.

Regards,

Sipra

Former Member
0 Kudos

hi,

table: stores data. tables occupies memory and

resides in underlying data bases.

are of same structure in database server and in application server.

are of two types

1. database tables

- transparent tables

- pool tables

- cluster tables

2. user defined tables

- internal tables with out header line.

- internal tables with header line.

structures: defines the shape of any object.

strutures wont occupy any memory.

they present only in application server.

are of two types

1. global structures [ created in SE11]

2. local structures [ created using TYPES keyword]

if helpful reward some points.

with regards,

Suresh.A