SBS Tranversal Costing is responsible to prepare the excel file and send the data base to RTR Service Center
SBS RTR SC Curitiba is responsible to upload the SKF to SAP.
Local site - Local accountants are responsible to check the figures in SAP
| Hide If | ||
|---|---|---|
| ||
Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Name the title of each section using OPD methodology naming convention - Infinitive verb without the “to”, mainly action verb...something) - " I do something..."5. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Domain: Country Accounting |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Responsibility area: N/A |
Table of contents
| Table of Contents | ||
|---|---|---|
|
1. Objective and Scope
1.1. Objective of this Operation
This document describes how to prepare the information related with HR SKF Ratios.
There are four types of SKF's ratios manageable by this procedure:
- ZZFTE – Full time equivalents;
- ZZHCT0 – Total number of employees (cadres and non-cadres);
- ZZHCT1 – Total number of cadres;
- ZZHCT2 – Total number of non-cadres.
1.2. Scope
This procedure applicable for all Service Centers in PF1 PF2 system:
- Service Center – Lisbon;
- Service Center – Curitiba;Service Center – Riga;
- Service Center – Bangkok.
2. Definitions
See Finance Glossary:
3. Tasks description
3.1. Responsibilities
SBS Tranversal CostingPlant Controller is responsible to prepare the excel file and send the data base to RTR Service Center
SBS RTR SC GBS RTR SC Curitiba is responsible to upload the SKF to SAP.
Local site - Local accountants are responsible to check the figures in SAP
3.2. I retrieve the data
Go to One Solvay page and then click in “My HR Services”:
Another page will be opened, select “Report” and then in “Headcount & Employee actions” – “Registered Active/active FTE – Non HR”
Now you will have access to the report used to upload SKFs, that may look like this:
In “Rows”, please elect “Country”, “Company Code”, “Cost Center”, “Employee Type”, “Employee First” and “Employee Last Name” in this order:
Then, extract the report in the “Export to Microsoft Excel”:
To retrieve the data, you should first have access to BW system and query BW_QRY_CPHRPANHR_0001:
After that, you will need to inform the closure month in the query, in this case, June:
After that, you will need to select the information necessary for the report in the BW Display:
After you have selected this information, the BW will bring you all the data that you need for the HR SKF report:
Save the file in another workbook, and Open the File that you have downloaded, and follow the instructions on “Instruction” Tab, from the HR_SKF template, from item 3 to 7.
After that the information is pasted on "Data" tab, filter the the “O” “K” column and select all the Service Centers available:
Now, for the following column, "L", you must filter by “#” to check the employees that have no cost center informed.
Check the “V” “R” column and you may find the cost centers that were informed by local accountants team leaders and managers to these employees, but were not updated on the report file.
You can also find some employees that does not have a cost center on the report and it also was not informed, so you need to ask for the information for the managers and local accounts in Google Drive, until D-5.
After D-5, in D-2 you will need do the same procedure to check the employees without a cost center, In case this information is not available, you may need to skip this employee for the update.
3.3. I upload the statistical key figures to SAP
After the previously step was done, check the tab "Computation" if there is anything missing or without reference. It should be automatically filled by the formula. This tab will determine the calculation made by “I,J,K,L” columns, which will be used to update the final SKF amount.
Filter for "SC -" in column D in tab "Computation", and select everything that is related to the Service Center:
In order to get only the data under the SC scope, you must copy and paste as value the information of Cost Center, Employee Group, ZZFTE0, ZZHCT0, ZZHCT1 and ZZHCT2 presented in the “Computation” tab on the A to F columns in the “Final Check” tab. The amounts of each Cost Center and type of SKF and employee will be summed automatically in the columns “SUM OF ZZFTE0/ZZHCT0/ZZCHT1/ZZHCT2”.
Please, be sure that all the cost centers that have information are taken into consideration in the sum in the tab "Final Check". You can do it by copying all the cost centers in column "E" in tab "Computation" and remove duplicates, and then pasting the cost centers:
In another workbook, you can paste it and remove all duplicates:
You can now paste the cost centers with values into the tab "Final Check" and it will be summed automatically:
If you have checked that all cost centers are being considerate and are sure that the sum is correct for all cost centers, you might save each SKF’s sums in a txt archive, deleting the cost centers with value zero:
The archives will look like this:
Now, you must run SAP Transaction Z1K_UPLOAD_RATIOS.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
End of document.
| Viewtracker | ||
|---|---|---|
|