topic Re: cluster table in Application Development and Automation Discussions

cluster table

Former Member — Fri, 30 Mar 2007 05:34:58 GMT

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

Re: cluster table

Former Member — Fri, 30 Mar 2007 05:37:58 GMT

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

Re: cluster table

Former Member — Fri, 30 Mar 2007 05:39:40 GMT

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

Re: cluster table

Former Member — Fri, 30 Mar 2007 05:39:49 GMT

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.

Re: cluster table

Former Member — Fri, 30 Mar 2007 05:54:46 GMT

Hi,GUYS

thanks for your information.

qiuguo

Re: cluster table

Former Member — Fri, 30 Mar 2007 06:22:57 GMT

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

Re: cluster table

Former Member — Fri, 30 Mar 2007 06:34:05 GMT

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.