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


Tasks to be completed when documenting an operation (from creation to publication)

 1. Enter the Title of the operation / page

2. Add the following Labels : 

    • Scope of applicability: ww, country_accounting 

    • Country or group of countries (if applicable): belux, china, france, italy, lam, nam, uk_ie, bulgaria, dach, netherlands, iberia, poland, latvia, australia, india, japan, south_korea, thailand, singapore, new_zealand, emea_transversal, apac_transversal

    • Unit and Domain according to the List of labels to be used in the Finance Service Line space

      • E.g. 1: WW Operation in Financial Accounting under domain "Central Finance Processes & Compliance":
        • Labels to be used: ww, financial_accounting, central_fin_proc_compliance

      • E.g. 2: France Operation in Financial Accounting:
        • Labels to be used: country_accounting, france, financial_accounting
          (for country operations, the Domain is always country_accounting)


3. Fill in all fields as described above

4. 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 




Domain: Country Accounting



Responsibility area: N/A


Table of contents 

By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)



Scope

3. Remove the icon when not applicable


ERP

4. Remove the icon(s) when not applicable


Frequency

5. Remove the icon(s) when not applicable

 

References

6. Add the link to SAP transaction(s) (when it exists)

Z1K_ACTUAL


Forms

7. Insert the links accordingly and change the link text with the OP nam

HR SKF Upload TEMPLATE


Attachments

8. Add the link to attachments or external links



Previous OP << >> Next OP



1. Objective and Scope

1.1. Objective of this Operation

This document describes how to prepare the information related with HR SKF: 

  • 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 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 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


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”:

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” column and select all the Service Centers available:

Now, for the following column you must filter by “#” to check the employees that have no cost center informed.

Check the “V” column and you may find the cost centers that were informed by local accountants and managers to these employees.

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, you need to fill the “G” column in the tab “Computation” with the same information that you have on the “Data” tab, adding the cost center and the employee name to the same cell. These cells will determine the calculation made by “J,K.L,M,N” columns, which will be used to update the final SKF amount.

Now, you must copy and paste as value the information of Cost Center, Name, Employee Group, ZZFTE0, ZZHCT0, ZZHCT1 and ZZHCT2 presented in the “Computation” tab on the A to G columns in the “Upload” 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”.

You can select some cost centers to check if the sum is equal to the “Data” tab, for example:


If you have checked some cost centers 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.




End of document.