Kontakt

Ansicht
Dokumentation

ECTIM_CLEANUP_REFMAP_INFTY_TAB - Clean-Up of Employee Time Data Replicated from Employee Central

ECTIM_CLEANUP_REFMAP_INFTY_TAB - Clean-Up of Employee Time Data Replicated from Employee Central

Fill RESBD Structure from EBP Component Structure   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

Use this program (transaction ECTIM_CLEANUP_DB) to repair data inconsistencies that can occur in employee time data replication from SAP SuccessFactors Employee Central to the Enterprise Resource Planning (ERP) system, for use in payroll.

What can lead to such inconsistencies?

  • Time data replication creates records of the Absences (2001) and Employee Remuneration Info (2010) infotypes in the ERP system. These records must not be changed manually. If an admin tries to change such an infotype record, the Maintain HR Master Data (PA30) transaction shows the warning that this infotype record was created by an external application (which means Employee Central here). In case the admin ignores or overlooks this warning and changes the infotype record nevertheless, this can lead to data inconsistencies.
  • Inconsistencies may also result from testing (for example, if you trigger an XML message again that was already processed).

Integration

Prerequisites

In addition to the authorization for the ECTIM_CLEANUP_DB transaction itself, the user who does the clean-up needs to have the change authorization for the PAOCFEC_REFMAP table.

Features

This program repairs inconsistencies between the following tables:

  • HR Time Record: Infotype 2001 (Absences) (PA2001) or HR Time Record: Infotype 2010 (Employee Remuneration Info) (PA2010) and Reference Key Mapping (PAOCFEC_REFMAP)
PA2001 and PA2010 store the ERP infotype data. PAOCFEC_REFMAP stores the mapping information between the Employee Time object from Employee Central and the corresponding ERP infotype record.
The program makes sure that the data is consistent in both tables. That is, it removes all entries that have no valid counterpart in the respective other table.
  • HR Time Record: Infotype 2001 (Absences) (PA2001) and Linking Index for Employee Time Groups (ECTIM_LINK_INDEX)
ECTIM_LINK_INDEX is filled when sicknesses that were linked by an admin in Employee Central Time Off because they are identical or overlapping are replicated to the ERP system. The ERP system then generates a link index and stores it in the ECTIM_LINK_INDEX table and also in the Absences (2001) infotype.
The program removes link indices from the ECTIM_LINK_INDEX table that are no longer used in an Absences infotype record.

Selection

Test Mode

You can run the program in test mode to get a preview of what it would do. In test mode, no data is deleted. This is the default mode. Clear the Test Mode checkbox to run the program productively.

Run Mode

  • Clean Up Data As Of
Specify here from which date on the tables should be cleaned up. This program then deletes replicated time data which has an end date after or on this date. After a successful clean-up, a new replication from Employee Central that uses the same date will restore the data as it was before.
  • Delete Inconsistent Entries
If you select this option, data is removed from either PA2001 or PA2010 (depending on your infotype selection) and PAOCFEC_REFMAP that doesn't have a valid counterpart in the respective other table and is after the clean-up date. Data is removed in these cases:
  • Entries are missing in one of the tables.

  • Entries exist in both tables, but have different keys.

Use this mode when you are already running employee time data replication productively.
  • Delete All Entries
If you select this option, all data is removed from both tables that is after the clean-up date.
Use this mode when you aren't running employee time data replication productively yet.

If you select the Absences option in the next section, the program also removes link indices from the ECTIM_LINK_INDEX table that are no longer used in an Absences infotype record. This is regardless of whether you select Delete Inconsistent Entries or Delete All Entries.

Infotype Selection

Choose the infotype you want to clean up:

  • Absences (2001)
In this case the program compares and cleans up the tables PA2001 and PAOCFEC_REFMAP, and it also cleans up ECTIM_LINK_INDEX.
  • Employee Remuneration Info (2010).
In this case the program compares and cleans up the tables PA2010 and PAOCFEC_REFMAP.

Additional Criteria for Deleting Inconsistent Entries

I you have selected the Delete Inconsistent Entries option, you can restrict processing to a specific set of data, using these options:

  • Personnel Number
Restrict to one or more specific employees. This restriction also applies to cleaning up the ECTIM_LINK_INDEX table.
  • Absence Type
If you've selected the Absences (2001) infotype: Restrict to one or more absence types, such as Leave or Illness.
  • Wage Type
If you've selected the Employee Remuneration Info (2010) infotype: Restrict to one or more time wage types, such as Paid Absences.

Standard Variants

Output

You'll be shown a list that consists of four parts:

  • The first set of rows shows the options you have selected on the selection screen. These rows have the status Information.
Note
If you have made entries in the Additional Criteria for Deleting Inconsistent Entries section, you'll see information like this:
Personnel number restriction entered on selection screen: I EQ 00050000 00060000
Or:
Personnel number restriction entered on selection screen: E EQ 00050000 00000000
"I" means "include" here, "E" means "exclude". That is, these messages read:
"Personnel number restriction entered on selection screen: Include personnel numbers from 00050000 through 00060000"
"Personnel number restriction entered on selection screen: Exclude personnel number 00050000"
  • The next set of rows shows entries that exist in table PAOCFEC_REFMAP, but not in table PA2001 or PA2010 respectively (depending on your selection). These are the rows that will be or have been removed. They have the status Deletion.
  • The third set of rows show entries that exist in table PA2001 or PA2010 respectively (depending or your selection), but not in table PAOCFEC_REFMAP. These are the rows that will be or have been removed. They have the status Deletion.
  • The last set of rows show entries that exist in table ECTIM_LINK_INDEX, but are no longer used in an Absences infotype record. These are the rows that will be or have been removed. They have the status Deletion.

To search within the result, choose Find. To store the result as a local file for further analysis, choose Export.

Activities

Example






BAL_S_LOG - Application Log: Log header data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 9122 Date: 20240531 Time: 062503     sap01-206 ( 157 ms )