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 |
| Domain: 1. Enter the Domain identified in OPD matrix (for Country specific operations, Domain = Country Accounting) |
Responsibility area: 2. Enter the responsibility area described in OPD matrix ("N/A" for Country Accounting Operations) |
The procedure is applied to entity Cytec Engineered Materials Limited (UK WP1) (SAP code 7771).
Definitions should be added in the Finance Glossary - Add definition and link it to respective Letter in Finance Glossary
See Finance Glossary:
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.
Transaction: KE24
Operation concern: Z006
Variant: FERRAR
Layout: /FERRA

Then I extract the data to Spreadsheet.

Open the download from SAP:

Download the sheet Blank from Drive to Excel so I can compile the data.
https://drive.google.com/drive/folders/1smevpLH_K6wvHEj19EUXKKQJfcec_r9m
When downloaded, I will copy the information from SAP to sheet KE24.

Paste using Special Paste (Values only).
Make sure that the formulas in columns T and U are applied to all the rows.
Filter on the column T only the "YES"

Here I copy all the data from column A to S and paste to sheet Calculations.
Then return to sheet KE24, clear the filter in the column T and Select all again.
Now filter the column U only with "YES" too.

Copy all the data from column A to S and paste to sheet Calculations.
Then return to sheet KE24, clear the filter in the column U and Select all again.
Return to sheet Calculation and make sure that the formulas in columns T, U and V are applied to all the rows.
When in column U I have a "YES", I don't need to change any formulas.
When in column U I have a N/A, I need to insert the column corresponding to "Ship-To Party", column I.

Calculate SUM:
![]()
And copy the result to sheet Summary.
Open the previous month file and update Excel Summary sheet with the amounts from previous months.
Note: Material&Customer - Do not change unless I receive some communication via e-mail. Always confirm requested modifications with Gerald Perrin or Anne Perazio.
In the end, send an email to info@aeroteam-to.it with the file.
...