HR Cluster Tables

[praveen_hannu]

Hi

I need the HR cluster table names. Can you please provide?

Regards

Praveen

[Former Member]

hi,

Refer to the link.

http://fuller.mit.edu/hr/cluster_tables.html

regards

Sumit Agarwal

[Former Member]

Hi,

PCL1

PCL2.

Check this SDN link-it may help you

Regards,

Sujit

[Former Member]

Hi Praveen,

use the T-CODE : PECLUSTER , it will give you description of each HR CLUSTER.

With luck,

Pritam.

[Former Member]

hi praveen,

go through this

Cluster Table
u2022 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.
u2022 Retrieval of data is very fast if the primary key is known.
u2022 Cluster tables are defined in the data dictionary as transparent tables.
u2022 External programs can NOT interpret the data in a cluster table.
u2022 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
u2022 PCLn database tables are divided into subareas known as data clusters.
u2022 Data Clusters are identified by a two-character code. e.g RU for US payroll result, B2 for 
  time evaluation result...
u2022 Each HR subarea has its own cluster.
u2022 Each subarea has its own key.

Database Table PCL1
u2022 The database table PCL1 contains the following data areas:
  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

Database Table PCL2
u2022 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
u2022 The database table PCL3 contains the following data areas:
  AP action log / time schedule
  TY texts for applicant data infotypes

Data Management of PCLn
u2022 The ABAP commands IMPORT and EXPORT are used for management of read/write to 
  database tables PCLn.
u2022 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

Cluster Definition
u2022 The data definition of a work area for PCLn is specified in separate programs which comply   
   with fixed naming conventions.
u2022 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

Exporting Data (I)
u2022 The EXPORT command causes one or more 'xy' KEY data objects to be written to cluster xy.
u2022 The cluster definition is integrated with the INCLUDE statement.

REPORT ZHREXPRT.
TABLES: PCLn.
INCLUDE: RPCnxxy0. "Cluster definition
* Fill cluster KEY
xy-key-field = <value>.
* Fill data object
....
* Export record
EXPORT TABLE1 TO DATABASE PCLn(xy) ID xy-KEY.
   IF SY-SUBRC EQ 0. 
       WRITE: / 'Update successful'.
   ENDIF.


Exporting Data (II)
. Export data using macro RP-EXP-Cn-xy.
u2022 When data records are exported using macro, they are not written to the database but to a   
  main memory buffer.
u2022 To save data, use the PREPARE_UPDATE routine with the USING parameter 'V'.

REPORT ZHREXPRT.
*Buffer definition
INCLUDE RPPPXD00. INCLUDE RPPPXM00. "Buffer management
DATA: BEGIN OF COMMON PART 'BUFFER'.
INCLUDE RPPPXD10.
DATA: END OF COMMON PART 'BUFFER'.
... 
RP-EXP-Cn-xy.
IF SY-SUBRC EQ 0.
    PERFORM PREPARE_UPDATE USING 'V'..
ENDIF.


Importing Data (I)
u2022 The IMPORT command causes data objects with the specified key values to be read from 
   PCLn.
u2022 If the import is successful, SY-SUBRC is 0; if not, it is 4.

REPORT RPIMPORT.
TABLES: PCLn. 
INCLUDE RPCnxxy0. "Cluster definition

* Fill cluster Key

* Import record
IMPORT TABLE1 FROM DATABASE PCLn(xy) ID xy-KEY.
   IF SY-SUBRC EQ 0.
      * Display data object 
   ENDIF.

Importing data (II)
u2022 Import data using macro RP-IMP-Cn-xy.
u2022 Check return code SY-SUBRC. If 0, it is successful. If 4, error.
u2022 Need include buffer management routines RPPPXM00

REPORT RPIMPORT.
*Buffer definition
INCLUDE RPPPXD00.
DATA: BEGIN OF COMMON PART 'BUFFER'.
INCLUDE RPPPXD10.
DATA: END OF COMMON PART 'BUFFER'.
*import data to buffer
RP-IMP-Cn-xy.
.... 
*Buffer management routines
INCLUDE RPPPXM00.

Cluster Authorization
u2022 Simple EXPORT/IMPORT statement does not check for cluster authorization.
u2022 Use EXPORT/IMPORT via buffer, the buffer management routines check for cluster
  authorization.

Payroll Results (I)
u2022 Payroll results are stored in cluster Rn of PCL2 as field string and internal tables. 
  n - country identifier.
