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: Investments & Divestment



Responsibility area: Control SBS IS Projects


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

(remove the non-applicable icons)(error)

Frequency

5. Remove the icon(s) when not applicable

  D-3

 

 (remove the non-applicable icons) (error)

References

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



Forms

7. Insert the links accordingly and change the link text with the Form name



Attachments

8. Add the link to attachments or external links


 

 

I control CATS hours
<< >> Next operation



1. Objective and Scope

1.1. Objective of this Operation

Book the project allocation in cost center by accounting entries.

 

1.2. Scope

The scope of CATS posting for SBS IS is for all legal entities in PF1.


2. Definitions

Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary 

See Finance Glossary:


3. Tasks description

WHAT and HOW - Main content of the operation

The content should be mainly organized in 2 levels of Headings to ensure a proper link with the Table of Contents.

Select the level of heading in the "Paragraph" option.

3.1. I transfer the allocated hours into accounting

3.1.1. Run “CAT5” transaction in SAP PF1 System: Data Transfer CATS -> PS

The transaction is to run the CATS and book the project allocation in cost center by accounting entries.

3.1.2. Insert the personnel no. extracted in CADO report


3.1.3. Select the date in scope

Example, if the reporting is for April 2014, select from 01042014 to 30042014


3.1.4. In “Posting date” and “Posting date for cancellation” insert the last day of the month in analysis

3.1.5. Execute the transaction  (F8)

 

Note: At first time, always do a Test run to check if there are any errors generated.


 


3.1.6. Analyse the result given

  • The number of wrong entries are given by the summary on the top of this transaction result.

  • If some red points appear, you have to check and correct the data. For example: if the network is already closed, verify if it is correct to be closed. If not, reopen the network in transaction CJ20N. If it is ok to be closed, ask the controller what network should be used to replace in the hours allocated to this.

  • If no issue, go back in the green arrow, remove the sign in Test run and run CAT5 transaction again with the same parameters.

3.1.7. Run the transaction “CN30: Processing PDC error records” 

This is an additional control to check if there is no error records. The result must show the print screen:

 

3.2. I run the settlement rules for all related networks and WBS Elements

3.2.1. Go to transaction CJ8G - Actual Settlement: Projects/Networks 

3.2.2. Select the variant NETWORK

3.2.3. Insert the settlement period, posting period and fiscal year in scope


3.2.4. Click on the pencil figure  to change the variant

3.2.5. Paste the networks extracted from CADO and save

3.2.6. Go back and execute the transaction (F8) with “Detail list” flagged.

 

3.3. I extract and control the project allocation posting


You have to check the project allocation posting in SBS cost centers.

3.3.1. Run S_ALR_87013611 SAP transaction: Cost Centers: Actual/Plan/Variance: Selection

  • Select the period
  • Upload the SBS Cost Center list extracted from the Time Allocation google sheet
  • Insert the Cost element 9161000022 - IS-HOURS UNIT PRICE which is the one used for projects allocations

  • Execute (F8) 
  • Result: 
  • Select report "Cost centers: Actual line items"


  • Guarantee that you have the following layout:


  • List → Export → Spreadsheet to save to excel


3.4. I update the CATS monthly control file with the new postings

  • Copy the table of the previous step to the tab "Timesheet" of CATS monthly control
  • Exclude the totalizator lines (yellow)
  • Convert personnel number to number format
  • Eliminate the lines where personnel number is "0" or "blank"
  • Filter in the posting date, the dates referring to correction postings (middle of the month, example 15.04.2014) and in column Regul (AD) write "REGUL" for the lines showing. By doing so, we will only compare the posting of the month with the CADO extraction
  • Remove the filter and press F9 to refresh formulas
  • Verify if there are no N/A in the following columns
  • If there are N/A:
    1. Run transaction ZZJ20 to obtain the project details
    2. Enter the networks extracted in the timesheet
    3. Select only the field "Include activities in the result"

    4. Execute the report (F8) 
      1. Extract the result: List → Export → Local file → Text with tabs → Select the location of the file and change the type to Excel xls.
    5. Open the report and remove the columns C, D,F and N
    6. Copy the result to CATS Monthly Control file in the tab ZZJ20
    7. Press F9 to update the formulas and verify that there are no longe N/A results.

  • Refresh all pivot tables and verify if there are no differences between CADO and the Timesheet posted in the pivot tables showing in tabs "1 CRTL" and "1 CRTL PROJET".
    Note: Remember to always remove the REGUL from the filter selection:

  • In tab "RECAP" create a new line for the current month, and paste the hidden pivot table to the lines below that line (from column K).
    Then replicate the pivot table with the calculation of the Qty Days and Eq FTE.
  • Save the file with the name "CATS Monthly Control MM/YY"

3.5. I share the CATS monthly control file with IS Controllers

Upload the file in the Google Drive for the month in scope and send an email to the IS Controllers communicating that the posting for the current month has been made.

End of document.