Table of Contents
<style> .toc-macro ul {display: block; counter-reset: item} .toc-macro li {list-style-type:none} .toc-macro li:before {content: counters (item, ".")". "; counter-increment: item} </style> |
OBJECTIVE AND SCOPE
Objective of this Procedure
This document's objective is to provide a guide to ZPRC, ZMAT (raw and manufactured), ZVER, ZERS, ZBOM, ZUNB and PIR Material master data management for GBU Composite Materials (Legacy Cytec organization).
Material Master Data management process includes creation and modification of the material, its inactivation and flagging for deletion, and reactivation if needed, as well as mass modification.
Creation of Basic Data, Classification, Sales, Foreign Trade, Purchasing, General Plant Storage, Warehouse Management and Label Data Views will be presented in this procedure. Management of MRP, Work Scheduling, Quality Management, Accounting and Costing Views is being performed by Process Teams. Accounting and Costing views are created by Riga Data Operations when extending materials to Trading Plants. For Sample codes Riga Data Operations is creating all necessary views.
Requests of Composite Materials Material Master creation or maintenance should be submitted via Sharepoint platform which will send out an automatic FreshDesk ticket to Data Team within which the material maintenance should be done.
The referral lists mentioned in this procedure, such as Material Groups, Purchasing Groups and Profit Center List are embedded in Sharepoint platform already.
Scope
Under Riga Data Operations scope is the management of ZPRC, ZMAT (raw and manufactured), ZVER, ZERS, ZBOM, ZUNB and PIR Material master data management for GBU Composite Materials (Legacy Cytec organization). Riga Data Operations can create and extend ZDIE materials if requested so by Finance.
Material Type | Description | Division |
|---|---|---|
ZPRC | Commercial Products | N/A |
ZMAT | Finished Goods | Multiple |
ZVER | Packaging | WD |
ZUNB | Stocked and non-valuated materials | WD (for packaging) |
ZDIE | Services | Multiple |
PIR | Purchase Info Record | |
| ZERS | Industrial supplies | |
| ZBOM | Phantom assemblies |
Abbreviations
Abbr. | Description | Abbr. | Description |
|---|---|---|---|
RCS | Rhodia Core System | SBS | Solvay Business Services |
ZDIE | Service | UoM | Unit of Measure |
ZMAT | Finished product, semi-finished product, raw material | HSE | Health, Safety and Environment |
ZPRC | Commercial Product | MSDS | Material Safety Data Sheet |
ZUNB | Stocked and not valuated material | MRP | Material Resource Planning |
ZVER | Packaging | DG | Dangerous goods |
| DGL | Data Governance Lead |
Roles and responsibilities
ZMAT setup can be performed only once both ZPRC code and MSDS are available.
Prior to submitting a new ZMAT request, it is the requester´s responsibility to ensure the material does not exist in SAP already, so no duplicates are created in the system. If the material was not found, the TS SAP Material request form or Composite Materials Sharepoint must be filled and submitted to Data Operations for material master setup in SAP. A second search in the system is performed by the Data Management team to ensure no duplicates are created.
STANDARD OPERATING PROCEDURE DESCRIPTION
Creation of material in RCS
Pre-requisites
Manufactured ZMAT setup can be performed only once both ZPRC code and MSDS are available. Prior to material creation in the system search is performed by the Data Operations team to ensure no duplicates are created.
- Use the transaction MM03 to access display material view
- Press multiple choice button to receive pop-up window with search options for material master.
- Click on
to open the menu - Select the option 'Material Number/Material Description' and/or 'Materials by Commercial Product (PRCOM)'
- Run a search in Material Description
- Use Wildcards to best describe
- Open the material request form, copy the short text from the requested material and run a search in Material description with wildcards.
- Hit Enter
- Verify entries found – compare results with the material's "short description" mentioned in the request form. If you have doubts about the material already created, contact the Requester to clarify.
- If result points to
or if the Requester mentions a new article need to be created then proceed with the creation. - Note: for GBU Composites, even though the new material is a duplicate, the requester may still want to have the new duplicate material created. Such duplicates are then distinguished from each other by the field 'Old material number'. As stated above, contact the Requester to clarify.
Creation of ZMAT - Manufactured Material
Use MM01 transaction to create material
| Main activities | Key points |
|---|---|
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | Select the material type indicated in the request form |
| Copy from… Material | Option to copy data from an existing material can be useful in some cases. |
| Hit Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Classification (General data)
- Sales organization views
- Sales: Sales Org. Data 1
- Sales: Sales Org. Data 2
- Plant data views
- Sales: General/Plant Data
- Foreign Trade: Export Data
- Purchasing
- General Plant Data Storage 1
- General Plant Data Storage 2
- Warehouse level
- Warehouse Management 1
- Warehouse Management 1
- Quality Management
- Label data (General data view)
Before creating the Manufactured Product for For Composite Materials (Aero) check if there is a ZUNB already created! |
| Use Default Setting button to save your selections for future creations |
Hit Enter
- Fill in Organizational Levels
- Plant: as indicated in request form. If the plant is 8368 or 8370, always extend it to plant 8818 using the information in the overflow file details. Just follow the same procedure for the initial plant request.
- Storage location: check the GBU Composite Materials file and open the material for the active (not scratched) storage locations correspondent to each plant that does not have an "X" in the spare column or ''DO NOT USE'' included in the locations description.
- Sales Organization/Distribution channel: open to the External Sales Organization listed with an "X" at the Distribution channel on the GBU Composite Materials file.
- See example below for plant 8350: the material is allowed to be created/extended to Sales Organization GB40, US37 and US32/ See Picture Example
- Extension to CN sales organization, require approval by the Product Line Manager, Export Compliance Team, Sales Manager from China and add Plinio Morgonni in CC.
- Always extend to Distribution channel 0A.
- See example below for plant 8350: the material is allowed to be created/extended to Sales Organization GB40, US37 and US32/ See Picture Example
Sales areas US33/0B/0A only to be used for materials with ''CDM'' included in the description |
|
- Warehouse: Always extend to Warehouse number based on the GBU Composite Materials file per plant in sheet IM-WM
- Example: For plant 8350 (Wrexham) extend to Warehouse number 087
- Hit Enter
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
button to add languages. Copy English text to all other languages:
button and exit material creation
Creation of ZMAT - Raw Material
Use MM01 transaction to create material
| Main activities | Key points |
|---|---|
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | Select ZMAT |
| Hit Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Classification (General data)
- Sales organization views
- Sales: Sales Org. Data 1
- Sales: Sales Org. Data 2
- Plant data views
- Sales: General/Plant Data
- Foreign Trade: Export Data
- Purchasing
- Foreign Trade: Import Data
- General Plant Data Storage 1
- General Plant Data Storage 2
- Warehouse level (for specific plants)
- Warehouse Management 1
- Warehouse Management 1
- Quality Management
- Label data
Hit Enter
- Plant: as indicated in request form
- Storage location: Check the GBU Composite Materials file and open the material for the active (not scratched) storage locations correspondent to each plant that does not have an "X" in the spare column or ''DO NOT USE'' included in the locations description.
- Warehouse: Open to correspondent warehouse listed on the GBU Composite Materials file
- Sales Organization / Distribution channel: Open only to the Intercompany Sales Organization listed with an "X" at the Distribution channel 0A on the GBU Composite Materials file.
- See example below for plant 8350: the material should be created/extended to Sales Organization GB40 and US37 / Distribution channel 0A
- Extension to CN sales organization, require approval by the Product Line Manager, Export Compliance Team, Sales Manager from China and add Plinio Morgonni in CC.
- Always extend to Distribution channel 0A.
If we receive a request to extend the raw material to distribution channel 0B, a workflow in Sharepoint needs to be created using the Change flow and the EHS approval (Barbara Platt or Justin Bender) needs to be attached to the flow. |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Creation of ZVER - Packaging
Use MM01 transaction to create material
Main activities | Key points |
|---|---|
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | Select the material type indicated in the request form |
| Copy from… Material | Option to copy data from an existing material can be useful in some cases. |
| Hit Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Sales organization views (if sales organization and distribution channel are provided)
- Sales: Sales Org. Data 1
- Sales: Sales Org. Data 2
- Plant data views (if plant is provided)
- Sales: General/Plant Data
- Purchasing
- General Plant Data Storage 1
- General Plant Data Storage 2
- Warehouse level
- Warehouse Management 1
- Warehouse Management 1
- Hit Enter
- Fill in Organizational Levels
- Plant: as indicated in request form
- Storage Location: check the GBU Composite Materials file and open the material for the active (not scratched) storage locations correspondent to each plant that does not have an "X" in the spare column or ''DO NOT USE'' included in the locations description.
- Sales Organization/Distribution channel: open only to the Intercompany Sales Organization listed with an "X" at the Distribution channel 0A on the GBU Composite Materials file.
- See image below for plant 8350: the material should be created/extended to Sales Organization GB40 and US37 / Distribution channel 0A
- Warehouse: Open to correspondent warehouse listed on the GBU Composite Materials file
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
For every packaging creation and extension, the PIR and Source List should be requested within the same request.
Creation of ZBOM- Phantom
Requester should provide us with correct Description and Plant where material should be created.
2 types of ZBOM:
- Packaging Kits (BUOM EA - Division WD) → assemble from 2 parts of packaging (combination, not consumed, it is a steps in the process, does not have inventory)
- Pre-mixes (BUOM EA - Division provided) → materials that are being used for BOMs
Create the material through MM01 transaction.
Enter Industry Sector and Material type:
| Main activities | Key points | |
|---|---|---|
Enter Industry Sector | Always choose “Chemical Industry” | |
| Enter Material Type | Always ZBOM for Phantom assemblies | |
| Copy from… Material |
|
Select views to be created:
- Basic Data 1
- Basic Data 2
- MRP 1
- MRP 2
- MRP 3
- MRP 4
Fill in Organizational Levels.
- Plant: copy from the template
Sales Organization and Distribution Channel should not be filled |
|
button and exit material creation
Creation of ZERS - Industrial Supplies
Create the material by creation transaction:
| Main activities | Key points |
|---|---|
| Enter transaction MM01 | Full path: Logistics -> Materials Management -> Material Master -> Material -> Create |
| Enter Industry Sector | Always choose “Chemical Industry” |
| Enter Material Type | Always ZERS for Industrial Supplies |
| Copy from… Material | If applicable, make sure to edit the data that differentiates current material from the previous one |
| Press Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Plant data views
- Purchasing
- Purchase Order Text
- MRP 1
- MRP 2
- MRP 3
- MRP 4
- General Plant Data Storage 1
- General Plant Data Storage 2
- Accounting 1
- Accounting 2
Select views to be created:
Fill in Organizational Levels:
| Main activities | Key points |
|---|---|
| Plant number | Check the template |
| Storage Location | Check the template |
For Al Ain 8430 plant. always extend to CENT storage location and 096 Warehouse.
|
Creation of ZPRC - Commercial Products
It is in Data Management scope to create ZPRC records for Raw Materials when requested comes from HazCom Team. When ZPRC record is completed in SAP WP1, systems are being synchronized overnight and PRCO code appears on HazCom side.
To complete this request material chemical name should be verified and provided by HazCom Team.
Use MM01 transaction and populate:
Main activities | Key points |
|---|---|
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | ZPRC |
| Copy from… Material | Option to copy data from an existing material can be useful in some cases, e.g. if you need to create multiple similar materials |
| Hit Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Classification (General data)
- Label data (General data view)
|
All changes to ZPRC's for Manufactured Materials should come via Justin Bender or Plinio Morgonni. Changes to ZPRC should NOT come through SharePoint. |
Creation of ZUNB - Stocked and non-valuated materials
Use MM01 transaction to create material
Main activities | Key points |
|---|---|
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | Select the material type indicated in the request form |
| Copy from… Material | Option to copy data from an existing material can be useful in some cases. |
| Hit Enter |
Select Views to be created:
- Basic Data 1 (General data)
- Basic Data 2 (General data)
- Puchasing (Plant data)
- Quality Management - *Only for Material Group 0451
- Label data (Genera data)
- Fill in Organizational Levels
Extend to the following plants:
7264 ZZZZ ex 3969 / Négoce IT
7265 ZZZZ ex 3969 / Négoce DE
7266 ZZZZ ex 3969 / Négoce GB
7267 ZZZZ ex 3969 / Négoce FR
8269 ZZZZ ex ZUS4 / Trading USA
8577 ZZZZ ex 7776 / Trading CN
|
Overflow process
It is an additional extension with 0A (intercompany) distribution channel to Overflow warehouses for material storage purposes in case the original warehouse for the plant is full.
Applicable to the following plants, but might be requested as additional extension by some other plants and also specified in the Distr Center field in the request form (example: Heanor can request additional extension to 8818).
Those to be setup only when additional Overflow Extension request is received after the completion of the main request by all the teams. And done as a copy of the Manufacturing plant extension, process below.
- 8367 - 7180 Piedmont
- 8350 - 7771 Wrexham
- 8368 - 7180 Havre de Grace
- 8400 - 7771 Heanor (note: it is not possible to share 8802 K&N extension between 8400 Heanor and 8350 Wrexham, since setup is different)
Reference document to check the fields to be changed based on the plant. Source lists should be requested to create from the plants to Overflow (from 8350 to 8802) and additional PIR's will be specified in the request.
Extend the material by creation transaction:
| Main activities | Key points |
|---|---|
| Material | Material number to be extended for overflow warehouse |
| Industry Sector | Always choose "Chemical Industry" |
| Material Type | |
| Copy from… Material | Material number to be extended for overflow warehouse |
Select views to be created:
Fill in organizational levels:
| Main activities | Tips / Best practises | Key points |
|---|---|---|
Plant | As per plant | |
Storage location | As per plant | |
| Sales organization | As per plant | |
| Distribution channel | As per plant | |
| Warehouse no. | As per plant |
No changes on the views, just pass through and open the material for Sales: Sales org. 1, Sales: Sales org. 2.
Press enter and Go to Sales: general/plant view
|
For the second overflow plant we can copy from the just created extension.
There is no need for SalesOrg and Warehouse views.
Now go through all the views without making any changes,except for MRP2, where Storage loc. For EP should be changed to correspondent plant:
Once you are all through other views without changes, save the material.
After the material is saved, create a request to the PSL Team to make necessary Source lists for:
- Shipments from the Main plant to the Overflow plant
- Shipments from the Overflow plant back to the Main plant
Material extension
Composite Material extension requests to new plant or sales org should come through Sharepoint.
Extension requests to China sales org/dc’s can be accepted from Catherine Lu - via Service One:
To process Catherine Lu's requests:
|
| Main activities | Tips/Best practices | |
|---|---|---|
| Enter transaction MM01 | Full path: Logistics -> Materials Management -> Material master -> Material -> Create (General) T-code can be entered directly in Command field. T-code can be saved in Favorites | |
Select Material, Industry Sector, Material Type | Material is the material number that needs to be extended Industry Sector always C Chemical Industry Material Type the same as the material that is being extended Copy from… option can be used, preferably to copy from an existing view of the same material |
|
| Select the necessary views for the extension | For sales org extension select sales organization views for all applicable material types Sales Organization views:
For plant extension select plant views according to the specific material type To determine which plant view needs to be opened, please see material creation section for each matrial type Plant views:
| |
| Select Organizational levels | To determine which organizational levels need to be selected, please see material form and material creation section for each matrial type |
|
| Save the changes performed | If the plant has other available sales orgs in file, please extend to those as well Note! Don't forget to extend the material to the new plant's storage locations and warehouse according to material type |
For Plant extensions, in case Freight group is missing:
|
Material modification
Manual material modification
Composite Material change requests can come through Sharepoint or Freshdesk.
Please see file to check which should be used for the particular change request - Sharepoint or Freshdesk.
In this file you can also find whether you have to get an approval for the change, as well as the correlated fields.
| Main activities | Tips/Best practices |
|---|---|
| Enter transaction MM02 | Full path: Logistics -> Materials Management -> Material master -> Material -> Change T-code can be entered directly in Command field. T-code can be saved in Favorites |
| Select the view containing the field that needs modification | |
| Select the Organizational Level for which the modification is requested | |
| Make the requsted update | Repeat the modification for all Sales Areas or Plants if applicable |
| Save the changes performed |
Material mass modification
Material master mass modification is performed when a change of a value in the same field(s) for a list of materials needs to be carried out.
Requester should submit a Freskdesk ticket with an attached file indicating the necessary changes.
Note! Mass update requests for all material master information require approval from the CM EDA (Plinio Morgonni) before updates are made. Data Governance Lead should be informed.
Note! Mass update requests for MRP 1-4 view information require Plinio Morgonni's approval and an additional approval from Susan Lloyd Kane, or George Helton, or Andrew Jazwiecki before updates are made.
| Main activities | Tips/Best practices | |
|---|---|---|
| Enter transaction MM17 | Full path: Logistics -> Materials Management -> Material master -> Material T-code can be entered directly in Command field. T-code can be saved in Favorites | |
| Select the Table(s) containing the field(s) that need to be modified |
| |
| Go to Fields tab | ||
| Select the Field(s) that need to be modified | Use search option to easily find the field to be changed. Use technical name of the field in search. You can find out technical name of the field pressing F1 when field is selected and pressing Technical Information button |
|
Press Execute button | ||
| Limit selection as much as possible to perform the change only for the materials that need it | Use additional options on the bottom of selection screen to amend selection options or add/remove selection fields if necessary Press Execute button |
|
Press Execute button | ||
| Enter new value | New value(s) has to be entered in the designated space above list of materials It is possible to deselect records that do not require change Press 'Perform mass change' button to copy the value to selected materials Press 'Test changes' button to make system check the changes without saving them |
|
| Check log of changes performed in Test mode | Green light indicates successful change Yellow light indicates a warning Red light indicates data change is not possible/allowed |
|
| Save the changes performed | Check log of changes performed | |
| Mass change of data can be performed also by importing data from file or clipboard |
|
Mass changes performed using MM17 is not triggering data transfer to WPX. To solve this issue we have two options.
- Use other tools like LSMW, Process Runner or other programs to perform mass changes
- Use MM17 as usual, but once the changes are made, manually push the material codes to WPX using the BD10 transaction.
Message type to be used is ZWXMATMAS
Logical system is WPXCLNT400
Appendix – List of approved requestors
Composite Materials Master Data Governance Who's Who - link where you can find the appropriate person for specific roles per site.
Appendix – Solstice Aero Material Master Views and Fields
Link to Solstice Aero Material Master Views and Fields
Appendix – DG indicator updates
Requests can be received from:
- Barbara Platt - Barbara.platt@solvay.com
- Justin Bender - justin.bender@solvay.com
Check for other materials with the same ZPRC and put the same DG indicator to the newly created material. Then add it in the file for Barbara and Justin to verify it is ok. If the ZPRC is new then add the material details in the file.
Once the DG has been updated, check if the transportation group matches with the DG indicator. If it does not match, update the transportation group according to the DG indicator and add Frank Valendo (frank.valendo@solvay.com) in copy of your reply.
Please see example below where the transp. group must be changed due to the DG indicator update:
- DG Indicator is GPP (hazard)
- Transportation group 0001 - Packed
Note! Transportation label should not be maintained, since this information is stored by the plant
Appendix – SharePoint Workflow Management Tool
Link to the presentation. Please check presentation for detailed information on the tool.
Appendix – List of approvers ZERS
| ZERS (Materials with Division WA) creation/modification/deletion | |||||
|---|---|---|---|---|---|
| Plant | Buyer | ||||
| 8367 | 7180 Piedmont | US | Kay Drake | ||
| 8456 | 7180 Kalamazoo | US | |||
8785 | 7180 Rock Hill | US | |||
8350 | 7771 Wrexham | GB | Ken Sharp | ||
| 8361 | 7180 Orange | US | Michael Enes | ||
| 8363 | 7180 Anaheim D'Aircraft | US | |||
| 8364 | 7180 Anaheim | US | |||
| 8365 | 7180 Greenville, TX | US | Michael Adler | ||
| 8368 | 7180 Havre De Grace | US | |||
| 8370 | 7180 Winona | US | |||
| 8347 | 7772 Oestringen | DE | Steffen Schweickert | ||
Appendix – Material Inactivation
Requests via Service One ticket from Quality Manager or Data Governance Lead, request approval from Product Line Manager by material division and put Plinio Morgonni in CC.
Before inactivation material should be checked for open items under "Stock overview"
If there are no open activities, Stock will show only "0". If any other values displayed, appropriate Product Manager should be contacted for Stock removal.
| Level | Inactivation |
|---|---|
| Global | After Stock is cleared material can be inactivated.
|
| Local | Note! For local inactivation the plant might request the value to be populated in SAP, proceed with the inactivation with the values provided in the ticket If material has to be inactivated for specific sales areas
If material has to be inactivated for specific plants
|
Note! ZPRC (Material group 0450) inactivation needs to be performed by Plinio Morgonni (Composite Materials) after all the ZMATs are inactivated.
<style>
#backToTopButton {
position: fixed;
right: 20px;
bottom: 20px;
Z-index: 1;
}
#ReqForTaxNr {
overflow: auto !important;
}
</style> |