Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

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..)
<!-[if !supportLineBreakNewLine]->
<!-[endif]->

SRTFD

X

40

Work Area Key
<!-[if !supportLineBreakNewLine]->
<!-[endif]->

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.
  • No labels