u2022 Standard reports read the results from cluster Rn. Report RPCLSTRn lists all payroll results; 
  report RPCEDTn0 lists the results on a payroll form.

Payroll Results (II)
u2022 The cluster definition of payroll results is stored in two INLCUDE reports: 
  include: rpc2rx09. "Definition Cluster Ru (I)
  include: rpc2ruu0. "Definition Cluster Ru (II)

The first INCLUDE defines the country-independent part; The second INCLUDE defines the country-specific part (US).

u2022 The cluster key is stored in the field string RX-KEY.

Payroll Results (III)
u2022 All the field string and internal tables stored in PCL2 are defined in the ABAP/4 dictionary. This 
  allows you to use the same structures in different definitions and nonetheless maintain data
  consistency.
u2022 The structures for cluster definition comply with the name convention PCnnn. Unfortunately,  
   'nnn' can be any set of alphanumeric characters.

*Key definition
DATA: BEGIN OF RX-KEY.
     INCLUDE STRUCTURE PC200.
DATA: END OF RX-KEY.

*Payroll directory
DATA: BEGIN OF RGDIR OCCURS 100. 
     INCLUDE STRUCTURE PC261. 
DATA: END OF RGDIR.


Payroll Cluster Directory
u2022 To read payroll results, you need two keys: pernr and seqno
. You can get SEQNO by importing the cluster directory (CD) first.

REPORT ZHRIMPRT.
TABLES: PERNR, PCL1, PCL2.
INLCUDE: rpc2cd09. "definition cluster CD
PARAMETERS: PERSON LIKE PERNR-PERNR.
...
RP-INIT-BUFFER.
*Import cluster Directory
   CD-KEY-PERNR = PERNR-PERNR.
RP-IMP-C2-CU.
   CHECK SY-SUBRC = 0.
LOOP AT RGDIR.
   RX-KEY-PERNR = PERSON.
   UNPACK RGDIR-SEQNR TO RX-KEY-SEQNO.
   *Import data from PCL2
   RP-IMP-C2-RU.
   INLCUDE: RPPPXM00. "PCL1/PCL2 BUFFER HANDLING

Function Module (I)
  CD_EVALUATION_PERIODS
u2022 After importing the payroll directory, which record to read is up to the programmer.
u2022 Each payroll result has a status. 
  'P' - previous result
  'A' - current (actual) result 
  'O' - old result

u2022 Function module CD_EVALUATION_PERIODS will restore the payroll result status for a period
   when that payroll is initially run. It also will select all the relevant periods to be evaluated.

Function Module (II)
CD_EVALUATION_PERIODS

call function 'CD_EVALUATION_PERIODS' 
     exporting
          bonus_date = ref_periods-bondt 
          inper_modif = pn-permo 
          inper = ref_periods-inper 
          pay_type = ref_periods-payty 
          pay_ident = ref_periods-payid 
     tables 
          rgdir = rgdir 
          evpdir = evp 
          iabkrs = pnpabkrs 
     exceptions 
          no_record_found = 1. 

Authorization Check
   Authorization for Persons
u2022  In the authorization check for persons, the system determines whether the user has the  
   authorizations required for the organizational features of the employees selected with
   GET PERNR.
u2022  Employees for which the user has no authorization are skipped and appear in a list at the end
   of the report.
u2022  Authorization object: 'HR: Master data'

Authorization for Data
u2022 In the authorization check for data, the system determines whether the user is authorized to
  read the infotypes specified in the report.
u2022 If the authorization for a particular infotype is missing, the evaluation is terminated and an error
  message is displayed.

Deactivating the Authorization Check
u2022 In certain reports, it may be useful to deactivate the authorization check in order to improve
  performance. (e.g. when running payroll)
u2022 You can store this information in the object 'HR: Reporting'.

[Former Member]

Hi Praveen,

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)

For accessing cluster tables check this link:

http://sap.ittoolbox.com/groups/technical-functional/sap-hr/accessing-cluster-tables-1058273#

Hope this helps you.

Regards,

Chandra Sekhar

[Former Member]

Hi Praveen,

Goto the table DD02L and enter the field Tabclass as TRANSP to get all transaparent tables,

CLUSTER to get all cluster tables and POOL to get the pooled tables.

Some of the cluster tables present with the system are

BSEC

BSED

BSEG

BSES

BSET

BSSEG

Check the below link.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

If Found Help Full Do Reward.

Regards.

Eshwar.