cluster table

[Former Member]

Hi, GUYS

can anyone give me some reference about the cluster table? i have known that they are quite different from the transparent table in the database. but what's the storage architecture of them in the database, and how can we retrieve the data entry from them? for example ,the PAYROLL data in HR.

thanks in advance.

qiuguo

[Former Member]

Hi,

Cluster tables combine the data from several tables with identical (or almost identical) keys into one physical record on the database.

Data is written to a database in compressed form.

Retrieval of data is very fast if the primary key is known.

Cluster tables are defined in the data dictionary as transparent tables.

External programs can NOT interpret the data in a cluster table.

Special language elements EXPORT TO DATABASE, IMPORT TO DATABASE and DELETE FROM DATABASE are used to process data in the cluster tables.

For more info chk this link:

http://fuller.mit.edu/hr/cluster_tables.html

regards,

keerthi

[Former Member]

Hi,

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.

reward if useful

regards,

ANJI

[Former Member]

Hi,

Cluster table

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.

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,

Priyanka.

[Former Member]

Hi,GUYS

thanks for your information.

qiuguo

[Former Member]

Hi,

Please see into the attatched link..

this will help u understand the clusters...

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/5d/06c29df49911d1a12f080009d6dc5a/frameset.htm">http://help.sap.com/saphelp_47x200/helpdata/en/5d/06c29df49911d1a12f080009d6dc5a/frameset.htm</a>

<b>Reward Points if helpful,</b>

Regards,

Tejas

[Former Member]

Read the payroll cluster by using function module PYXX_GET_RELID_FROM_PERNR, after getting the relid and molga ,and import the molga to the function module <b>cu_read_rgdir</b>, in cu_read_rgdir just check the payroll period

and read the payroll result by using the function module PYXX_READ_PAYROLL_RESULT.