04-26-2007 9:30 AM
04-26-2007 9:32 AM
hi Sai,
<b>Cluster table</b>
Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.
Can check this link for more clarity
http://help.sap.com/saphelp_47x200/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm
Regards,
Santosh
Message was edited by:
Santosh Kumar Patha
04-26-2007 9:32 AM
Cluster tables: A single table in the database (cluster) have a one to many relationship in the dictionary.
04-26-2007 9:33 AM
hi,
<u>Cluster table</u>
Cluster tables contain continuous text, for example, documentation.
Several cluster tables can be combined to form a table cluster.
Several logical lines of different tables are combined to form a physical record in this table type.
This permits object-by-object storage or object-by-object access.
In order to combine tables in clusters, at least parts of the keys must agree.
Several cluster tables are stored in one corresponding table on the database.
Rgds
Anver
04-26-2007 9:34 AM
sai,
CLUSTER Tables :-
Table clusters (clusters) are special table types in the ABAP Dictionary
The data from several tables is stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.
Table pool or table cluster should be used exclusively for storing internal control information (screen sequences, program parameters, temporary data, continuous texts such as documentation). Data of commercial relevance is usually stored in transparent tables.
Can check this link for more clarity
http://help.sap.com/saphelp_47x200/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm
Don't forget to reward if useful...
04-26-2007 9:36 AM
Hi sai,
1. Cluster table means that,
In abap dictionary there are many tables (cluster tables),
2. But They all are linked to only one database table (actual physical table in database).
3. Eg. BSEG is in abap dictionary.
BSEG won't be there in actual database, instead,
they corresponding table name is RFBLG
which has the corresponding fields
MANDT CLNT 3
BUKRS CHAR 4
BELNR CHAR 10
GJAHR NUMC 4
PAGENO INT2 5
TIMESTMP CHAR 46
PAGELG INT2 5
VARDATA RAW 3800
All the data of BSEG fields, is stored in
VARDATA in encoded format. The primary keys are also saved.
regards,
amit m.
04-26-2007 9:37 AM
Hi Sai,
Cluster Table also appears like Transparent table but consists of huge data, so consumes more time to fetch the records from it.
You can't join it with other tables to fetch the data.(BSEG in FI, KONV table for pricing are clusters)
in HR all PCL1, PCL2, 3 are clusters of similar type.
Creating a cluster table.
http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21f0b7446011d189700000e8322d00/frameset.htm
Following is the step by step procedure.
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0b7446011d189700000e8322d00/content.htm
To access cluster table:
http://fuller.mit.edu/hr/cluster_tables.html
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm
Regards,
Padmam.
04-26-2007 1:22 PM
hi,
Tables r of three types.
1. Transparent table.
2. Pool table
3.Cluster table.
1.In cluster table it uploads system data.
2.It is many to 1 relationship.
3.It is a small collection of large tables.
4.It consists of n number of records.
where as in pool table it is a collection of large number of small tables.
if useful dont forget to reward with points.
with regards,
madhuri.
04-26-2007 8:03 PM
Hi,
A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.
Regards,
Bhaskar