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: 

table and structure

Former Member
0 Kudos

what is the diff between table ,transparent table and structre?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Table can store the data and structure is just a defination. It can't contain any data.

Regards,

Atish

4 REPLIES 4

Former Member
0 Kudos

Hi,

Table can store the data and structure is just a defination. It can't contain any data.

Regards,

Atish

Former Member
0 Kudos

Table is a general terminology it can be transperant table cluster table or other So table is nothing but place where we will store data.

Transparent table one of type of table in which one to one link is prsent

Ex. MARA is table for material master in which for single material only one entry is present.

Structre is nothing but table but without data. So all declaration and other part is same but we are not able to store the data in structure So it is table without data only for refernce purpose.

Rewards if useful............

Minal

0 Kudos

Hii Kalai,

Major diff is.,.,.

STRUCTURES : it does not contain any value.

It has no memory space.

TABLES: It hold data.

All tables are containted memory....

Structure can hold only one record that too at runtime. Whereas table is different. It can hold different no. of records based on the memory associated to it.

To know the difference, you go to SE11 transaction. There you can type any table name say VARI, which is a table that stores the details of different varients in programs and press F7(display) .

In the initial screen of the screen u can see the 'contents' tab button on the application tool bar (CNTLSHIFTF10).

press the contents tab button and u can see the select-options for different fields and then press F8.

u can see the details of the varients stored in different programs.

But in the initial screen of SE11, type a structure name say RSVAR, which is a structure that stores varient details and press F7.

But u cannot see any 'contents' tab button in the application tool bar. i.e., it donot store any records. it is only a structure which is used in different programs and fm's as a work area. T

he record details stored in structure during runtime are erased from it immediately after the program is executed.

/people/rich.heilman2/blog/2005/07/27/dynamic-internal-tables-and-structures--abap

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=table%20and%20structure&cat=sdn_all

types of Table.,.,

Transparent Table : Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

Pooled Table : Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

The major difference between transparent tables, pooled tables and clusterd Tables are:

A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement.

Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data.

A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.

One of the possible reasons is for instance that their content can be variable in length and build up. Database manipulations in Abap are limited as well.

But pool and cluster table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

Regards

Debasish

Former Member
0 Kudos

Hi kalai ANNA ,

these r the differences b/w a structure and a table :

1) A structure doesn't have a primary key where as a table has.

2)A structure contains no data whereas a table holds data.

3)No attributes like Technical Settings, data class , size buffer, delivery class, table maintainance where as a table has all these attributes.

4)We can include structures within a table where as we can't include a table within a table.

5)A structure is a sequence of any other data types from the ABAP Dictionary, that is, data elements, structures, table types, or database tables. When you create a structure in the ABAP Dictionary, each component must have a name and a data type.In an ABAP program, you can use the TYPEaddition to refer directly to a structure

TABLES dbtab.

The following syntax mkes the database table , view or structure dbtab known to the program.

****Pls reward points if u find this useful

cheers!

gyanaraj