12-13-2007 9:44 AM
Hi there ,
What is the differrence between table & transparent table.....?
Thanks & Regrads
Kaushik
12-13-2007 9:52 AM
The term 'table' is very generic..
It can be either a <b>internal table</b> or a <b>transparent table</b>
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
12-13-2007 9:49 AM
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
12-13-2007 9:52 AM
The term 'table' is very generic..
It can be either a <b>internal table</b> or a <b>transparent table</b>
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
12-13-2007 10:06 AM
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
12-13-2007 10:12 AM
<b>transparent table is just another name of the database table in which the data in maintained</b>... this is true...
transparent table has one to one relation with database table...
12-13-2007 9:59 AM
<b>A transparent table is automatically created on the database when it is activated in the ABAP Dictionary.</b>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.
12-13-2007 10:05 AM
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.
12-13-2007 10:05 AM
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
12-13-2007 10:16 AM
My querry is cleared ........ thanks a lot for all your answers....
Regards
Kaushik