Why we use Cluster Tables in SAP Hr

[Former Member]

hai friends, i am new to ABAP-HR and SAP HR, Actually i am core abaper ( working on SD, MM and Fi Modules ) , can any one explain me why and what is the use of Cluster tables in SAP HR, why we use in SAP HR function Module ?

Thnx in advance

Vijaya

[sikindar_a · Accepted solution]

Good Question

When compared to Other Moduels HR/HCM has lot of Structures and the data will stores under different Structures

lot of work oa an ABAP HR is to Fetch the data with the use of Standrad FMs as certain FM has been Provided by the SAP and this will help an ABAP HR to do the Work easily

Cluster Tables stores the data of evaluated Results of various results and it contains commuted results

[Former Member]

Hi Vijaya,

This may help for ur question..

Why cluster table:

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.

PCL1 - Database for HR work area; (long text, etc)

PCL2 - Accounting Results (time, travel expense and payroll); (payroll results)

PCL3 - Applicant tracking data;

PCL4 - Documents, Payroll year-end Tax data (change logs, etc)

[Former Member]

Cluster tables combine the data from several tables with identical (or almost identical) keys into one physical record on the database. The data is written to a database in compressed form. The 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.