Where The Payroll Data Is Stored

Once the payroll is run, where does the data get stored and how can we retrieve the same at a later date?

by: Srikanth

Below is the info:

Payroll Clusters:

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)

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.

HR Related:

Get help for your SAP HR problems
SAP HR Forum - Do you have a SAP HR Question?

SAP Human Resouce Books
SAP HR Books  - Certification, Interview Questions and Configuration

SAP Human Resource Tips
SAP HR Tips and Human Resource Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com

All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.sap-img.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.