Table of contents 


Scope

   

ERP

  

References

Attachments

Objective and Scope

This OP explains the steps necessary to update the Table for PURE FI COGEN companies in PF1_20.


Definitions

PURE FI Companies are companies without the MM module.

Pure FI Companies:

  • 0007 Hestia SA

  • 0269 ARYTINE DE CHAILLAC
  • 1420 Solvay Chlorovinyls Holding S.à.r.l.
  • 3442 Solvay Sisecam Holding AG, Wien
  • 4233 Solvay Finance Luxembourg SA

  • 6044 Solvay Hortensia S.A.

  • 6277 Solvay Energy Services Italia s.r.l.

  • 6294 Solvay Luxembourg S.à.r.l.  

  • 6306 Cogeneration Spinetta s.r.l. 

  • 6314 Cogénération Tavaux S.A.S.
  • 6320 EECO HOLDING BRUXELLES.
  • 8294 SOLVAY CHEMIE (SA)

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:

-Company code
-Vendor
-G/L account + Cost object (order or WBS element)


Validations to obtain:
A - In case there is a new company to be added - validation to be give by Luis Paliotes (PE Applicative Expert) and Andrea Pereira (IS&Design Accounts Payable Manager)
B - Modification to an existing company - Anyone can request the change but should be approved by the CAM


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



  • Create a folder for the year (YYYY) that is being reviewed (1)
  • Create a new Google sheet and Copy Paste Values from the original file to this one (2)


(1)

(2)




  • Create a separate tab for each CAM and keep only the following columns visible: 
    • Company Code
    • Vendor
    • G/L Account
    • Cost Center
    • Order
    • WBS element
    • blocked / Marked for deletion
    • Comment
  • For the blocked vendors, if a replacement is indicated in the vendor name, add it in the comments 



  • Share the link of the file with the respective CAM with CAD in copy


Email to be sent via Freshdesk to each CAM (Company accounting Manager)

SubjectPure 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 (add link) 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
  • The due date to reply to the email should be 15 days, on that date if no reply we should send a last reminder and close the case after 3 days if no reply.



Note:

Static ColumnsDynamic Columns (connected by Vlookup)

Company code

Company Name
VendorCompany Status
G/L Account

Vendor Name

Cost CenterVendor Status
OrderAccounting 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