Table of contents
By default the table of contents displays Heading 1 & Heading 2 (other levels can be added)
Scope
1. Remove the icon(s) when not applicable
2. Add countries when the procedure is for a specific country (optional)
ERP
3. Remove the icon(s) when not applicable
References
4. Add the link to SAP procedures (when it exists)
Attachments
5. Add the link to attachments (to be stored in AODocs or GDrive) or external links
Objective and Scope
This OP explains the steps necessary to update the Table for Corporate Functions in PF1 & WP1 systems.
Definitions
Corporate Functions are
Table ZKF_ACC_VEND - Maintain
Generic inputs
Transation: SM30
Table: ZKF_ACC_VEND
Choose Maintain and now you will be able to update, create or delete a record.
Information mandatory to be provided:
Annual Review
The annual review is done by Data Operations Lisbon Team, normally in the middle of the year and the final report should be sent to each Company Accounting Manager.
The Template Annual Review should be used and all data should be storage in the Shared drive.
Extract the data available in SAP
- SM30, table ZKF_ACC_VEND
- Select No Restrictions and Display
- The table will be displayed (1)
- Click on Table View and select Print (2)
- Click on the mouse right button and choose Spreadsheet
- Copy (CTRL + SHIFT + V) this list to Sheet FI Table on Template Annual Review (3)
(1) 
(2) 
(3) 
- SE16 table LFA1
- Select all suppliers from ZKF_ACC_VEND extraction, add on Vendor field and run (1)(2
- Click on the mouse right button and choose Spreadsheet (2)
- Copy (CTRL + SHIFT + V) this list to Sheet LFA1 on Template Annual Review (3)
(1) 
(2)
(3) 
- SE16 table LFB1
- Select all suppliers from ZKF_ACC_VEND extraction, add on Vendor field and run. (1)
- Click on the mouse right button and choose Spreadsheet
- Copy (CTRL + SHIFT + V) this list to Sheet LFB1 on Template Annual Review (2)
- Make sure the company code is format with ""0000"" + Plain Text.
(1) 
(2) 
- Press/Run Prepare Data, on tab Readme Opsthis will arrange data in Annual Review Tab
- Hide Readme OPS, FI Table, LFB1 and LFA1
- Share with CAMs with CAD in copy
Email to be sent via Freshdesk to each CAM (Company accounting Manager) | |
| Subject | Pure FI Companies - Annual Review yyyy - Accounting Manager Name |
|---|---|
| Text | Dear colleague, good afternoon. Following our annual internal audit review related to Pure FI Companies (Table with the necessary FI elements for the companies without MM module), we will need your support to review the values under this table and confirm if they are accurate. We added two columns with the information of the obsolete vendors and their replacement (when available). Based on this, please reply to this email by dd/mm/yyyy. In case of support, assistance, or any further clarification needed, please don't hesitate in contacting us. Your confirmation is key to ensure the proper flow in our organizations. Thank you in advance for your help. |
Info: Template created in Freshdesk - Pure FI Annual Review
- Once Annual Review is over, make a copy of this file and store it on corresponded year folder for historic record - Shared Drive
Note:
| Static Columns | Dynamic Columns (connected by Vlookup) |
|---|---|
Company code | Company Name |
| Vendor | Company Status |
| G/L Account | Vendor Name |
| Cost Center | Vendor Status |
| Order | Accounting Manager |
| WBS Element | Accounting Director |
- After reply, the table should be updated following the CAM's indications
- SM30, table ZKF_ACC_VEND
- Select No Restrictions and Maintain
- Delete the old table and add all new entries.
- Click on Table View and select Print (1)
- Click on List and select Print
- Output Device ZPDF
- An email will be sent to our personal mailbox with the table in PDF format that should be sent to the reviewers confirming that the updates have been done has requested. (2)
(1) 
(2) 
- After, reply to the email informing the CAM that the updates have been done as requested, with the print attached and close the case.
End