‎2008 Jun 19 10:26 AM
hai friends,
what is cluster table? how to create it?what is the difference between cluster table & transparent table ?plz do reply
‎2008 Jun 19 10:29 AM
‎2008 Jun 19 10:30 AM
‎2008 Jun 19 10:35 AM
Creating Table Pools/Table Clusters
Procedure
1. In the initial screen of the ABAP Dictionary, choose Utilities u2192 Further
Dictionary Objects.
A dialog box appears.
2. Select the object type Table pool/cluster and enter the object name. Choose .
A dialog box appears in which you must specify if it is a table pool or a table cluster.
Select the required object type and choose .
3. The maintenance screen for table pools/clusters appears.
The necessary entries will have been made automatically for the fields for table pools
since a table pool has a fixed structure. You should not change these standard settings if
you can avoid it.
The structure of a table cluster is also mostly fixed. Certain fields are therefore proposed
when the table cluster is created. You can adjust this proposal to your requirements, for
example by inserting further key fields. However, make sure you conform to the structure
necessary for a table cluster.
4. Enter an explanatory text in the field Short text.
If necessary, select the activation type [Page 80] of the table pool/cluster with Utilities u2192
Activation type.
5. Create documentation about the table pool/cluster with Goto u2192 Documentation.
This documentation should describe what the table pool/cluster is used for. The
documentation is also output when the table pool/cluster is printed.
6. Go to the maintenance screen for the technical settings by choosing Goto u2192 Technical
settings.
In contrast to the table maintenance screen, you can only define the size category [Page
32] here. All other attributes of the technical settings are preset.
7. Activate the table pool/cluster with .
‎2008 Jun 19 11:48 AM
‎2008 Jun 19 11:52 AM
Hi Vivek,
Cluster Table
Table clusters (clusters) are special table types in the ABAP Dictionary.
The data from several different tables can be stored together in a table cluster.
Tables assigned to a table cluster are referred to as cluster tables.
Please check this link
Creating Pooled Tables/Cluster Tables
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0b7446011d189700000e8322d00/content.htm
Pooled and Cluster Tables
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm
Difference between Transparent and cluster tables
A transparent table in data dictionary has a one-to-one relationship with a table in the database
A cluster table has a many u2013to u2013one relationship with a table in the database.
Best regards,
raam
‎2008 Jun 19 11:57 AM
hiii
click on following link.you will get answer
for what is cluster table.
http://www.saptechies.com/the-different-types-of-sap-tables-2/
for difference
http://www.allinterview.com/showanswers/20285.html
reward if useful
thx
twinkal