Cluster tables in HR

Database Tables in HR

• Personnel Administration (PA) - master and time data infotype tables (transparent tables). PAnnnn: e.g. PA0001 for infotype 0001
• Personnel Development (PD) - Org Unit, Job, Position, etc. (transparent tables). HRPnnnn: e.g. HRP1000 for infotype 1000
• Time/Travel expense/Payroll/Applicant Tracking data/HR work areas/Documents (cluster PCLn: e.g. PCL2 for time/payroll results.

Cluster Table

<!-[endif]->

• 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;
PCL2 - Accounting Results (time, travel expense and payroll);
PCL3 - Applicant tracking data;
PCL4 - Documents, Payroll year-end Tax data

Database Tables PCLn

• PCLn database tables are divided into subareas known as data clusters.
• Data Clusters are identified by a two-character code. e.g RU for US payroll result, B2 for time evaluation result...
  • Each HR subarea has its own cluster.
  • Each subarea has its own key.
    <!-[endif]->

Database Table PCL1

The database table PCL1 contains the following data areas:
<!-[endif]->

• B1 time events/PDC
• G1 group incentive wages
• L1 individual incentive wages
• PC personal calendar
• TE travel expenses/payroll results
• TS travel expenses/master data
• TX infotype texts
• ZI PDC interface -> cost account<!-[endif]->

Database Table PCL2

The database table PCL2 contains the following data areas:

• B2 time accounting results
• CD cluster directory of the CD manager
• PS generated schemas
• PT texts for generated schemas
• RX payroll accounting results/international
• Rn payroll accounting results/country-specific ( n = HR country indicator )
• ZL personal work schedule

Database Table PCL3

The database table PCL3 contains the following data areas:

• AP action log / time schedule
• TY texts for applicant data infotypes

Data Management of PCLn

The ABAP commands IMPORT and EXPORT are used for management of read/write to database tables PCLn.
A unique key has to be used when reading data from or writing data to the PCLn.

Cluster Definition

• The data definition of a work area for PCLn is specified in separate programs which comply with fixed naming conventions.
• They are defined as INCLUDE programs (RPCnxxy0). The following naming convention applies:
  • n = 1 or 2 (PCL1 or PCL2)
  • xx = Relation ID (e.g. RX)
  • y = 0 for international clusters or country indicator (T500L) for different country cluster
    <!-[endif]->

Exporting Data (I)

• The EXPORT command causes one or more 'xy' KEY data objects to be written to cluster xy.
• The cluster definition is integrated with the INCLUDE statement.