topic Re: Differrence between table & transparent table in Application Development and Automation Discussions

Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 09:44:40 GMT

Hi there ,

What is the differrence between table & transparent table.....?

Thanks & Regrads

Kaushik

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 09:49:31 GMT

Hi Kaushik,

The table type determines how the logical table description defined in

the ABAP/4 Dictionary is reproduced on the database.

Transparent table is one such type where we get the application and business data..

Regards,

Kaveri

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 09:52:25 GMT

The term 'table' is very generic..

It can be either a internal table or a transparent table

Internal table is local to a program and can be seen with data during runtime.

the data in it is cleared as soon as the execution of program is over.

Transparent tables are database tables in which is present at all times..

we need 2 use SQL stmts. to fetch and modify data in it..eg.SELECT us used to fetch data from it unlike the internal tables..

Hope dis helps..

Reward all helpful answers

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 09:59:44 GMT

A transparent table is automatically created on the database when it is activated in the ABAP Dictionary.At this time the database-independent description of the table in the ABAP Dictionary is translated into the language of the database system used.

The database table has the same name as the table in the ABAP Dictionary. The fields also have the same name in both the database and the ABAP Dictionary. The data types in the ABAP Dictionary are converted to the corresponding data types of the database system.

The order of the fields in the ABAP Dictionary can differ from the order of the fields on the database.

This permits you to insert new fields without having to convert the table. When a new field is added, the adjustment is made by changing the database catalog (ALTER TABLE). The new field is added to the database table, whatever the position of the new field in the ABAP Dictionary.

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 10:05:22 GMT

Hi kaushik,

1. Normally table means a normal database table,

and it is the same as transparent table.

2. Other kind of tables, for database purpose, can be

cluster table, pooled table etc.

regards,

amit m.

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 10:05:47 GMT

hi,

transparent table one of type of table

In Abap dictionaty we can create

Transparent Tables

Pooled and Clustered Tables

These type of tables.

The difference between pooled and clustered tables is

Cluster tables and Pooled tables have many to one relationship with the underlying database.

A table pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored.

Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.

• A pooled table cannot have the name having more than 10 characters.

• All the key fields of the pooled table must be of character data type.

• In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively.

• In cluster table the records having the same key are stored in a single key in the cluster.

• If there is an overflow of the data records a continuation record is created with the same table key.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm

regards,

pavan

Re: Differrence between table & transparent table

kaushik_choudhury2 — Thu, 13 Dec 2007 10:06:49 GMT

Hi Prashant,

I am clear about the differrence between the internal table & database table........ can I assume that then transparent table is just another name of the database table in which the data in maintained .....

Thanks & Regards

Kaushik

Re: Differrence between table & transparent table

Former Member — Thu, 13 Dec 2007 10:12:22 GMT

transparent table is just another name of the database table in which the data in maintained... this is true...

transparent table has one to one relation with database table...

Re: Differrence between table & transparent table

kaushik_choudhury2 — Thu, 13 Dec 2007 10:16:15 GMT

My querry is cleared ........ thanks a lot for all your answers....

Regards

Kaushik