Get Before Payroll

This workflow obtains payroll data from the specified SAP system before a payroll run is performed. The workflow is configured to specify a Payroll Area, Pay Date and Payroll Run date. Using these details, it calls the Collect Payroll Data workflow, which retrieves the appropriate payroll data and stores it in an External Data Source named Payroll_Data_Before.

Run the payroll workflows

The Payroll workflows in the Human Resources templates package should be run as follows:

  1. Drag each of the Payroll workflows from the Templates folder into your own workspace.

  2. Run the Get Before Payroll workflow for a given payroll area, pay date and payroll run date.

  3. Apply changes on the payroll system and perform a second payroll run.

  4. Run the Get After Payroll workflow for the same payroll area and pay date, using the second payroll run date.

  5. Run the Compare Payroll Runs workflow to compare the payroll runs.

Create RFC Destinations

Before you begin, you will need to create an RFC Destination for your payroll system. The SAP account associated with the RFC Destination requires sufficient authorizations to read the HRPY_RGDIR, in addition to the default authorizations provided with LiveCompare. This may be set in the S_TABU_NAM authorization, using the ACTVT 03 (read), and TABLE HRPY_RGDIR.

Prepare the workflow

To prepare the Get Before Payroll workflow, modify the workflow as follows:

To specify a Payroll Area:

  1. Select the Enter Payroll Area (ABKRS) parameter and view its details in the Property Editor.

  2. Enter a new value for the parameter’s String property.

To specify a Pay Date:

  1. Select the Enter Pay Date (PAYDT) in YYYYMMDD format parameter and view its details in the Property Editor.

  2. Enter a new value for the parameter’s String property. The Pay Date should be specified in the format YYYYMMDD.

To specify a Payroll Run Date:

  1. Select the Enter Payroll Run Date (RUNDT) in YYYYMMDD format parameter and view its details in the Property Editor.

  2. Enter a new value for the parameter’s String property. The Payroll Run Date should be specified in the format YYYYMMDD.

Click Save tool button. to save the workflow.

Run the workflow

To run the Get Before Payroll workflow, click the Run tool button. toolbar button, choose Run Now from the diagram’s context menu, or select F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, the Row count dataset contains the number of rows written to the Payroll_Data_Before External Data Source.