Skip to Content
author's profile photo Former Member
Former Member

What are Cluster Tables?

What are Cluster Tables?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 07: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08:32 AM

    Cluster tables: A single table in the database (cluster) have a one to many relationship in the dictionary.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08: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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08: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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08: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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 08: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

    cluster-pool-and-transparent-tables

    pool-and-cluster-tables

    cluster-table

    Regards,

    Padmam.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2007 at 12: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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.