Table of contents
Scope
ERP
References
Attachments
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
Key points
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*
Tips / Best practices
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)
Key points
Your Scope is retrieved
12. Afterwards filter the column : and choose last day of the current year 31.12.201x
VPer.end
Key points
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
Important note
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
Tips / Best practices
We should only select the fields we need to modify to avoid errors
19. Select field Validity End
20. Insert contract/s number/s
Tips / Best practices
Obtained on excel file
21. Enter the new validity end date
Tips / Best practices
Should always be 31.12.N+1
22. Hit Carry out a Mass Change
Tips / Best practices
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.
Important note
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
Tips / Best practices
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
Tips / Best practices
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.
