COMP - How to Import and Export Compensation Data?
The following article will help explain how you can import or export compensation data through SFCodeBot.
Navigate to CodeBot for SAP SuccessFactors, and enter your login details.
On the Home screen, click on the Compensation module.
Select your workspace from the next screen.
Navigate to a generated workbook in my case iteration # 265. Click the sheet icon.
The workbook will appear in a new tab on your browser. Select the Import Export Tables worksheet.
The first block (Column A – D) lists down currency conversion names while the second block (Column E – I) provides details for each currency conversion. The third block (Column J – N) lists down compensation and variable pay lookup names while the fourth block (Column O – Z) provides the details for each lookup name. The fifth block (Column AA – AC) lists down stock values while, the sixth block (Column AD – AG) provides details for each stock value. The seventh block (Column AH – AJ) lists down stock factors while, the eighth block (Column AK – AO) provides details for each stock factor. The ninth block (Column AP – AS) lists down salary pay matrixes while, the tenth block (Column AT – BC) provides details for each salary pay matrix. The eleventh block (Column BD – BG) provides promotion map data for each salary pay matrix. The twelfth block (Column BH – BJ) provides details for job code and pay grade. Select the data according to your requirements. Select the type and name of the table you wish to execute and set the processing status to pending in the last block (Column BK – BM).
To help demonstrate this, we have selected three types of tables - a currency conversion, a lookup, and a job code & pay grade mapping table. We are executing testTable1, Max_Range_Lookup, and Job Code & Pay Grade Mapping for our example.
Screenshot 1:
Screenshot 2:
Screenshot 3:
Screenshot 4:
Screenshot 5:
Screenshot 6:
Screenshot 7:
Close the workbook and navigate back to SFCodeBot. Click the hamburger icon under the Actions tab for the same iteration number. Select ‘Start Configuration’ option from the dropdown menu.
The Start Configuration popup will appear. Enter your credentials and some execution notes. Lastly, select the Plan Details checkbox, and hit Confirm and Start button.
Later on, you can click the information icon to monitor the progress of your iteration. Screenshots will be visible once changes are successfully pushed to the instance.
Once the status shows complete, go back in the workbook, and observe that a template has been added successfully as the row and its corresponding fields is now highlighted green. Meanwhile, the processing status has also turned to processed.
You can also confirm these changes by switching to 'Compensation Home' on SAP Success Factors and clicking on Import/Export Data under the 'Data for all Plans' heading.
Navigate to CodeBot for SAP SuccessFactors, and enter your login details.
On the Home screen, click on the Compensation module.
Select your workspace from the next screen.
Navigate to a generated workbook in my case iteration # 265. Click the sheet icon.
The workbook will appear in a new tab on your browser. Select the Import Export Tables worksheet.
The first block (Column A – D) lists down currency conversion names while the second block (Column E – I) provides details for each currency conversion. The third block (Column J – N) lists down compensation and variable pay lookup names while the fourth block (Column O – Z) provides the details for each lookup name. The fifth block (Column AA – AC) lists down stock values while, the sixth block (Column AD – AG) provides details for each stock value. The seventh block (Column AH – AJ) lists down stock factors while, the eighth block (Column AK – AO) provides details for each stock factor. The ninth block (Column AP – AS) lists down salary pay matrixes while, the tenth block (Column AT – BC) provides details for each salary pay matrix. The eleventh block (Column BD – BG) provides promotion map data for each salary pay matrix. The twelfth block (Column BH – BJ) provides details for job code and pay grade. Select the data according to your requirements. Select the type and name of the table you wish to execute and set the processing status to pending in the last block (Column BK – BM).
To help demonstrate this, we have selected three types of tables - a currency conversion, a lookup, and a job code & pay grade mapping table. We are executing testTable1, Max_Range_Lookup, and Job Code & Pay Grade Mapping for our example.
Screenshot 1:
Screenshot 2:
Screenshot 3:
Screenshot 4:
Screenshot 5:
Screenshot 6:
Screenshot 7:
Close the workbook and navigate back to SFCodeBot. Click the hamburger icon under the Actions tab for the same iteration number. Select ‘Start Configuration’ option from the dropdown menu.
The Start Configuration popup will appear. Enter your credentials and some execution notes. Lastly, select the Plan Details checkbox, and hit Confirm and Start button.
Later on, you can click the information icon to monitor the progress of your iteration. Screenshots will be visible once changes are successfully pushed to the instance.
Once the status shows complete, go back in the workbook, and observe that a template has been added successfully as the row and its corresponding fields is now highlighted green. Meanwhile, the processing status has also turned to processed.
You can also confirm these changes by switching to 'Compensation Home' on SAP Success Factors and clicking on Import/Export Data under the 'Data for all Plans' heading.
Updated on: 18/05/2024
Thank you!