Table of contents

Scope

ERP

References

Attachments

5. Add the link to attachments (to be stored in AODocs or GDrive) or external links

1. INTRODUCTION

This OP explains how to modify/update contracts on Rhodia Legacy system (WP1/RCS).

2. STANDARD OPERATING PROCEDURE DESCRIPTION

2.1. Extend the validity date of Contract – Cadres (at end of the year)

The purpose is to avoid any blockage on the orders at beginning of the year.

2.1.1. Pre-requisites

1. Enter SQ00 and Enter

Allows to have a report of all contracts with Valid date of end –of-year

2. Select button " Other user group"

3. Choose Query ZW_PU – Corporate Purch. & Procurement

 

4. Choose Sub-Query : PURCH_CONT_HEA

5. Execute 

 

6. Purchasing document : Insert 47*

To restrict old contracts (not valid anymore

7. Purchasing Org.: Insert 3004 or 3001

8. Purchasing document catalogue: ZWK – Cent. Value Contract

9.  End of Validity Period: Insert: 31.12.201x (N+1) and execute 

 

10. Export the output into format Excel (Spreadsheet)

11. Filter the output according to P. Grp (France Sites)

Your Scope is retrieved

12. Afterwards filter the column : and choose last day of the current year 31.12.201x 
VPer.end

The output should be only contracts that are still active

2.1.2. Update of contracts validity end date

2.1.2.1. Update contract validity end date manually

13. Enter ME32K

* The validity end date on contract is modified at header level and not at lines level (These are created as validity date xx.xx.9999

 

 

14. Insert the contract number 47*

 

15. Go to  Header Details

 

16. Go to  Header Details and modify the year (N+1)

 

2.1.2.2. Update contract validity end date in mass

17. Enter transaction MEMASSCONTRACT

This transaction should be used with maximum precaution. It allows modifying in MASS almost all contract fields and this may cause several problems if not used carefully.

Selecting Tables:

In mass maintenance, you must decide which tables of an object type are to be changed. It is possible to make changes in several tables at the same time. If you select several tables, only objects that meet your selection criteria in every table will be selected.

With the contract numbers obtained on step 2.1.1. Pre-requisites of this manual is possible to modify in mass all these contracts validity period end.

 

18. Select Fields tab

We should only select the fields we need to modify to avoid errors

19. Select field Validity End

20. Insert contract/s number/s

Obtained on excel file

21. Enter the new validity end date

 Should always be 31.12.N+1

22. Hit Carry out a Mass Change

Confirm if only the needed contracts will be maintained

23. Hit Save and all contracts will have this new validity date

2.2. Transaction MEMASSCONTRACT

This transaction allows modifying almost all fields on a contract.
Should be used if we received a request to modify several contracts in a specific field to just one specific value, as per example:

  • Validity period end (MASSEKKOCONTRACT-KDATE)
  • Payment Terms (MASSEKKOCONTRACT-ZTERM)
  • Purch. Group (MASSEKKOCONTRACT-EKGRP)
  • Incoterms (MASSEKKOCONTRACT-INCO1)
  • Etc.

This transaction should be used with maximum precaution. It allows modifying in MASS almost all contract fields and this may cause several problems if not used carefully.

2.3. Transaction ZWPU20A

This transaction allows modifying through excel file (download/upload) the fields related with the lines inside the contracts, per example:

  • Price
  • Start/End of price
  • Tax code
  • Etc.

24. Enter in transaction ZWPU20A

25. Fill the necessary information to obtained the desired contract/s line/s 

Use the provided information (contract number, material number, plant, etc.)

26. Select the path for file download

The file downloaded should be opened by excel (original file in TXT format) and all modifications should maintain the original format. To save should be selected SAVE AS and used TEXT on file type to be saved.

27. Fill the path for the new data file to be uploaded and run

Should be made other extraction after uploading to ensure that that was correctly modified.

2.4. Transaction ZWPU084

The objective of this transaction is to align the information between material short description master data and material short description inside a contract (contract line for that material).

Whenever we update a short description on a material (MM02) if this material is being used on a contract this new description will not be automatically updated, so we need to check if that material is used on a contract and perform contract line short description manually (one-by-one) or automatically through this transaction.

Do use this transaction we need to have some mandatory fields:

  • Company Code
  • Purchasing Doc. Type
  • Material Modification Date
  • Validity Period End

 

First always run in 'Test run' and if the result is the expected one proceed with the mass modification.