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.
Field Name |
KEY |
Length |
Text |
MANDT |
X |
3 |
Client |
RELID |
X |
2 |
Relation ID (RU,B2..) |
SRTFD |
X |
40 |
Work Area Key |
SRTF2 |
X |
4 |
Sort key for dup. key <!-[if !supportLineBreakNewLine]> <![endif]-> |
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.