topic Difference between Table and Table Type in Application Development and Automation Discussions

Difference between Table and Table Type

sreeramkumar_madisetty — Thu, 20 Sep 2007 05:41:22 GMT

Can you please let me know the

Difference between Table and Table Type and

Difference between Structure and Table Type?

Regards,

Sree

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 05:44:20 GMT

Hi Sree Ram,

table is a data dictionary object in sap. table is of different types

1. database tables

2. internal tables

table type gives option for u to select different types of internal tables. they r

1. standard table

2. sorted table

3. hash table

Structures :

-Defined like a table and can then be addressed from ABAP programs.

-Structures contain data only during the runtime of a program.

-Just like user-defined data type.

Thanks,

Reward If Helpful.

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 05:45:35 GMT

Table type just contains the structure of the table and it doesnt contains any records stored in it. Whereas the table contains the records stored in it.

Please reward if helpful.

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 05:55:58 GMT

HI,

if you take it simply then

Tables are database tables having a structure ie fields and data in that.

Table types are structures with fields but no data,we can define internal tables like those table types in our program.

table types can also be created by writting codes in the program like

types : begin of structure,

........

.........

end of structure.

I hope now you are clear

reward if helpful

vivekanand

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 05:59:47 GMT

hi,

table is a data dictionary object in sap. table is of different types

1. transparent tables

2. pool tables

3. cluster tables

table type gives option for u to select different types of internal tables. they r

1. standard table

2. sorted table

3. hash table

Structures :

-Defined like a table and can then be addressed from ABAP programs.

-Structures contain data only during the runtime of a program.

-Just like user-defined data type.

- they are not present in database server and only on application server.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 06:54:46 GMT

Tables have database.So it can store data.But in case of table type, it doesnt have database,It just has structure of the table.It can used to define internal tables etc

Reward if useful.

Regards

Shibino

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 06:57:04 GMT

hi sree ram,

A table is stored in data dictionary.it contain's both a header and records(i.e the data)permanently .but a structure does not contain any record.it contains records only during program execution.

to create a structure the syntax is :

Begin of struct,

f1 type data type,

......,

end of Struct.

A table stores the data physically but a structure does not store.

A table can have primary key but a structure does not have.

a Table have the technical attribute but a structure does not have.

Re: Difference between Table and Table Type

Former Member — Thu, 20 Sep 2007 07:07:43 GMT

hi,

Table is Global element of DATA Dic. .It has its structure and also contains data into it.

Structure and Table Type is same the only diff between these is,

Structure is Global and Table Type is Local to the Prog in which it is defined.

Structure also can not store data into it like Table.

Thanks

Dharmishta