Symptom
Person and Employment Export table report is showing incorrect data for Base Pay Component.
Environment
- SAP SuccessFactors HCM Suite
- Table report
- Pay Component Recurring
Reproducing the Issue
- Go to employee profile > compensation information;
- Base Pay Component for Recurring Pay Component seems correct;
- Create a Person and Employment Export table report;
- Add Pay Component and Base Pay Component;
- Base Pay Component data is not the same as shown in the employee's profile.
Cause
The Base Pay Component shown in the employee's profile is actually the Base Pay Component Group configured for the selected Pay Component in Manage Organization, Pay and Job Structures. This field is not reportable in the table reports of domain Person and Employment Export. The Base Pay Component shown in the report is the actual Base Pay component.
Resolution
Base Pay Component Group is a Foundation Object and can be reported in a Foundation Object table report. You can learn more about it in the KBA 2796879 - How To Run An Adhoc Report for Pay Component Group Name or Pay Component Group ID.
If the Base Pay Component shown in the report is not correct, you can doublecheck the Base Pay Component to a certain Pay component in the Data Inspector.
STEP 1 - Find the Pay Component
- Go to Data Inspector;
- Entity: Table_FO_PAY_COMPONENT_T;
- Filter Criteria
- Code
- Equals
- Insert the pay component external code
- Show Data;
- Copy code in column "Base Pay Component Internal Code";
This is the code for the base pay component assigned to this pay component.
STEP 2 - Find the Base Pay Component
- Go to Data Inspector;
- Entity: Table_FO_PAY_COMPONENT_T;
- Filter Criteria
- Internal code Base Pay Component Internal Code from the previous step;
- Equals
- Paste the
- Show Data;
STEP 3 - Correct the Base Pay Component
- Go to Import Foundation Data;
- Download a blank CSV template;
- Pay Component;
- Prepare the file;
- Select Pay component;
- Type: Full Purge;
- Choose File;
- Validate;
- Import;
The steps are also described in the KBA 2080139 - How To Import Foundation Objects or Foundation Data - Employee Central
See Also
Keywords
wrong data report, Person and Employment Export, table report, base pay component, pay component group, compensation report , KBA , LOD-SF-EC-CMP-REC , Recurring Payments , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-CMP , Compensation Information & One-Time Bonus , Problem